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
name	string	not null, indexed, unique
city_id	integer	not null, indexed, unique
top_beer	string	not null
created_at	datetime	not null
updated_at	datetime	not null

media

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