CREATE TABLE companyInfo (
	company						VARCHAR(100)	NOT NULL,
	employerType				VARCHAR(25)		NOT NULL,
	businessType				VARCHAR(50)		NOT NULL,
	employerProfile				TEXT(10000),
	website						VARCHAR(200),
	workWithRecruitingFirms		VARCHAR(3)		NOT NULL,
	numberEmployeesFull			VARCHAR(200),	
	numberEmployeesPart			VARCHAR(200),
	numberInterns				VARCHAR(200),	
	numberVolunteers			VARCHAR(200),
	profilePhone1				CHAR(3)			NOT NULL,
	profilePhone2				CHAR(3)			NOT NULL,
	profilePhone3				CHAR(4)			NOT NULL,
	profileFax1					CHAR(3),	
	profileFax2					CHAR(3),
	profileFax3					CHAR(4),
	profileToll1				CHAR(1),
	profileToll2				CHAR(3),
	profileToll3				CHAR(3),
	profileToll4				CHAR(3),
	profileToll5				CHAR(4),
	profileEmail				VARCHAR(200),	
	profileAddress1				VARCHAR(200)	NOT NULL,
	profileAddress2				VARCHAR(200),	
	profileCity					VARCHAR(200)	NOT NULL,
	profileProvince				VARCHAR(200)	NOT NULL,
	profilePostalCode			VARCHAR(200)	NOT NULL,
	profileCountry				VARCHAR(200)	NOT NULL,
	missionStatement			TEXT(10000),
PRIMARY KEY(company))