WebSphere Commerce database table: ORDQUOTREL

Reference > Database > WebSphere Commerce database tables > O

WebSphere Commerce database table: ORDQUOTREL

Each row of this table represents a relationship between a parent Order and a child Order.

Column Name Column Type Description
PARENT_ID BIGINT NOT NULL The parent Order.
CHILD_ID BIGINT The child Order.
ORDQUOTREL_ID BIGINT NOT NULL Generated primary key.
CHILDSTORE_ID INTEGER The Store of the child Order.
TRADING_ID BIGINT The TradingAgreement that governs this relationship.
RELTYPE CHAR(16) NOT NULL Indicates the type of relationship represented by this OrderQuotationRel object.

initial = the child Order represents a quotation received for the items in the parent Order.

selection = the child Order represents specified quantities of items selected from a quotation for the parent Order.

final = the child Order represents a quotation received for the items in the selection child Order for the parent Order.

submission = the child Order represents a submitted Order (OrderProcess has been invoked) for the parent Order.
TIMEOUTTIME TIMESTAMP The time the user interface should stop polling to see if the child Order has been received yet.
DISPLAYSEQUENCE DOUBLE NOT NULL DEFAULT 0 Can be used by a user interface to determine the sequence in which child Orders should be displayed.
FLAGS INTEGER NOT NULL DEFAULT 0 Bit flags for the Order Quotation Relationship record. Bit 1 = The response for the order quotation request resulted in an error. The Order associated with the Order Quotation Relationship record has a status of 'H'. An ORDSTAT record is created with the response message's status message in the OSCMNT column.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030404490 ORDQUOTREL_ID Primary Key
I0000278 CHILD_ID Non-Unique Index
I0000308 PARENT_ID+RELTYPE+CHILDSTORE_ID+CHILD_ID Non-Unique Index
I0000309 CHILDSTORE_ID+CHILD_ID+RELTYPE+PARENT_ID Non-Unique Index
I0000673 TRADING_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_932 CHILD_ID ORDERS ORDERS_ID Cascade
F_933 PARENT_ID ORDERS ORDERS_ID Cascade
F_934 CHILDSTORE_ID STORE STORE_ID Cascade
F_931 TRADING_ID TRADING TRADING_ID Cascade

Related reference

Order trading agreement data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
PARENT_ID	BIGINT NOT NULL	The parent Order.
CHILD_ID	BIGINT	The child Order.
ORDQUOTREL_ID	BIGINT NOT NULL	Generated primary key.
CHILDSTORE_ID	INTEGER	The Store of the child Order.
TRADING_ID	BIGINT	The TradingAgreement that governs this relationship.
RELTYPE	CHAR(16) NOT NULL	Indicates the type of relationship represented by this OrderQuotationRel object. initial = the child Order represents a quotation received for the items in the parent Order. selection = the child Order represents specified quantities of items selected from a quotation for the parent Order. final = the child Order represents a quotation received for the items in the selection child Order for the parent Order. submission = the child Order represents a submitted Order (OrderProcess has been invoked) for the parent Order.
TIMEOUTTIME	TIMESTAMP	The time the user interface should stop polling to see if the child Order has been received yet.
DISPLAYSEQUENCE	DOUBLE NOT NULL DEFAULT 0	Can be used by a user interface to determine the sequence in which child Orders should be displayed.
FLAGS	INTEGER NOT NULL DEFAULT 0	Bit flags for the Order Quotation Relationship record. Bit 1 = The response for the order quotation request resulted in an error. The Order associated with the Order Quotation Relationship record has a status of 'H'. An ORDSTAT record is created with the response message's status message in the OSCMNT column.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL100520030404490	ORDQUOTREL_ID	Primary Key
I0000278	CHILD_ID	Non-Unique Index
I0000308	PARENT_ID+RELTYPE+CHILDSTORE_ID+CHILD_ID	Non-Unique Index
I0000309	CHILDSTORE_ID+CHILD_ID+RELTYPE+PARENT_ID	Non-Unique Index
I0000673	TRADING_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_932	CHILD_ID	ORDERS	ORDERS_ID	Cascade
F_933	PARENT_ID	ORDERS	ORDERS_ID	Cascade
F_934	CHILDSTORE_ID	STORE	STORE_ID	Cascade
F_931	TRADING_ID	TRADING	TRADING_ID	Cascade