TABLE_(prospect_detail)
	INT_        	(prospect_id)	      PRIMARY_KEY AUTO_INCREMENT
	STRING_     	(first_name, 30)	
	STRING_     	(middle_name, 30)	
	STRING_     	(last_name, 30)		
	STRING_		(suffix_name, 5)	
	STRING_     	(address_1, 50)		
	STRING_     	(address_2, 50)		
	STRING_     	(city, 30)			
	STRING_     	(state, 2)			
	INT_		(zip)			
	INT_ARRAY_	(phone_1, 3)			
	INT_ARRAY_	(phone_2, 3)			
	INT_ARRAY_	(phone_3, 3)			
	INT_ARRAY_	(phone_w, 3)			
	INT_ARRAY_	(ssn, 3)				
	INT_		(beacon)			
	BOOL_		(is_sales)			
	BOOL_		(is_service)
	INT_		(wants)			//this should be a stock #	
END_TABLE

TABLE_(documents)
        INT_            (doc_id)                PRIMARY_KEY AUTO_INCREMENT
        INT             (prospect_id)           REFERENCES(prospect_detail.prospect_id)
	BLOB_		(docs)
END_TABLE				

TABLE_(employers)
	INT_		(employer_number)	PRIMARY_KEY AUTO_INCREMENT
        INT             (prospect_id)           REFERENCES(prospect_detail.prospect_id)
	STRING_		(employer_name, 50)
	INT_ARRAY_	(employer_phone_1, 3)
	INT_ARRAY_	(employer_phone_2, 3)
	STRING_		(contact, 50)
	STRING_		(employer_addy_1, 50)
	STRING_		(employer_addy_2, 50)
	STRING_		(employer_city, 30)
	STRING_ 	(employer_st, 2)
	STRING_		(employer_zip, 5)
	DATE_		(hire_date)
	DATE_		(quit_date)
	BOOL_		(is_currant)
	DOUBLE_		(gross_monthly_income)
END_TABLE	

TABLE_(vehicles_owned)
	STRING_		(vin, 17)	PRIMARY_KEY
        INT             (prospect_id)           REFERENCES(prospect_detail.prospect_id)
	INT_		(year)
	STRING_		(make, 15)
	STRING_		(model, 30)
	STRING_		(trim_package, 10)
	STRING_		(engine, 10)
	INT_		(miles)
	DOUBLE_		(acv)
	DOUBLE_		(show)
END_TABLE