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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|