Database Table: ICCNCPTLNK

This tables contains the information needed for a Sales Assistant answer to link to a metaphor (Product Exploration, Product Comparison, Sales Assistant) or to a URL.

Column Name Column Type Column 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 that this concept is linked to. 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.
TEMPLATENAME VARCHAR (256)
NULL
Template to be used when TEMPLATEUSAGE is set to 2.
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.
Indexes:
Index Name Indexed Column Names Index Type
I0000333 METAPHORID Non-Unique Index
SQL030416034938160 CONCEPTID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_353 METAPHORID ICMETAPHOR METAPHORID Cascade
F_354 CONCEPTID ICKNOWLEDG CONCEPTID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable