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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|