STORELANG

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

Column Descriptions:

NameTypeDescription
LANGUAGE_IDINTEGER NOT NULLThe language supported by the StoreEntity. For a list of language components, see the LANGUAGE table.
STOREENT_IDINTEGER NOT NULLThe StoreEntity. In addition to its explicitly supported languages, a Store implicitly supports the languages supported by its StoreGroup.
SETCCURRCHAR (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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>LANGUAGE_ID+STOREENT_IDPrimary Key
I0000792STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_798LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_799STOREENT_IDSTOREENTSTOREENT_IDCascade
F_800SETCCURRSETCURRSETCCURRCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_808LANGUAGE_ID+STOREENT_IDSTORLANGDSLANGUAGE_ID_DESC+STOREENT_IDCascade