This table stores the questions and answers generated by the Guided Sell metaphor.
Column Description(s):
Column Name | Column Type | Description |
TREEID |
INTEGER NOT NULL |
The internal reference number of the question and answer tree. Foreign key to the ICMERTREE table. |
CONCEPTID |
INTEGER NOT NULL |
The internal reference number of the concept (question or answer). |
PARENTCONCEPTID |
INTEGER |
Reserved for IBM internal use. |
STOREID |
INTEGER |
The internal reference number of the store for which this concept was created. |
CLASSNAME |
CHAR(100) NOT NULL |
Java class name for a question or an answer. For example, com.ibm.commerce.pa.metaphor.Question. |
METAPHORLINKID |
INTEGER |
The metaphor to which this answer is linked. |
ORDERSEQUENCE |
INTEGER NOT NULL DEFAULT 0 |
Order sequence of the concepts within a tree. |
RANKING |
DOUBLE NOT NULL DEFAULT 0 |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000120 |
TREEID+PARENTCONCEPTID+CLASSNAME+ORDERSEQUENCE |
Unique Index |
SQL050212031231690 |
CONCEPTID |
Primary Key |
I0000121 |
STOREID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_366 |
PARENTCONCEPTID |
ICKNOWLEDG |
CONCEPTID |
Cascade |
F_365 |
TREEID |
ICMERTREE |
TREEID |
Cascade |
F_971 |
STOREID |
STORE |
STORE_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_354 |
CONCEPTID |
ICCNCPTLNK |
CONCEPTID |
Cascade |
F_355 |
CONCEPTID |
ICCONSTRNT |
CONCEPTID |
Cascade |
F_363 |
CONCEPTID |
ICKNOWDESC |
CONCEPTID |
Cascade |
F_366 |
PARENTCONCEPTID |
ICKNOWLEDG |
CONCEPTID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.