WebSphere Commerce database table: SETCURRDSC

SETCURRDSC

Text descriptions for each of the currency in the SETCURR table in each of the supported language.

Column Descriptions:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> SETCCURR+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_742 SETCCURR SETCURR SETCCURR Cascade
F_743 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Related reference
Currency data model

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Constraint	Columns	Parent Table	Parent Columns	Type
F_742	SETCCURR	SETCURR	SETCCURR	Cascade
F_743	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade