WebSphere Commerce database table: ICCONSTRNT

This table stores constraints as specified in the Guided Sell metaphor.


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
SQL050212031230400 CONSTRAINTID Primary Key
I0000334 FEATUREID Non-Unique Index
I0000335 CONCEPTID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_356 FEATUREID ICEXPLFEAT FEATUREID Cascade
F_355 CONCEPTID ICKNOWLEDG CONCEPTID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_357 CONSTRAINTID ICCONSTVAL CONSTRAINTID Cascade

Feedback