Database - Base Variable (base_variable_entity)

Description

Base variables are used as a base when setting a date through rules applied.

Common Uses

Table Fields

Column

Data Type

Column Info

Value Notes

id

INT(11)

The ID or identifier of the base variable.

name

VARCHAR(255)

The name of the base variable.

variable

VARCHAR(255)

Specific variables from the context engine.

type

ENUM(...)

The type of variable related to the base variable.

DATE, CURRENCY, NUMBER

created

DATETIME

The date that the base date was created.

lastUpdated

TIMESTAMP

The date the base variable was last updated.

active

TINYINT(1)

This specifies whether the base variable is active or not.

1 - yes, 0 - no

deleted

TINYINT(1)

This specifies if the base variable has been deleted.

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)