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 Descriptions
| 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 |
| SQL060903235139220
| 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