Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STORECAT
This table holds the relationship between StoreEntities and the Catalogs that they offer.
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 SQL100520030432920 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
_vcc_freeselect_bottom_