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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034951980 | LANGUAGE_ID, LANGUAGE_ID_ALT, STOREENT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|