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:

NameTypeDescription
LANGUAGE_IDINTEGER NOT NULLThe Language. For a list of language components, see the LANGUAGE table.
STOREENT_IDINTEGER NOT NULLThe StoreEntity.
DISPLAYNAMEVARCHAR (254)A brief description of the StoreEntity suitable for display to customers.
STADDRESS_ID_LOCINTEGERThe physical location of the StoreEntity.
DESCRIPTIONVARCHAR (4000)A longer description of the StoreEntity suitable for display to customers.
STADDRESS_ID_CONTINTEGERThe contact address of the StoreEntity.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>LANGUAGE_ID+STOREENT_IDPrimary Key
I0000788STADDRESS_ID_LOCNon-Unique Index
I0000789STADDRESS_ID_CONTNon-Unique Index
I0000790STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_791STADDRESS_ID_CONTSTADDRESSSTADDRESS_IDCascade
F_792STADDRESS_ID_LOCSTADDRESSSTADDRESS_IDCascade
F_793LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_794STOREENT_IDSTOREENTSTOREENT_IDCascade