Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STORECGRP
This table holds the relationship between StoreEntities and the CatalogGroups that they can display and process.
Column Name Column Type Description STOREENT_ID INTEGER NOT NULL The reference number of the Store Entity. CATGROUP_ID BIGINT NOT NULL The reference number of the Catalog Group. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030433230 STOREENT_ID+CATGROUP_ID Primary Key I0000783 CATGROUP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_783 CATGROUP_ID CATGROUP CATGROUP_ID Cascade F_782 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference
_vcc_freeselect_bottom_