This table stores constraints as specified in the Guided Sell metaphor.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031230400 |
CONSTRAINTID |
Primary Key |
I0000334 |
FEATUREID |
Non-Unique Index |
I0000335 |
CONCEPTID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_356 |
FEATUREID |
ICEXPLFEAT |
FEATUREID |
Cascade |
F_355 |
CONCEPTID |
ICKNOWLEDG |
CONCEPTID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_357 |
CONSTRAINTID |
ICCONSTVAL |
CONSTRAINTID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.