WebSphere Commerce database table: RFQCATEGRY

RFQCATEGRY

Categories created in each RFQ.

Column Descriptions:

Name 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 used to identify the category of the products in RFQ.
RFQ_ID BIGINT NOT NULL The internal reference number of the RFQ.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> RFQCATEGRY_ID Primary Key
I0000297 RFQ_ID+NAME Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_994 RFQ_ID RFQ RFQ_ID Cascade

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_995 RFQCATEGRY_ID RFQPROD RFQCATEGRY_ID Cascade

Related reference
Request for Quote (RFQ) data model

Name	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 used to identify the category of the products in RFQ.
RFQ_ID	BIGINT NOT NULL	The internal reference number of the RFQ.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
<SYSTEM-GENERATED>	RFQCATEGRY_ID	Primary Key
I0000297	RFQ_ID+NAME	Unique Index