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:
- The OPTIM_ORDERS table, through its foreign key
on column ORDER_ID.
- The OPTIM_ITEMS table, through its foreign key on
column ITEM_ID.