Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RFQRSPPARL
This table holds the relationship of the personalized attributes in the RFQ and the response.
Column Name Column Type Description RFQRSPPARL_ID BIGINT NOT NULL The internal reference number of the RFQ and Response personalized attributes 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. RFQPATTRVALUE_ID BIGINT NOT NULL The internal reference number of the RFQ Personalized Attribute Value. RFQRSPPATTRVAL_ID BIGINT The internal reference number of the RFQ response Personalized Attribute Value. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030422630 RFQRSPPARL_ID Primary Key I0000359 RFQPATTRVALUE_ID Non-Unique Index I0000730 RFQ_ID Non-Unique Index I0000731 RFQRSP_ID Non-Unique Index I0000732 RFQRSPPATTRVAL_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_990 RFQRSPPATTRVAL_ID PATTRVALUE PATTRVALUE_ID Cascade F_993 RFQPATTRVALUE_ID PATTRVALUE PATTRVALUE_ID Cascade F_992 RFQ_ID RFQ RFQ_ID Cascade F_991 RFQRSP_ID RFQRSP RFQRSP_ID Cascade
Related reference
_vcc_freeselect_bottom_