This table relates CatalogGroups (or Categories) to the CatalogEntries that are inside them. You can also use this table to dictate the navigational flow from CatalogGroups to CatalogEntries. Each relationship is also qualified by a Catalog ID.
Column Description(s):
Column Name | Column Type | Description |
CATGROUP_ID |
BIGINT NOT NULL |
The source CatalogGroup of this relationship. |
CATALOG_ID |
BIGINT NOT NULL |
The Catalog inside of which this relationship is found. |
CATENTRY_ID |
BIGINT NOT NULL |
The target CatalogEntry of this relationship. |
RULE |
VARCHAR(254) |
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. |
LASTUPDATE |
TIMESTAMP |
Indicates the last time that this relationship was updated. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031209640 |
CATGROUP_ID+CATENTRY_ID+CATALOG_ID |
Primary Key |
I0000523 |
CATALOG_ID |
Non-Unique Index |
I0000524 |
CATENTRY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_215 |
CATALOG_ID |
CATALOG |
CATALOG_ID |
Cascade |
F_214 |
CATENTRY_ID |
CATENTRY |
CATENTRY_ID |
Cascade |
F_213 |
CATGROUP_ID |
CATGROUP |
CATGROUP_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.