Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATALOG
This table holds the information related to a catalog.
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 SQL100520030309550 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_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
- Messaging extension data model
- Product set data model
- Catalog data model
- Catalog entry data model
- Catalog group data model
- E-coupon data model
_vcc_freeselect_bottom_