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 Name Column Type Column Description
OFFER_ID BIGINT
NOT NULL
The Offer.
ORDERITEMS_ID BIGINT
NOT NULL
The OrderItem.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035019710 ORDERITEMS_ID, OFFER_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable