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.
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>STOREENT_ID+CATENTRY_IDPrimary Key
I0000345CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_780STOREENT_IDSTOREENTSTOREENT_IDCascade
F_781CATENTRY_IDCATENTRYCATENTRY_IDCascade