LANGPAIR

Each row of this table represents an alternative language relationship for a particular StoreEntity. When information is not available in the requested language, information in the alternative language is used.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe StoreEntity ID for this relationship. The alternative language relationships of a store include the alternative language relationships for its StoreGroup.
LANGUAGE_IDINTEGER NOT NULLThe language ID for the requested language. For a list of language components (language ID codes), see the LANGUAGE table.
LANGUAGE_ID_ALTINTEGER NOT NULLThe language ID for the alternative language. For a list of language components (language ID codes), see the LANGUAGE table."
SEQUENCEDOUBLE NOT NULL DEFAULT 0When the requested language is supported (see the STORELANG table) but information is not available in that language, each alternative language is tried in ascending order of SEQUENCE. A store may override the SEQUENCE specified for its StoreGroup.
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+LANGUAGE_ID_ALT+STOREENT_IDPrimary Key
I0000603STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_413LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_414LANGUAGE_ID_ALTLANGUAGELANGUAGE_IDCascade
F_415STOREENT_IDSTOREENTSTOREENT_IDCascade