Inventory table (INVENTORY)

The inventory table describes the inventory based on a product ID.

The inventory table is created with the following CREATE TABLE statement:

CREATE TABLE INVENTORY
           ( PID         VARCHAR(10) NOT NULL, 
             QUANTITY    INTEGER, 
             LOCATION    VARCHAR(128),
             PRIMARY KEY (PID) )