Database Table: ICCONSTRNT

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;.
Indexes:
Index Name Indexed Column Names Index Type
I0000334 FEATUREID Non-Unique Index
I0000335 CONCEPTID Non-Unique Index
SQL030416034938570 CONSTRAINTID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_355 CONCEPTID ICKNOWLEDG CONCEPTID Cascade
F_356 FEATUREID ICEXPLFEAT FEATUREID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_357 CONSTRAINTID ICCONSTVAL CONSTRAINTID Cascade