Database Table: CATALOG

This table holds the information related to a Catalog.

Column Name Column Type Column Description
CATALOG_ID BIGINT
NOT NULL
The internal reference number of the Catalog.
DESCRIPTION VARCHAR (254)
NULL
An administrative description of the Catalog.
IDENTIFIER VARCHAR (254)
NOT NULL
The external used to identify the Catalog. Along with the MEMBER_ID, these columns are a unique index.
MEMBER_ID BIGINT
NOT NULL
The internal reference number that identifies the owner of the Catalog. Along with the IDENTIFIER, these columns are a unique index.
TPCLEVEL INTEGER
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000061 MEMBER_ID, IDENTIFIER Unique Index
SQL030416034855170 CATALOG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_183 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_141 CATALOG_ID BUYSUPMAP CATALOG_ID Cascade
F_185 CATALOG_ID CATALOGDSC CATALOG_ID Cascade
F_187 CATALOG_ID CATCNTR CATALOG_ID Cascade
F_215 CATALOG_ID CATGPENREL CATALOG_ID Cascade
F_223 CATALOG_ID CATGRPPS CATALOG_ID Cascade
F_226 CATALOG_ID CATGRPREL CATALOG_ID Cascade
F_228 CATALOG_ID CATGRPTPC CATALOG_ID Cascade
F_230 CATALOG_ID CATTOGRP CATALOG_ID Cascade
F_778 CATALOG_ID STORECAT CATALOG_ID Cascade
F_978 CATALOG_ID CPPMNCAT CATALOG_ID Cascade
F_983 CATALOG_ID CATGRPREL CATALOG_ID_LINK Cascade