CATGRPREL

This table relates catalog groups (or categories) to child catalog group (or child categories). You can use this table to dictate the navigational flow from catalog groups to child catalog groups. Each relationship is also qualified by a Catalog ID.

Column Descriptions:

NameTypeDescription
CATGROUP_ID_PARENTBIGINT NOT NULLThe source catalog group of this relationship.
CATGROUP_ID_CHILDBIGINT NOT NULLThe target catalog group of this relationship.
CATALOG_IDBIGINT NOT NULLThe catalog in which this relationship is found.
RULEVARCHAR (254)Reserved for HCL internal use.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence number that determines the display order of the contents of the catalog group.
LASTUPDATETIMESTAMPIndicates the last time that this relationship was updated.
CATALOG_ID_LINKBIGINTReserved 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> CATGROUP_ID_CHILD+CATGROUP_ID_PARENT+CATALOG_IDPrimary Key
I0000294CATALOG_ID_LINKNon-Unique Index
I0000527CATALOG_IDNon-Unique Index
I0000528CATGROUP_ID_PARENTNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_224CATGROUP_ID_CHILDCATGROUPCATGROUP_IDCascade
F_225CATGROUP_ID_PARENTCATGROUPCATGROUP_IDCascade
F_226CATALOG_IDCATALOGCATALOG_IDCascade
F_983CATALOG_ID_LINKCATALOGCATALOG_IDCascade