WebSphere Commerce database table: STORECAT

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

Column Descriptions
Column Name Column Type Description
CATALOG_ID BIGINT NOT NULL The reference number of the Catalog.
STOREENT_ID INTEGER NOT NULL The reference number of the StoreEntity.
MASTERCATALOG CHAR(1) Specifies a master catalog for the Store. A value of 1 indicates that this Catalog is designated as a master catalog.
LASTUPDATE TIMESTAMP Indicates the last time that this relationship was updated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235253690 CATALOG_ID+STOREENT_ID Primary Key
I0000782 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_778 CATALOG_ID CATALOG CATALOG_ID Cascade
F_779 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference