CATTOGRP

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

Column Descriptions:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLThe reference number of the catalog.
CATGROUP_IDBIGINT NOT NULLThe reference number of the catalog group.
LASTUPDATETIMESTAMPThe last time that this relationship was updated.
SEQUENCEDOUBLEThe sequence number used to determine display order.
CATALOG_ID_LINKBIGINTReserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATALOG_ID+CATGROUP_IDPrimary Key
I0000373CATALOG_ID_LINKNon-Unique Index
I0000532CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1033CATALOG_ID_LINKCATALOGCATALOG_IDCascade
F_230CATALOG_IDCATALOGCATALOG_IDCascade
F_231CATGROUP_IDCATGROUPCATGROUP_IDCascade