WebSphere Commerce database table: ICMERDESC

This table stores the language dependent text for the Guided Sell Question and Answer tree description.


Column Description(s):
Column NameColumn TypeDescription
TREEID INTEGER NOT NULL The internal reference number of the Question and Answer tree. Foreign key to the ICMERTREE table.
DESCRIPTOR VARCHAR(254) Reserved for IBM internal use.
LANGUAGE_ID INTEGER NOT NULL The unique identifier of the language. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031231820 LANGUAGE_ID+TREEID Primary Key
I0000578 TREEID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_368 TREEID ICMERTREE TREEID Cascade
F_367 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback