WebSphere Commerce database table: CATCLSFCOD
This table contains the assignment of classification codes to CatalogEntries.
Column Descriptions
| 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 |
| SQL060903235136900
| 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