Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICMREGDESC
This table is deprecated and is provided for backward compatibility only. This tables stores the language-dependent text for the Product Advisor metaphors.
Column Name Column Type Description METAPHORTYPEID INTEGER NOT NULL The internal reference number of the metaphor type. Foreign key to ICMETAREG table. TITLE CHAR(128) NOT NULL Title or description for this metaphor type. ICONNAME CHAR(128) NOT NULL File name of the icon that displays for this metaphor type. 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 SQL100520030344040 METAPHORTYPEID+LANGUAGE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_374 METAPHORTYPEID ICMETAREG METAPHORTYPEID Cascade F_375 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference
_vcc_freeselect_bottom_