This table contains language-dependent information about a StoreEntity.
Column Name | Column Type | Column Description |
---|---|---|
DESCRIPTION | VARCHAR (4000) NULL |
A longer description of the StoreEntity, suitable for display to customers. |
DISPLAYNAME | CHARACTER (80) NULL |
A brief description of the StoreEntity, suitable for display to customers. |
LANGUAGE_ID | INTEGER NOT NULL |
The Language. For a list of language components, see the LANGUAGE table. |
STADDRESS_ID_CONT | INTEGER NULL |
The contact address of the StoreEntity. |
STADDRESS_ID_LOC | INTEGER NULL |
The physical location of the StoreEntity. |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035114550 | LANGUAGE_ID, STOREENT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_791 | STADDRESS_ID_CONT | STADDRESS | STADDRESS_ID | Cascade |
F_792 | STADDRESS_ID_LOC | STADDRESS | STADDRESS_ID | Cascade |
F_793 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
F_794 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|