CATTOGRP

This table identifies the root catalog groups (or root categories) contained within a catalog.

Column Descriptions:

Name	Type	Description
CATALOG_ID	BIGINT NOT NULL	The reference number of the catalog.
CATGROUP_ID	BIGINT NOT NULL	The reference number of the catalog group.
LASTUPDATE	TIMESTAMP	The last time that this relationship was updated.
SEQUENCE	DOUBLE	The sequence number used to determine display order.
CATALOG_ID_LINK	BIGINT	Reserved for IBM internal use.
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>	CATALOG_ID+CATGROUP_ID	Primary Key
I0000373	CATALOG_ID_LINK	Non-Unique Index
I0000532	CATGROUP_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1033	CATALOG_ID_LINK	CATALOG	CATALOG_ID	Cascade
F_230	CATALOG_ID	CATALOG	CATALOG_ID	Cascade
F_231	CATGROUP_ID	CATGROUP	CATGROUP_ID	Cascade

Related reference
Catalog data model