users

column_name	data_type	details
id	integer	not_null, primary_key
session_token	string	not_null, unique, indexed
email	string	not_null, unique, indexed
password_digest	string	not_null
image_url	string

• index on email, unique: true
• index on session_token, unique: true

restaurants

column_name	data_type	details
id	integer	not_null, primary_key
owner_id	integer	not_null, foreign_key
name	string	not_null, unique, indexed
address	string	not_null, unique, indexed
cuisine	string	indexed
phone_number	integer
image_url	string

• owner_id references users

reviews

column_name	data_type	details
id	integer	not_null, primary_key
user_id	integer	not_null, foreign_key
restaurant_id	integer	not_null, foreign_key
title	string	not_null
body	text	not_null
rating	integer

• user_id references users
• restaurant_id references restaurants

reservations

column_name	data_type	details
id	integer	not_null, primary_key
user_id	integer	not_null, foreign_key
restaurant_id	integer	not_null, foreign_key
date	string	not_null

• user_id references users
• restaurant_id references restaurants