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
follows	integer	default: [] array: true
following	integer	default: [] array: true

follows - is for users following current user
following - is for users the current user follows

Boards

Column name	Data type	Details
ID	integer	not null primary key
author_id	integer	not null indexed foreign key(user)
description	string or text	not null
title	string	not null

pins

Column name	Data type	Details
id	integer	not null primary key
title	string	not null
description	string	not null
url	string	not null
author_id	integer	not null indexed foreign key(user)
board_id	integer	indexed foreign key(board