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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|