WebSphere Commerce database table: RFQRSPTCRL

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000211 RFQ_ID+RFQRSP_ID+RFQTC_ID+RFQRSPTC_ID Unique Index
I0000212 RFQTC_ID+RFQRSPTC_ID Unique Index
SQL050212031305540 RFQRSPTCRL_ID Primary Key
I0000735 RFQRSPTC_ID Non-Unique Index
I0000736 RFQRSP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback