STOREENTDS

Each row of this table represents a StoreEntity. A StoreEntity is an abstract superclass that can represent either a Store or a StoreGroup.

Column Descriptions:

Name	Type	Description
LANGUAGE_ID	INTEGER NOT NULL	The Language. For a list of language components, see the LANGUAGE table.
STOREENT_ID	INTEGER NOT NULL	The StoreEntity.
DISPLAYNAME	VARCHAR (254)	A brief description of the StoreEntity suitable for display to customers.
STADDRESS_ID_LOC	INTEGER	The physical location of the StoreEntity.
DESCRIPTION	VARCHAR (4000)	A longer description of the StoreEntity suitable for display to customers.
STADDRESS_ID_CONT	INTEGER	The contact address of the StoreEntity.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	LANGUAGE_ID+STOREENT_ID	Primary Key
I0000788	STADDRESS_ID_LOC	Non-Unique Index
I0000789	STADDRESS_ID_CONT	Non-Unique Index
I0000790	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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

Related reference
Store data model