WebSphere Commerce database table: CATALOG

This table holds the information related to a catalog.

Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000061 MEMBER_ID+IDENTIFIER Unique Index
SQL060903235136590 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

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_983 CATALOG_ID_LINK CATGRPREL CATALOG_ID Cascade
F_226 CATALOG_ID CATGRPREL CATALOG_ID Cascade
F_228 CATALOG_ID CATGRPTPC CATALOG_ID Cascade
F_1033 CATALOG_ID_LINK CATTOGRP CATALOG_ID Cascade
F_230 CATALOG_ID CATTOGRP CATALOG_ID Cascade
F_978 CATALOG_ID CPPMNCAT CATALOG_ID Cascade
F_778 CATALOG_ID STORECAT CATALOG_ID Cascade
Related reference