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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031230260 CONCEPTID Primary Key
I0000333 METAPHORID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_354 CONCEPTID ICKNOWLEDG CONCEPTID Cascade
F_353 METAPHORID ICMETAPHOR METAPHORID Cascade

Feedback