This table stores constraints as specified in the Guided Sell metaphor.
Column Descriptions
| Column Name
| Column Type
| Description |
| CONSTRAINTID
| INTEGER NOT NULL
| The internal reference number of a constraint.
|
| CONCEPTID
| INTEGER NOT NULL
| The internal reference number of the concept (question or answer). Foreign key to the ICKNOWLEDG table.
|
| FEATUREID
| INTEGER NOT NULL
| Feature ID that the constraint should be applied to. Foreign key to the ICEXPLFEAT table.
|
| FEATURENAME
| CHAR(18) NOT NULL
| Feature name that the constraint should be applied to. This is the column name in the ICTDESC table. For example: F_COLOR, F_SIZE.
|
| OPERATION
| VARCHAR(5) NOT NULL
| Operators for the constraint. Valid operators include: =, >=, <=, <>.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|