This table stores constraints as specified in the Sales Assistant metaphor.
Column Name | Column Type | Column Description |
---|---|---|
CONCEPTID | INTEGER NOT NULL |
The internal reference number of the concept (question or answer). Foreign key to the ICKNOWLEDG table. |
CONSTRAINTID | INTEGER NOT NULL |
The internal reference number of a constraint. |
FEATUREID | INTEGER NOT NULL |
Feature ID that the constraint should be applied to. Foreign key to the ICEXPLFEAT table. |
FEATURENAME | CHARACTER (18) NOT NULL |
Feature Name that the constraint should be applied to. This is the column name in the ICTDESC <categoryID> table. For example: F_COLOR, F_SIZE. |
OPERATION | VARCHAR (5) NOT NULL |
Operators for the constraint. Valid operators include: =, >=, ===ICCONSTRNT===OPERATION===lt;=, ===ICCONSTRNT===OPERATION===lt;===ICCONSTRNT===OPERATION===gt;. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000334 | FEATUREID | Non-Unique Index |
I0000335 | CONCEPTID | Non-Unique Index |
SQL030416034938570 | CONSTRAINTID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_355 | CONCEPTID | ICKNOWLEDG | CONCEPTID | Cascade |
F_356 | FEATUREID | ICEXPLFEAT | FEATUREID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_357 | CONSTRAINTID | ICCONSTVAL | CONSTRAINTID | Cascade |