WebSphere Commerce database table: CATALOG

This table holds the information related to a Catalog.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000061 MEMBER_ID+IDENTIFIER Unique Index
SQL050212031207630 CATALOG_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_183 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback