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.