Database Table: STOREENTDS

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035114550 LANGUAGE_ID, STOREENT_ID Primary Key
Constraints:
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

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