Each row of this table represents a requested - alternative language relationship for a particular StoreEntity. When information is not available in the requested language, information in the alternative language is used.
Column Description(s):
Column Name | Column Type | Description |
STOREENT_ID |
INTEGER NOT NULL |
The StoreEntity ID for this relationship. The requested - alternative language relationships of a store include the requested - alternative language relationships for its StoreGroup. |
LANGUAGE_ID |
INTEGER NOT NULL |
The language ID for the requested language. For a list of language components (language ID codes), see the LANGUAGE table. |
LANGUAGE_ID_ALT |
INTEGER NOT NULL |
The language ID for the alternative language. For a list of language components (language ID codes), see the LANGUAGE table." |
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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031236170 |
LANGUAGE_ID+LANGUAGE_ID_ALT+STOREENT_ID |
Primary Key |
I0000603 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.