WebSphere Commerce database table: ORDIOFFER

Each row of this table indicates an Offer that was searched to obtain the price for an OrderItem. These rows are created by the OrderItemAdd and OrderItemUpdate commands.


Column Description(s):
Column NameColumn TypeDescription
OFFER_ID BIGINT NOT NULL The Offer.
ORDERITEMS_ID BIGINT NOT NULL The OrderItem.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031245390 ORDERITEMS_ID+OFFER_ID Primary Key
I0000658 OFFER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_525 OFFER_ID OFFER OFFER_ID Cascade
F_526 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Feedback