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:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLThe internal reference number of the catalog.
CATGROUP_IDBIGINT NOT NULLThe internal reference number of the catalog group.
PRODUCTSET_IDINTEGER NOT NULLThe internal reference number of the product set.
USAGECHAR (1)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATALOG_ID+CATGROUP_ID+PRODUCTSET_IDPrimary Key
I0000291CATALOG_ID+CATGROUP_ID+USAGENon-Unique Index
I0000292PRODUCTSET_ID+USAGENon-Unique Index
I0000526CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_221PRODUCTSET_IDPRODUCTSETPRODUCTSET_IDCascade
F_222CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_223CATALOG_IDCATALOGCATALOG_IDCascade