Reference > Database > WebSphere Commerce database tables > S
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 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 SQL100520030428230 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
Related reference
_vcc_freeselect_bottom_