Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CLASIFCODE
This table contains all possible product classification codes under different classification domains (such as UNSPSC, SPSC, and so on) that can be assigned to CatalogEntries.
Column Name Column Type Description CLASIFCODE_ID BIGINT NOT NULL Generated primary key. DOMAIN CHAR(32) NOT NULL The classification standard or domain. CODE CHAR(16) NOT NULL The classification code. PARENTCODE CHAR(16) The parent classification code. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000072 CODE+DOMAIN Unique Index SQL100520030315000 CLASIFCODE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_241 CLASIFCODE_ID CLSFCODEDS CLASIFCODE_ID Cascade
Related reference
_vcc_freeselect_bottom_