WebSphere Commerce database table: ICKNOWDESC

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

Product Advisor data model

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.

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