Database Table: ICKNOWDESC

This table stores the language-dependent text representing the questions and answers created for the Sales Assistant metaphor.

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.
CONCEPTNAME VARCHAR (512)
NOT NULL
Text of the concept (question or answer).
DESCRIPTOR VARCHAR (512)
NULL
Reserved for IBM internal use.
LANGUAGE_ID INTEGER
NOT NULL
The unique identifier of the language. Foreign key to the LANGUAGE table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034940960 CONCEPTID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_363 CONCEPTID ICKNOWLEDG CONCEPTID Cascade
F_364 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable