Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATGRPPS
This table relates catalog groups to product sets. Every catalog entry under the catalog subtree for this catalog group is a member of the specified product set.
Column Name Column Type Description CATALOG_ID BIGINT NOT NULL The internal reference number of the catalog. CATGROUP_ID BIGINT NOT NULL The internal reference number of the catalog group. PRODUCTSET_ID INTEGER NOT NULL The internal reference number of the product set. USAGE CHAR(1) Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030312640 CATALOG_ID+CATGROUP_ID+PRODUCTSET_ID Primary Key I0000291 CATALOG_ID+CATGROUP_ID+USAGE Non-Unique Index I0000292 PRODUCTSET_ID+USAGE Non-Unique Index I0000526 CATGROUP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_223 CATALOG_ID CATALOG CATALOG_ID Cascade F_222 CATGROUP_ID CATGROUP CATGROUP_ID Cascade F_221 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade
Related reference
_vcc_freeselect_bottom_