Database Schema

users

Column Name	Data Type	Details
id	integer	not null, primary key
username	string	not null, indexed, unique
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
name	string	not null, indexed, unique
lat	float	not null
lng	float	not null
address	string	not null
website	string	not null
description	text
city_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

guides

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

brewery_guides

Column Name	Data Type	Details
id	integer	not null, primary key
brewery_id	integer	not null, indexed, unique, foreign key
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, foreign key
brewery_id	integer	not null, indexed, unique, foreign key
created_at	datetime	not null
updated_at	datetime	not null