Database Table: CATGRPPS

This table relates CatalogGroups to ProductSets. Every CatalogEntry under the Catalog sub-tree for this CatalogGroup is a member of the specified ProductSet.

Column Name Column Type Column Description
CATALOG_ID BIGINT
NOT NULL
The internal reference number of the Catalog.
CATGROUP_ID BIGINT
NOT NULL
The internal reference number of the CatalogGroup.
PRODUCTSET_ID INTEGER
NOT NULL
The internal reference number of the ProductSet.
USAGE CHARACTER (1)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000291 CATALOG_ID, CATGROUP_ID, USAGE Non-Unique Index
I0000292 PRODUCTSET_ID, USAGE Non-Unique Index
SQL030416034904640 CATALOG_ID, CATGROUP_ID, PRODUCTSET_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_221 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade
F_222 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_223 CATALOG_ID CATALOG CATALOG_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable