WebSphere Commerce database table: RFQCATEGRY

This table holds categories created in each RFQ.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000297 RFQ_ID+NAME Unique Index
SQL050212031304750 RFQCATEGRY_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_994 RFQ_ID RFQ RFQ_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_995 RFQCATEGRY_ID RFQPROD RFQCATEGRY_ID Cascade

Feedback