This table stores the questions and answers generated by the Sales Assistant metaphor.
Column Name | Column Type | Column Description |
---|---|---|
CLASSNAME | CHARACTER (100) NOT NULL |
Java class name for a question or an answer. For example, com.ibm.commerce.pa.metaphor.Question. |
CONCEPTID | INTEGER NOT NULL |
The internal reference number of the concept (question or answer). |
METAPHORLINKID | INTEGER NULL |
The metaphor that this answer is linked to. |
ORDERSEQUENCE | INTEGER NOT NULL, DEFAULT 0 |
Order sequence of the concepts within a tree. |
PARENTCONCEPTID | INTEGER NULL |
Reserved for IBM internal use. |
RANKING | DOUBLE NOT NULL, DEFAULT 0 |
Reserved for IBM internal use. |
STOREID | INTEGER NULL |
Internal reference number of the store that this concept was created for. |
TREEID | INTEGER NOT NULL |
The internal reference number of the Question and Answer tree. Foreign key to the ICMERTREE table. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000120 | TREEID, PARENTCONCEPTID, CLASSNAME, ORDERSEQUENCE | Unique Index |
I0000121 | STOREID | Non-Unique Index |
SQL030416034941290 | CONCEPTID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_365 | TREEID | ICMERTREE | TREEID | Cascade |
F_366 | PARENTCONCEPTID | ICKNOWLEDG | CONCEPTID | Cascade |
F_971 | STOREID | STORE | STORE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_354 | CONCEPTID | ICCNCPTLNK | CONCEPTID | Cascade |
F_355 | CONCEPTID | ICCONSTRNT | CONCEPTID | Cascade |
F_363 | CONCEPTID | ICKNOWDESC | CONCEPTID | Cascade |
F_366 | CONCEPTID | ICKNOWLEDG | PARENTCONCEPTID | Cascade |