Database Table: RFQCATEGRY

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000297 RFQ_ID, NAME Unique Index
SQL030416035050240 RFQCATEGRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_994 RFQ_ID RFQ RFQ_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_995 RFQCATEGRY_ID RFQPROD RFQCATEGRY_ID Cascade