PROPERTY_CONFIGURATION
Description
Table for storing configurations of properties.
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 property configuration. |
| DATE_TIME_VALUE_ITEM | datetime DEFAULT NULL |
Date and time value for the property configuration. |
| DOUBLE_VALUE | double DEFAULT NULL |
Double value for the property configuration. |
| INTEGER_VALUE | int(11) DEFAULT NULL |
Integer value for the property configuration. |
| LONG_VALUE | bigint(20) DEFAULT NULL |
Long value for the property configuration. |
| STRING_VALUE | varchar(255) DEFAULT NULL |
String value for the property configuration. |
| TIME_VALUE_ITEM | time DEFAULT NULL |
Time value for the property configuration. |
| 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. |
| PROPERTY_ID | varchar(255) NOT NULL |
Property ID for the property configuration. |
| CONFIGURATIONS_CAMPAIGN_PROD_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the CAMPAIGN_CORE_IMMUTABLE_ELEM_0 table. |
| CONFIGURATIONS_HJORDER | int(11) DEFAULT NULL |
Order of the property configuration. |
Foreign Key Relationships
- 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.
- FOREIGN KEY ( CONFIGURATIONS_CAMPAIGN_PROD_0 ) REFERENCES CAMPAIGN_CORE_IMMUTABLE_ELEM_0 ( ID ): Establishes a foreign key relationship with the CAMPAIGN_CORE_IMMUTABLE_ELEM_0 table.