Database Schema

users

Column Name	Data Type	Details
id	integer	not null, primary key
email	string	not null, indexed, unique
password_digest	string	not null
session_token	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

cities

Column Name	Data Type	Details
id	integer	not null, primary key
name	string	not null, indexed, unique
state	string	not null, indexed
created_at	datetime	not null
updated_at	datetime	not null

breweries

Column Name	Data Type	Details
id	integer	not null, primary key
city_id	integer	not null, indexed, unique
guide_id	integer	not null, indexed, unique
name	string	not null, indexed, unique
lat	float	not null
lng	float	not null
address	string	not null
website	string	not null
created_at	datetime	not null
updated_at	datetime	not null

guides

Column Name	Data Type	Details
id	integer	not null, primary key
city_id	integer	not null, indexed, unique
title	string	not null, indexed, unique
body	text	not null
created_at	datetime	not null
updated_at	datetime	not null

favorites

Column Name	Data Type	Details
id	integer	not null, primary key
user_id	integer	not null, indexed, unique
brewery_id	integer	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null