Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce 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 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 SQL100520030422910 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
Related reference
_vcc_freeselect_bottom_