schema

Users

column name###	data type###	details###
id	integer	null false, primary key
first_name	string	null false
last_name	string	null false
email	string	null false
password_digest	string	null false
session_token	string	null false
zip_code	string	null false
birthday	date	optional
profile_pic	string	optional
created_at	datetime	not null
updated_at	datetime	not null

Businesses

column name###	data type###	details###
id	integer	null false, primary key
name	string	null false
address	string	null false
phone_number	string	null false
profile_pic	string	null false
website	string	optional
cuisine	string	null false
mon_start_time	integer	optional
mon_end_time	integer	optional
tue_start_time	integer	optional
tue_end_time	integer	optional
wed_start_time	integer	optional
wed_end_time	integer	optional
thur_start_time	integer	optional
thur_end_time	integer	optional
fri_start_time	integer	optional
fri_end_time	integer	optional
sat_start_time	integer	optional
sat_end_time	integer	optional
sun_start_time	integer	optional
sun_end_time	integer	optional
created_at	datetime	null false
updated_at	datetime	null false

Reviews

column name###	data type###	details###
id	integer	null false, primary key
user_id	integer	null false, foreign key
business_id	integer	null false, foreign key
rating	integer	null false
price_range	integer	optional
body	text	null false
delivery	boolean	optional
noise_level	integer	optional
timestamp	date	null false
created_at	datetime	null false
updated_at	datetime	null false

Photos

column name###	data type###	details###
id	integer	null false, primary key
user_id	integer	null false, primary key
business_id	integer	null false, primary key