WebSphere Commerce database table: STORECAT

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031314180 CATALOG_ID+STOREENT_ID Primary Key
I0000782 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_778 CATALOG_ID CATALOG CATALOG_ID Cascade
F_779 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback