Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICMERDESC
This table is deprecated and is provided for backward compatibility only. This table stores the language dependent text for the Guided Sell Question and Answer tree description.
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 SQL100520030342910 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
_vcc_freeselect_bottom_