CONDITION
Description
This table stores the conditions.
Columns
| ID | bigint | The unique identifier for the condition. |
| NEGATION_CONDITION ID | bigint | The ID of the negation condition. |
| PREDICATE_CONDITION ID | bigint | The ID of the predicate condition. |
| DISJUNCTION_CONDITIONS_CONDI_0 | bigint | The ID of the first disjunction condition. |
| DISJUNCTION_CONDITIONS_HJORD_0 | int | The HJ (Hypothetical Join) order for the first disjunction condition. |
| CONJUNCTION_CONDITIONS_CONDI_0 | bigint | The ID of the first conjunction condition. |
| CONJUNCTION_CONDITIONS_HJORD_0 | int | The HJ (Hypothetical Join) order for the first conjunction condition. |
Foreign Key Relationships
- NEGATION_CONDITION ID references CONDITION_(ID)
- PREDICATE_CONDITION ID references PREDICATE(ID)
- DISJUNCTION_CONDITIONS_CONDI_0 references CONDITION_(ID)
- CONJUNCTION_CONDITIONS_CONDI_0 references CONDITION_(ID)