STORECENT

This table holds the relationship between StoreEntities and the CatalogEntries that they can display and process.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe reference number of the StoreEntity.
CATENTRY_IDBIGINT NOT NULLThe reference number of the CatalogEntry.
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>STOREENT_ID+CATENTRY_IDPrimary Key
I0000345CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_780STOREENT_IDSTOREENTSTOREENT_IDCascade
F_781CATENTRY_IDCATENTRYCATENTRY_IDCascade