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 HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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