Database Table: CATGPENREL

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 Name Column Type Column Description
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.
CATGROUP_ID 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
SQL030416034903270 CATGROUP_ID, CATENTRY_ID, CATALOG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_213 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_214 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_215 CATALOG_ID CATALOG CATALOG_ID Cascade

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