Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICCONSTRNT
This table is deprecated and is provided for backward compatibility only. This table stores constraints as specified in the Guided Sell metaphor.
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.
Indexes Index Name Indexed Column Names Index Type SQL100520030341370 CONSTRAINTID Primary Key I0000334 FEATUREID Non-Unique Index I0000335 CONCEPTID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Names Constraint Type F_357 CONSTRAINTID ICCONSTVAL CONSTRAINTID Cascade
Related reference
_vcc_freeselect_bottom_