Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATCLSFCOD
This table contains the assignment of classification codes to CatalogEntries.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030309870 CATENTRY_ID+DOMAIN Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_186 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
Related reference
_vcc_freeselect_bottom_