PROFILE_CONDITION_SEGMENT_VA_0
Description
Table for storing variant segment information for profile conditions.
Columns
| Column Name | Data Type | Description |
| ID | bigint(20) NOT NULL |
Primary key for the table. |
| BOOLEAN_VALUE | bit(1) DEFAULT NULL |
Boolean value for the variant segment information. |
| DATE_TIME_VALUE_ITEM | datetime DEFAULT NULL |
Date and time value for the variant segment information. |
| DOUBLE_VALUE | double DEFAULT NULL |
Double value for the variant segment information. |
| INTEGER_VALUE | int(11) DEFAULT NULL |
Integer value for the variant segment information. |
| LONG_VALUE | bigint(20) DEFAULT NULL |
Long value for the variant segment information. |
| STRING_VALUE | varchar(255) DEFAULT NULL |
String value for the variant segment information. |
| TIME_VALUE_ITEM | time DEFAULT NULL |
Time value for the variant segment information. |
| AGGREGATION_DURATION_VALUE_V_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the AGGREGATION_DURATION_VALUE table. |
| DURATION_VALUE_VARIANT_VALUE_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the DURATION_VALUE_VARIANT_VALUE table. |
| GEOFENCES_VALUE_VARIANT_VALU_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the POIS_TYPE table. |
| POIS_VALUE_VARIANT_VALUE 0_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the POIS_TYPE table. |
| STRING_LIST_VALUE_VARIANT_VA_1 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the STRING_LIST_VALUE 0 table. |
| SEGMENT_ID | varchar(255) NOT NULL |
Segment ID for the variant segment information. |
| VALUES PROFILE_CONDITION_EN_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PROFILE_CONDITION_ENABLED_MO_0 table. |
| VALUES HJORDER | int(11) DEFAULT NULL |
Order of the variant segment information. |
| VALUES PROFILE_CONDITION_VA_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PROFILE_CONDITION_MODIFIER table. |
Foreign Key Relationships
- FOREIGN KEY ( VALUES PROFILE_CONDITION_EN_0 ) REFERENCES PROFILE_CONDITION_ENABLED_MO_0 ( ID ): Establishes a foreign key relationship with the PROFILE_CONDITION_ENABLED_MO_0 table.
- FOREIGN KEY ( POIS_VALUE_VARIANT_VALUE 0_0 ) REFERENCES POIS_TYPE ( ID ): Establishes a foreign key relationship with the POIS_TYPE table.
- FOREIGN KEY ( STRING_LIST_VALUE_VARIANT_VA_1 ) REFERENCES STRING_LIST_VALUE 0 ( ID ): Establishes a foreign key relationship with the STRING_LIST_VALUE 0 table.