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:

Name	Type	Description
CATGROUP_ID_PARENT	BIGINT NOT NULL	The source catalog group of this relationship.
CATGROUP_ID_CHILD	BIGINT NOT NULL	The target catalog group of this relationship.
CATALOG_ID	BIGINT NOT NULL	The catalog in which this relationship is found.
RULE	VARCHAR (254)	Reserved for HCL internal use.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	The sequence number that determines the display order of the contents of the catalog group.
LASTUPDATE	TIMESTAMP	Indicates the last time that this relationship was updated.
CATALOG_ID_LINK	BIGINT	Reserved for HCL internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CATGROUP_ID_CHILD+CATGROUP_ID_PARENT+CATALOG_ID	Primary Key
I0000294	CATALOG_ID_LINK	Non-Unique Index
I0000527	CATALOG_ID	Non-Unique Index
I0000528	CATGROUP_ID_PARENT	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_224	CATGROUP_ID_CHILD	CATGROUP	CATGROUP_ID	Cascade
F_225	CATGROUP_ID_PARENT	CATGROUP	CATGROUP_ID	Cascade
F_226	CATALOG_ID	CATALOG	CATALOG_ID	Cascade
F_983	CATALOG_ID_LINK	CATALOG	CATALOG_ID	Cascade