WebSphere Commerce database table: ORDQUOTREL

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


Column Description(s):
Column NameColumn TypeDescription
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 Rel record. Bit 1 = The response for the order quotation request resulted in an error. The Order associated with the Order Quotation Rel 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(es):
Index NameIndexed Column NamesIndex Type
SQL050212031248870 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(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback