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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000333 | METAPHORID | Non-Unique Index |
SQL030416034938160 | CONCEPTID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_353 | METAPHORID | ICMETAPHOR | METAPHORID | Cascade |
F_354 | CONCEPTID | ICKNOWLEDG | CONCEPTID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|