PROFILE_CONDITION_SEGMENT
Description
Table for storing segments for profile conditions.
Columns
PROFILE_CONDITION_SEGMENT
Column Name Data Type Description
| Column Name | Data Type | Description |
| ID | bigint(20) NOT NULL |
Primary key for the table. |
| SEGMENT_ID | varchar(255) NOT NULL |
Segment ID for the segment. |
| SEGMENT_KIND | varchar(255) NOT NULL |
Kind of segment. |
| SEGMENT_TYPE | varchar(255) NOT NULL |
Type of segment. |
| SEGMENT_OPTION_PROFILE_CONDI_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the SEGMENT_OPTION table. |
| SEGMENT_VALUE_PROFILE_CONDIT_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PROFILE_CONDITION_MODIFIER table. |
| SEGMENTS_PROFILE_CONDITION_T_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PROFILE_CONDITION_TEMPLATE table. |
| SEGMENTS_HJORDER | int(11) DEFAULT NULL |
Order of the segment. |
| SEGMENTS_PROFILE_CONDITION_M_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PROFILE_CONDITION_MODIFIER table. |
Foreign Key Relationships
- FOREIGN KEY ( SEGMENT_OPTION_PROFILE_CONDI_0 ) REFERENCES SEGMENT_OPTION ( ID ): Establishes a foreign key relationship with the SEGMENT_OPTION table.
- FOREIGN KEY ( SEGMENTS_PROFILE_CONDITION_M_0 ) REFERENCES PROFILE_CONDITION_MODIFIER ( ID ): Establishes a foreign key relationship with the PROFILE_CONDITION_MODIFIER table.