WebSphere Commerce database table: ICKNOWDESC

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

Column Descriptions
Column Name Column Type 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) Reserved for IBM internal use.
LANGUAGE_ID INTEGER NOT NULL The unique identifier of the language. Foreign key to the LANGUAGE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235205320 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
Related reference