STORECAT

This table holds the relationship between StoreEntities and the Catalogs that they offer.

Column Descriptions:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLThe reference number of the Catalog.
STOREENT_IDINTEGER NOT NULLThe reference number of the StoreEntity.
MASTERCATALOGCHAR (1)Specifies a master catalog for the Store. A value of 1 indicates that this Catalog is designated as a master catalog.
LASTUPDATETIMESTAMPIndicates the last time that this relationship was updated.
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>CATALOG_ID+STOREENT_IDPrimary Key
I0000782STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_778CATALOG_IDCATALOGCATALOG_IDCascade
F_779STOREENT_IDSTOREENTSTOREENT_IDCascade