Reference > Database > WebSphere Commerce database tables > I


WebSphere Commerce database table: ICKNOWDESC

This table is deprecated and is provided for backward compatibility only. This table stores the language-dependent text representing the questions and answers created for the Guided Sell metaphor.

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
SQL100520030342600 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search