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.
OPTCOUNTERSMALLINTThe 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