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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034856490 | CATENTRY_ID, DOMAIN | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_186 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|