Database Table: CATGRPREL

This tables relates CatalogGroups (or Categories) to SubCatalogGroups (or SubCategories). You can use this table to dictate the navigational flow from CatalogGroups to SubCatalogGroups. Each relationship is also qualified by a Catalog ID.

Column Name Column Type Column Description
CATALOG_ID BIGINT
NOT NULL
The Catalog in which this relationship is found.
CATALOG_ID_LINK BIGINT
NULL
Reserved for IBM internal use.
CATGROUP_ID_CHILD BIGINT
NOT NULL
The target CatalogGroup of this relationship.
CATGROUP_ID_PARENT BIGINT
NOT NULL
The source CatalogGroup of this relationship.
LASTUPDATE TIMESTAMP
NULL
Indicates the last time that this relationship was updated.
RULE VARCHAR (254)
NULL
Reserved for IBM internal use.
SEQUENCE DOUBLE
NOT NULL, DEFAULT 0
The sequence number that determines the display order of the contents of the CatalogGroup.
Indexes:
Index Name Indexed Column Names Index Type
I0000294 CATALOG_ID_LINK Non-Unique Index
SQL030416034905000 CATGROUP_ID_CHILD, CATGROUP_ID_PARENT, CATALOG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable