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:

Name Type Description
STOREENT_ID INTEGER NOT NULL The StoreEntity that supports the language.
LANGUAGE_ID_DESC INTEGER NOT NULL The language being described.
DESCRIPTION VARCHAR (254) A brief description of the language suitable for display to customers in a selection list.
LANGUAGE_ID INTEGER NOT NULL The language of the description. For a list of language components, see the LANGUAGE table.
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> STOREENT_ID+LANGUAGE_ID_DESC+LANGUAGE_ID Primary Key
I0001290 LANGUAGE_ID_DESC+STOREENT_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_808 LANGUAGE_ID_DESC+STOREENT_ID STORELANG LANGUAGE_ID+STOREENT_ID Cascade
F_809 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference
Store data model