WebSphere Commerce database table: RFQRSPEVAL

This table holds all the response product evaluations for the RFQ.

Column Descriptions
Column Name Column Type Description
RFQRSPEVAL_ID BIGINT NOT NULL The internal reference number of the evaluation.
EVALRESULT INTEGER NOT NULL DEFAULT 1 Indicates if this product is accepted. Valid values are as follows:

  • 0=Lost or rejected

  • 1=Won or accepted

REMARKS VARCHAR(254) Free-form remarks.
UPDATETIME TIMESTAMP Date and time the evaluation was updated.
RFQ_ID BIGINT NOT NULL The internal reference number of the RFQ request.
RFQRSP_ID BIGINT NOT NULL The internal reference number of the RFQ response.
RFQRSPPROD_ID BIGINT NOT NULL The internal reference number of the product included in the RFQ response.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235243380 RFQRSPEVAL_ID Primary Key
I0000338 RFQRSPPROD_ID Non-Unique Index
I0000728 RFQRSP_ID Non-Unique Index
I0000729 RFQ_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_996 RFQ_ID RFQ RFQ_ID Cascade
F_997 RFQRSP_ID RFQRSP RFQRSP_ID Cascade
F_998 RFQRSPPROD_ID RFQRSPPROD RFQRSPPROD_ID Cascade
Related reference