Database Table: CATTOGRP

This table identifies the root CatalogGroups (or root Categories) contained within a Catalog.

Column Name Column Type Column Description
CATALOG_ID BIGINT
NOT NULL
The reference number of the Catalog.
CATGROUP_ID BIGINT
NOT NULL
The reference number of the CatalogGroup.
LASTUPDATE TIMESTAMP
NULL
The last time that this relationship was updated.
SEQUENCE DOUBLE
NULL
The sequence number used to determine display order.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034905950 CATALOG_ID, CATGROUP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_230 CATALOG_ID CATALOG CATALOG_ID Cascade
F_231 CATGROUP_ID CATGROUP CATGROUP_ID Cascade

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