The OPTIM_ITEMS table contains information about each item
for an order, including description, price, and quantity in inventory.
The OPTIM_ITEMS table has the following
columns:
- ITEM_ID
- CHAR; up to 5 characters; cannot contain null.
- ITEM_DESCRIPTION
- VARCHAR; up to 72 characters; cannot contain null.
- CATEGORY
- VARCHAR; up to 14 characters; cannot contain null.
- RATING
- CHAR; up to 4 characters; cannot contain null.
- UNIT_PRICE
- DECIMAL; dollar amount; cannot contain null.
- ON_HAND_INVENTORY
- INTEGER; cannot contain null.
Primary keys
The
ITEM_ID column is the primary key column.
Relationships to other tables
The OPTIM_ITEMS table is a parent of the OPTIM_DETAILS
table, through a foreign key on column ITEM_ID.