CREATE TABLE site_location (
SID INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
site_name VARCHAR(50),
site_street_addr VARCHAR(50),
site_city VARCHAR(20),
site_state CHAR(2),
site_zip VARCHAR(9),
site_type VARCHAR(20),
car_need ENUM('Yes', 'No'),
paid ENUM('Yes', 'No'),
pay_range VARCHAR(20),
pay_date DATE,
skills_needed VARCHAR(150),
contact_name VARCHAR(50),
conatct_phone VARCHAR(15),
contact_fax VARCHAR(10),
contact_email VARCHAR(35),
super_name VARCHAR(50),
super_phone VARCHAR(15),
super_email VARCHAR(35)
);


CREATE TABLE site_workexp (
SiteID INT UNSIGNED NOT NULL,
work_exp_type VARCHAR(40) NOT NULL,
PRIMARY KEY (SiteID, work_exp_type)
);