VARIANT_VALUE 0
Description
This table stores information about variant values.
Columns
| Column Name | Data Type | Description |
| ID | bigint | Primary key column for the table |
| BOOLEAN_VALUE | bit | Stores the boolean value of the variant value |
| DATE_TIME_VALUE_ITEM | datetime | Stores the date and time value of the variant value |
| DOUBLE_VALUE | double | Stores the double value of the variant value |
| INTEGER_VALUE | int | Stores the integer value of the variant value |
| LONG_VALUE | bigint | Stores the long value of the variant value |
| STRING_VALUE | varchar | Stores the string value of the variant value |
| TIME_VALUE_ITEM | time | Stores the time value of the variant value |
| AGGREGATION_DURATION_VALUE_V_0 | bigint | Stores the ID of the aggregation duration value associated with the variant value |
| DURATION_VALUE_VARIANT_VALUE_0 | bigint | Stores the ID of the duration value variant value associated with the variant value |
| GEOFENCES_VALUE_VARIANT_VALU_0 | bigint | Stores the ID of the geofences value variant value associated with the variant value |
| POIS_VALUE_VARIANT_VALUE 0_0 | bigint | Stores the ID of the pois value variant value associated with the variant value |
| STRING_LIST_VALUE_VARIANT_VA_1 | bigint | Stores the ID of the string list value variant associated with the variant value |
Foreign Key Relationships
- POIS_VALUE_VARIANT_VALUE 0_0 references POIS_TYPE(ID)
- STRING_LIST_VALUE_VARIANT_VA_1 references STRING_LIST_VALUE 0(ID)