TableOpen 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

restaurants

column name	data type	details
id	integer	not null, primary key
name	string	not null, indexed, unique
phone_number	integer	not null, unique
hours_of_op	string	not null
Executive Chef	string
city	string	not null
description	text	not null
rating	integer
create_at	datetime	not null
updated_at	datetime	not null

reviews

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed, foreign key
restaurant_id	integer	not null, indexed, foreign key
body	string	not null
title	string	not null
rating	integer	not null
create_at	datetime	not null
updated_at	datetime	not null

reservations

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed, foreign key
restaurant_id	integer	not null, indexed, foreign key
time	datetime	not null
party_size	integer	not null
create_at	datetime	not null
updated_at	datetime	not null