Database Table: RFQRSPTCRL

The relationship between one specified RFQ term or condition, and an RFQ Response to this term or condition.

Column Name Column Type Column Description
CHANGEFLAG INTEGER
NULL
Reserved for IBM internal use.
RFQRSPTCRL_ID BIGINT
NOT NULL
The internal reference number of the RFQ Response term or condition relationship.
RFQRSPTC_ID BIGINT
NOT NULL
The internal reference number of the RFQ Response term or condition.
RFQRSP_ID BIGINT
NOT NULL
The internal reference number of the RFQ Response.
RFQTC_ID BIGINT
NOT NULL
The internal reference number of the RFQ term or condition.
RFQ_ID BIGINT
NOT NULL
The internal reference number of the RFQ.
Indexes:
Index Name Indexed Column Names Index Type
I0000211 RFQ_ID, RFQRSP_ID, RFQTC_ID, RFQRSPTC_ID Unique Index
I0000212 RFQTC_ID, RFQRSPTC_ID Unique Index
SQL030416035052330 RFQRSPTCRL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1000 RFQRSP_ID RFQRSP RFQRSP_ID Cascade
F_690 RFQ_ID RFQ RFQ_ID Cascade
F_691 RFQRSPTC_ID TERMCOND TERMCOND_ID Cascade
F_692 RFQTC_ID TERMCOND TERMCOND_ID Cascade

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