WebSphere Commerce database table: SETCURRDSC

This table stores the text descriptions for each of the currency in the SETCURR table in each of the supported language.

Column Descriptions
Column Name Column Type Description
SETCCURR CHAR(3) NOT NULL This is a currency code as per ISO 4217 standards. Foreign key that references column SETCCURR in the SETCURR table.
LANGUAGE_ID INTEGER NOT NULL Language ID of the Language. Foreign key that references the LANGUAGE_ID column in the Language table. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) The text description of the currency in the language identified by LANGUAGE_ID.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235249600 SETCCURR+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_743 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_742 SETCCURR SETCURR SETCCURR Cascade