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, 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

Posts

column name	data type	details
id	integer	not null, primary key
title	string	not null
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, foreign key
post_id	integer	not null, foreign key
created_at	datetime	not null
updated_at	datetime	not null

Likes

column name	data type	details
id	integer	not null, primary key
liker_id	integer	not null, indexed, foreign key
comment_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

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