WebSphere Commerce database table: CATCLSFCOD

This table contains the assignment of classification codes to CatalogEntries.


Column Description(s):
Column NameColumn TypeDescription
CATENTRY_ID BIGINT NOT NULL The reference number of the CatalogEntry.
DOMAIN CHAR(32) NOT NULL Classification domain used to assign a code. One such example is UNSPSC classification system.
CODE CHAR(16) NOT NULL Classification code assigned under a particular classification domain.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031207900 CATENTRY_ID+DOMAIN Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_186 CATENTRY_ID CATENTRY CATENTRY_ID Cascade

Feedback