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 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031230260 |
CONCEPTID |
Primary Key |
I0000333 |
METAPHORID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_354 |
CONCEPTID |
ICKNOWLEDG |
CONCEPTID |
Cascade |
F_353 |
METAPHORID |
ICMETAPHOR |
METAPHORID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.