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 | Column Description |
---|---|---|
CLASIFCODE_ID | BIGINT NOT NULL |
Generated primary key. |
CODE | CHARACTER (16) NOT NULL |
The classification code. |
DOMAIN | CHARACTER (32) NOT NULL |
The classification standard or domain. |
PARENTCODE | CHARACTER (16) NULL |
The parent classification code. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000072 | CODE, DOMAIN | Unique Index |
SQL030416034908590 | CLASIFCODE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_241 | CLASIFCODE_ID | CLSFCODEDS | CLASIFCODE_ID | Cascade |