OPTIM_ITEMS table

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.



Feedback