This table holds categories created in each RFQ.
Column Name | Column Type | Column Description |
---|---|---|
NAME | VARCHAR (200) NOT NULL |
The external name that is used to identify the category of the products in RFQ. |
RFQCATEGRY_ID | BIGINT NOT NULL |
The internal reference number of the category used in the RFQ. |
RFQ_ID | BIGINT NOT NULL |
The internal reference number of the RFQ. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000297 | RFQ_ID, NAME | Unique Index |
SQL030416035050240 | RFQCATEGRY_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_994 | RFQ_ID | RFQ | RFQ_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_995 | RFQCATEGRY_ID | RFQPROD | RFQCATEGRY_ID | Cascade |