Database Table: CATCLSFCOD

This table contains the assignment of classification codes to CatalogEntries.

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NOT NULL
The reference number of the CatalogEntry.
CODE CHARACTER (16)
NOT NULL
Classification code assigned under a particular classification domain.
DOMAIN CHARACTER (32)
NOT NULL
Classification domain used to assign a code. One such example is UNSPSC classification system.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034856490 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable