Database – Base Variable (base_variable_entity)
Description
Base variables are used as a base when setting a date through rules applied.
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 | tinyint1) | This specifies if the base variable has been deleted. | 1 - yes 0 - no |