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 Descriptions
Column Name Column Type Description
OFFER_ID BIGINT NOT NULL The Offer.
ORDERITEMS_ID BIGINT NOT NULL The OrderItem.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235220920 ORDERITEMS_ID+OFFER_ID Primary Key
I0000658 OFFER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_525 OFFER_ID OFFER OFFER_ID Cascade
F_526 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
Related reference