PROFILE_CONDITION
Description
Table for storing profile conditions.
Columns
| Column Name | Data Type | Description |
| ID | bigint(20) NOT NULL |
Primary key for the table. |
| PREDICATE_PROFILE_CONDITION 0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PREDICATE table. |
| DISJUNCTION_CONDITIONS_CONNE_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the CONNECTIVE_PROFILE_CONDITION table. |
| DISJUNCTION_CONDITIONS_HJORD_0 | int(11) DEFAULT NULL |
Order of the disjunction condition. |
| CONJUNCTION_CONDITIONS_CONNE_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the CONNECTIVE_PROFILE_CONDITION table. |
| CONJUNCTION_CONDITIONS_HJORD_0 | int(11) DEFAULT NULL |
Order of the conjunction condition. |
| DISJUNCTION_CONDITIONS_PROFI_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PROFILE_CONDITION table. |
| CONJUNCTION_CONDITIONS_PROFI_0 | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the PROFILE_CONDITION table. |
Foreign Key Relationships
- FOREIGN KEY ( DISJUNCTION_CONDITIONS_CONNE_0 ) REFERENCES CONNECTIVE_PROFILE_CONDITION ( ID ): Establishes a foreign key relationship with the CONNECTIVE_PROFILE_CONDITION table.
- FOREIGN KEY ( CONJUNCTION_CONDITIONS_CONNE_0 ) REFERENCES CONNECTIVE_PROFILE_CONDITION ( ID ): Establishes a foreign key relationship with the CONNECTIVE_PROFILE_CONDITION table.
- FOREIGN KEY ( DISJUNCTION_CONDITIONS_PROFI_0 ) REFERENCES PROFILE_CONDITION ( ID ): Establishes a foreign key relationship with the PROFILE_CONDITION table.
- FOREIGN KEY ( CONJUNCTION_CONDITIONS_PROFI_0 ) REFERENCES PROFILE_CONDITION ( ID ): Establishes a foreign key relationship with the PROFILE_CONDITION table.