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 Descriptions:

NameTypeDescription
OFFER_IDBIGINT NOT NULLThe Offer.
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERITEMS_ID+OFFER_IDPrimary Key
I0000658OFFER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_525OFFER_IDOFFEROFFER_IDCascade
F_526ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade