Database Schema

Users

column	data type	detail
id	integer	not null, primary key
first_name	string	not null
last_name	string	not null
email	string	not null
password_digest	string	not null
session_token	string	not null
hometown	string	optional
workplace	string	optional
school	string	optional
gender	string	optional
image_url	string	optional
timestamps	datetime

Posts

column	data type	detail
id	integer	not null, primary key
body	text	not null
author_id	integer	not null, foreign key
post_image_url	string
timestamps	datetime

Comments

column	data type	detail
id	integer	not null, primary key
body	string	not null
author_id	integer	not null, foreign key
timestamps	datetime

Likes

column	data type	detail
id	integer	not null, primary key
post_id	integer	not null, foreign key
author_id	integer	not null, foreign key
timestamps	datetime

Friendships

column	data type	detail
id	integer	not null, primary key
friend_id	integer	not null, foreign key
timestamps	datetime