WebSphere Commerce database table: STORELANG

Each row of this table indicates that a StoreEntity supports a language. See also the LANGPAIR table.

Column Descriptions

Column Name	Column Type	Description
LANGUAGE_ID	INTEGER NOT NULL	The language supported by the StoreEntity. For a list of language components, see the LANGUAGE table.
STOREENT_ID	INTEGER NOT NULL	The StoreEntity. In addition to its explicitly supported languages, a Store implicitly supports the languages supported by its StoreGroup.
SETCCURR	CHAR(3)	A default currency for customers using the supported Language in a Store. This is a currency code as per ISO 4217 standards. A Store may override the default currency for its StoreGroup by specifying the same language and a different default currency.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235255330	LANGUAGE_ID+STOREENT_ID	Primary Key
I0000792	STOREENT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_798	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_800	SETCCURR	SETCURR	SETCCURR	Cascade
F_799	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_808	LANGUAGE_ID_DESC STOREENT_ID	STORLANGDS	LANGUAGE_ID	Cascade

Related reference

• Store data model