STORECGRP

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

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe reference number of the Store Entity.
CATGROUP_IDBIGINT NOT NULLThe reference number of the Catalog Group.
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+CATGROUP_IDPrimary Key
I0000783CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_782STOREENT_IDSTOREENTSTOREENT_IDCascade
F_783CATGROUP_IDCATGROUPCATGROUP_IDCascade