WebSphere Commerce database table: RFQRSPTCRL

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

Column Descriptions
Column Name Column Type Description
RFQRSPTCRL_ID BIGINT NOT NULL The internal reference number of the RFQ Response term or condition relationship.
RFQ_ID BIGINT NOT NULL The internal reference number of the RFQ.
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.
RFQRSPTC_ID BIGINT NOT NULL The internal reference number of the RFQ Response term or condition.
CHANGEFLAG INTEGER Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

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
SQL060903235243840 RFQRSPTCRL_ID Primary Key
I0000735 RFQRSPTC_ID Non-Unique Index
I0000736 RFQRSP_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_690 RFQ_ID RFQ RFQ_ID Cascade
F_1000 RFQRSP_ID RFQRSP RFQRSP_ID Cascade
F_691 RFQRSPTC_ID TERMCOND TERMCOND_ID Cascade
F_692 RFQTC_ID TERMCOND TERMCOND_ID Cascade