CREATE TABLE product (
pid INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
pname VARCHAR (50) NOT NULL,
pprice DECIMAL (8, 2) NOT NULL,
pdesc VARCHAR (100) NULL,
pcount INT (11) NOT NULL DEFAULT '0'
);
CREATE TABLE vendor (
vid INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
vname VARCHAR (50) NOT NULL,
vaddress VARCHAR (50) NULL,
vcity VARCHAR (50) NULL,
vstate VARCHAR (20) NULL,
vzip VARCHAR (10) NULL,
vcountry VARCHAR (50) NULL
);
CREATE TABLE recruit (
rid INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
pid INT (11) NOT NULL,
vid INT (11) NOT NULL,
CONSTRAINT pid FOREIGN KEY (pid) REFERENCES product (pid),
CONSTRAINT vid FOREIGN KEY (vid) REFERENCES vendor (vid),
rprice DECIMAL (10, 0) NOT NULL,
rcount INT (11) NOT NULL,
returncount INT (11) NULL,
rdecp VARCHAR (255) NULL,
rdate TIMESTAMP
);