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.