WebSphere Commerce database table: ICCNCPTLNK

This table contains the information required for a Guided Sell answer to link to a metaphor (Product Exploration, Product Comparison, and Guided Sell) or to a URL.

Column Descriptions
Column Name Column Type Description
CONCEPTID INTEGER NOT NULL The internal reference number of the concept (question or answer). Foreign key to the ICKNOWLEDG table.
METAPHORID INTEGER NOT NULL The metaphor to which this concept is linked. Foreign key to the ICMETAPHOR table.
PASSCONSTLIST INTEGER NOT NULL DEFAULT 1 Indicates if a constraint list be passed to the metaphor. Valid values: 0=false or 1=true.
TEMPLATEUSAGE INTEGER NOT NULL DEFAULT 1 Indicates which template should be used. Valid values: 0=use template of default metaphor, 1=use template of the metaphor of this concept, 2=use template in TEMPLATENAME column, or 3=URL.
TEMPLATENAME VARCHAR(256) Template to be used when TEMPLATEUSAGE is set to 2.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235204130 CONCEPTID Primary Key
I0000333 METAPHORID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_354 CONCEPTID ICKNOWLEDG CONCEPTID Cascade
F_353 METAPHORID ICMETAPHOR METAPHORID Cascade
Related reference