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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000061 | MEMBER_ID, IDENTIFIER | Unique Index |
SQL030416034855170 | CATALOG_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_183 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
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 |