OPTIM_DETAILS table

The OPTIM_DETAILS table contains additional information for each order in the OPTIM_ORDERS table.

The OPTIM_DETAILS table has the following columns:

ORDER_ID
DECIMAL; order ID number; cannot contain null.
ITEM_ID
CHAR; up to 5 characters; item ID number; cannot contain null.
ITEM_QUANTITY
DECIMAL; number of items; cannot contain null.
DETAIL_UNIT_PRICE
DECIMAL; unit price; dollar amount; cannot contain null.

Primary keys

The ORDER_ID and ITEM_ID columns are the primary key.

Relationships to other tables

The OPTIM_DETAILS table is a child of:



Feedback