VARIANT_VALUE
Description
This table stores information about variant values.
Columns
| Column Name | Data Type | Description |
| ID | bigint | Primary key column for the table |
| BOOL_VALUE | bit | Stores the boolean value of the variant value |
| DOUBLE_VALUE | double | Stores the double value of the variant value |
| INT_16VALUE | smallint | Stores the int16 value of the variant value |
| INT_32VALUE | int | Stores the int32 value of the variant value |
| INT_64VALUE | bigint | Stores the int64 value of the variant value |
| STRING_VALUE | longtext | Stores the string value of the variant value |
| BOOL_LIST_VALUE_VARIANT_VALU_0 | bigint | Stores the ID of the boolean list value associated with the variant value |
| DOUBLE_LIST_VALUE_VARIANT_VA_0 | bigint | Stores the ID of the double list value associated with the variant value |
| INT 16LIST_VALUE_VARIANT_VA_0 | bigint | Stores the ID of the int16 list value associated with the variant value |
| INT 32LIST_VALUE_VARIANT_VA_0 | bigint | Stores the ID of the int32 list value associated with the variant value |
| INT 64LIST_VALUE_VARIANT_VA_0 | bigint | Stores the ID of the int64 list value associated with the variant value |
| STRING_LIST_VALUE_VARIANT_VA_0 | bigint | Stores the ID of the string list value associated with the variant value |
Foreign Key Relationships
- BOOL_LIST_VALUE_VARIANT_VALU_0 references BOOL_LIST_VALUE(ID)
- DOUBLE_LIST_VALUE_VARIANT_VA_0 references DOUBLE_LIST_VALUE(ID)
- INT 16LIST_VALUE_VARIANT_VA_0 references INT_16LIST_VALUE(ID)
- INT 32LIST_VALUE_VARIANT_VA_0 references INT_32LIST_VALUE(ID)
- INT 64LIST_VALUE_VARIANT_VA_0 references INT_64LIST_VALUE(ID)
- STRING_LIST_VALUE_VARIANT_VA_0 references STRING_LIST_VALUE(ID)