Database Table: RFQRSPPARL

This table holds the relationship of the personalized attributes in the RFQ and the response.

Column Name Column Type Column Description
RFQPATTRVALUE_ID BIGINT
NOT NULL
The internal reference number of the RFQ Personalized Attribute Value.
RFQRSPPARL_ID BIGINT
NOT NULL
The internal reference number of the RFQ and Response personalized attributes relationship.
RFQRSPPATTRVAL_ID BIGINT
NULL
The internal reference number of the RFQ response Personalized Attribute Value.
RFQRSP_ID BIGINT
NOT NULL
The internal reference number of the RFQ response.
RFQ_ID BIGINT
NOT NULL
The internal reference number of the RFQ.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035051660 RFQRSPPARL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_990 RFQRSPPATTRVAL_ID PATTRVALUE PATTRVALUE_ID Cascade
F_991 RFQRSP_ID RFQRSP RFQRSP_ID Cascade
F_992 RFQ_ID RFQ RFQ_ID Cascade
F_993 RFQPATTRVALUE_ID PATTRVALUE PATTRVALUE_ID Cascade

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