Postgres Database Schema

Users

column name	data type	details
id	integer	not null, primary key
lastname	string	not null, indexed, unique
firstname	string	not null
age	integer	not null
gender	string	not null
location	string	*allow_nil
occupation	string	*allow_nil
email	string	not null, indexed, unique
password_digest	string	not null, indexed
session_token	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

Posts

column name	data type	details
id	integer	not null, primary key
message	text	not null
poster_id	integer	not null, indexed, foreign key
wall_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

Comments

column name	data type	details
id	integer	not null, primary key
body	text	not null
author_id	integer	not null, indexed, foreign key
post_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

Likes

column name	data type	details
id	integer	not null, primary key
likeable_id	integer	not null, indexed, foreign key
likeable_type	integer	not null, indexed, foreign key
liker_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

Friend Requests

column name	data type	details
id	integer	not null, primary key
sender_id	integer	not null, indexed, foreign key
receiver_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

Friendships

column name	data type	details
id	integer	not null, primary key
friend1_id	integer	not null, indexed, foreign key
friend2_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null