CATALOG
This table holds the information related to a catalog.
Column Descriptions:
Name Type Description CATALOG_ID BIGINT NOT NULL The internal reference number of the catalog. 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. IDENTIFIER VARCHAR (254) NOT NULL The external identifier used to identify the catalog. Along with the MEMBER_ID, these columns are a unique index. DESCRIPTION VARCHAR (254) An administrative description of the catalog. TPCLEVEL INTEGER Reserved for IBM internal use. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> CATALOG_ID Primary Key I0000061 MEMBER_ID+IDENTIFIER Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_183 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_1033 CATALOG_ID CATTOGRP CATALOG_ID_LINK Cascade 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_3662 CATALOG_ID CATFILTER CATALOG_ID Cascade F_3679 CATALOG_ID ATTRDICTSRCHCONF MASTERCATALOG_ID Cascade F_3682 CATALOG_ID CLSATTRSRCHCONF MASTERCATALOG_ID Cascade F_3714 CATALOG_ID STOREDEFCAT CATALOG_ID Cascade F_3762 CATALOG_ID SRCHPROPRELV 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
Related reference
Catalog data model
Catalog entry data model
Catalog group data model
Messaging extension data model
Product set data model