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 |