Product table (PRODUCT)

The product table identifies every product by a product ID and lists the product information.

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

CREATE TABLE PRODUCT
           ( PID         VARCHAR(10) NOT NULL, 
             NAME        VARCHAR(128), 
             PRICE       DECIMAL(30,2),
             PROMOPRICE  DECIMAL(30,2),
             PROMOSTART  DATE, 
             PROMOEND    DATE, 
             DESCRIPTION XML, 
             PRIMARY KEY (PID) )