Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICCNCPTLNK
This table is deprecated and is provided for backward compatibility only. 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 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 SQL100520030341190 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
_vcc_freeselect_bottom_