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 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.
Indexes:
Index Name Indexed Column Names Index Type
I0000072 CODE, DOMAIN Unique Index
SQL030416034908590 CLASIFCODE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_241 CLASIFCODE_ID CLSFCODEDS CLASIFCODE_ID Cascade