Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RFQCATEGRY
This table holds categories created in each RFQ.
Column Name Column Type Description RFQCATEGRY_ID BIGINT NOT NULL The internal reference number of the category used in the RFQ. NAME VARCHAR(200) NOT NULL The external name that is used to identify the category of the products in RFQ. RFQ_ID BIGINT NOT NULL The internal reference number of the RFQ. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000297 RFQ_ID+NAME Unique Index SQL100520030422010 RFQCATEGRY_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_994 RFQ_ID RFQ RFQ_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_995 RFQCATEGRY_ID RFQPROD RFQCATEGRY_ID Cascade
Related reference
_vcc_freeselect_bottom_