Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATGRPTPC
This table relates master catalogs with trading position containers. Each catalog entry belonging to the indicated master catalog must have a standard price offer supplied for the specified trading position container.
Column Name Column Type Description CATALOG_ID BIGINT NOT NULL The reference number of the catalog. CATGROUP_ID BIGINT NOT NULL DEFAULT 0 The reference number of the catalog group. TRADEPOSCN_ID BIGINT NOT NULL The reference number of the trading position container. STORE_ID INTEGER NOT NULL DEFAULT 0 The reference number of the store to which this trading position container relationship refers. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030313000 CATALOG_ID+CATGROUP_ID+TRADEPOSCN_ID+STORE_ID Primary Key I0000529 TRADEPOSCN_ID Non-Unique Index I0000530 STORE_ID Non-Unique Index I0000531 CATGROUP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_228 CATALOG_ID CATALOG CATALOG_ID Cascade F_229 CATGROUP_ID CATGROUP CATGROUP_ID Cascade F_945 STORE_ID STORE STORE_ID Cascade F_227 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade _vcc_freeselect_bottom_