schema.md

Schema Information

barbers

column name	data type	details
id	integer	not null, primary key
shop_id	integer	not null, foreign key (references shops)
name	string	not null
rating	float

Pictures

column name	data type	details
id	integer	not null, primary key
file_name	string	not null
imageable_id	integer
imageable_type	string

add_index imageabel_id Can belong to a review, can belong to a barber.

Reviews

column name	data type	details
id	integer	not null, primary key
author_id	integer	not null, foreign key (references users)
shop_id	integer	not null, foreign key (references shops)
rating	integer	not null
body	string	not null

shops

column name	data type	details
id	integer	not null, primary key
moderator_id	integer	not null, foreign key (references users)
title	string	not null
address	integer	not null
city	string	not null
state	string	not null
zip	integer	not null
phone	integer	not null
rating	float
lat	float	not null
long	float	not null

tags

column name	data type	details
id	integer	not null, primary key
label	string	not null, unique

taggings

column name	data type	details
id	integer	not null, primary key
shop_id	integer	not null, foreign key (references shops)
tag_id	integer	not null, foreign key (references tags)

users

column name	data type	details
id	integer	not null, primary key
email	string	not null, unique
password_digest	string	not null
session_token	string	not null, unique
photo_url	string	not null