CATGPENREL

This table relates catalog groups (or categories) to the catalog entries that are inside them. We can also use this table to dictate the navigational flow from catalog groups to catalog entries. Each relationship is also qualified by a Catalog ID.

Column Descriptions:

Name	Type	Description
CATGROUP_ID	BIGINT NOT NULL	The source catalog group of this relationship.
CATALOG_ID	BIGINT NOT NULL	The catalog inside of which this relationship is found.
CATENTRY_ID	BIGINT NOT NULL	The target catalog entry 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 catalog group.
LASTUPDATE	TIMESTAMP	Indicates the last time that this relationship was updated.
FIELD1	VARCHAR (254)	Customizable.
FIELD2	INTEGER	Customizable.
FIELD3	DECIMAL (20,5)	Customizable.
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+CATENTRY_ID+CATALOG_ID	Primary Key
I0000523	CATALOG_ID	Non-Unique Index
I0000524	CATENTRY_ID	Non-Unique Index
I0001546	CATGROUP_ID+CATALOG_ID+CATENTRY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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

Related reference
Catalog entry data model
Catalog group data model