Database Table: ICMREGDESC

This tables stores the language dependent text for the Product Advisor metaphors.

Column Name Column Type Column Description
ICONNAME CHARACTER (128)
NOT NULL
Filename of the icon displayed 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.
METAPHORTYPEID INTEGER
NOT NULL
The internal reference number of the metaphor type. Foreign key to ICMETAREG table.
TITLE CHARACTER (100)
NOT NULL
Title or description for this metaphor type.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034943740 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable