Database Table: ICKNOWLEDG

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000120 TREEID, PARENTCONCEPTID, CLASSNAME, ORDERSEQUENCE Unique Index
I0000121 STOREID Non-Unique Index
SQL030416034941290 CONCEPTID Primary Key
Constraints:
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

Referenced By:
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