WebSphere Commerce database table: ORDQUOTREL

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

Column Descriptions
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
SQL060903235223050 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