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 |
