STORLANGDS

Each row of this table contains a description, in a particular language, of a supported language. For example, the Spanish language might be described as "Espanol" in French but as "Spanish" in English.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe StoreEntity that supports the language.
LANGUAGE_ID_DESCINTEGER NOT NULLThe language being described.
DESCRIPTIONVARCHAR (254)A brief description of the language suitable for display to customers in a selection list.
LANGUAGE_IDINTEGER NOT NULLThe language of the description. For a list of language components, see the LANGUAGE table.
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>STOREENT_ID+LANGUAGE_ID_DESC+LANGUAGE_IDPrimary Key
I0001290LANGUAGE_ID_DESC+STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_808LANGUAGE_ID_DESC+STOREENT_IDSTORELANGLANGUAGE_ID+STOREENT_IDCascade
F_809LANGUAGE_IDLANGUAGELANGUAGE_IDCascade