FIT 100
vCREATE TABLE PRODUCT
(P_CODE VCHAR(10) NOT
NULL UNIQUE,
P_DESCRIPT VCHAR(35) NOT NULL,
P_INDATE DATE NOT NULL,
P_ONHAND SMALLINT NOT NULL,
P_MIN SMALLINT NOT NULL,
P_PRICE DECIMAL(8,2) NOT NULL,
P_DISCOUNT DECIMAL(4,1) NOT NULL,
V_CODE SMALLINT,
PRIMARY KEY (P_CODE),
FOREIGN KEY (V_CODE)
REFERENCES VENDOR
ON DELETE
RESTRICT
ON UPDATE CASCADE);