Database Table: 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 may be used instead.

Column Name Column Type Column Description
LANGUAGE_ID INTEGER
NOT NULL
The requested language. For a list of language components, see the LANGUAGE table.
LANGUAGE_ID_ALT INTEGER
NOT NULL
The alternative language.
SEQUENCE DOUBLE
NOT NULL, DEFAULT 0
When 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.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity this relationship is part of. The alternative language relationships for a store include the alternative language relationships for its StoreGroup.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034951980 LANGUAGE_ID, LANGUAGE_ID_ALT, STOREENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_413 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_414 LANGUAGE_ID_ALT LANGUAGE LANGUAGE_ID Cascade
F_415 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable