WebSphere Commerce database table: ICMERDESC

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235205630 LANGUAGE_ID+TREEID Primary Key
I0000578 TREEID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_368 TREEID ICMERTREE TREEID Cascade
F_367 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference