Database Schema

users

column name	data types	detail
id	integer	not null, primary key
username	string	not null, indexed, unique
email	string	not null, indexed, unique
age	integer	not null
password_digest	string	not null
session_token	string	not null, indexed, unique
image_url	string

• index on username, unique: true
• index on email, unique: true
• index on session_token, unique: true

pictures

column name	data types	detail
id	integer	not null, primary key
title	string	not null, indexed, unique
image_url	string
description	text
category_id	integer	not null, indexed, foreign key

• index on title, unique: true
• index on category_id
• category_id references categories

categories

column name	data types	detail
id	integer	not null, primary key
title	string	not null, indexed, unique

• index on title, unique: true

favorites

column name	data types	detail
id	integer	not null, primary key
picture_id	integer	not null, indexed, foreign key
board_id	integer	not null, indexed, foreign key

• picture_id references pictures
• board_id references boards
• index on [:picture_id, :board_id], unique: true
• board_id references boards

follows

column name	data types	detail
id	integer	not null, primary key
category_id	integer	not null, indexed, foreign key
user_id	integer	not null, indexed, foreign key

• category_id references categories
• user_id references users
• index on [:category_id, :user_id], unique: true

boards

column name	data types	detail
id	integer	not null, primary key
title	string	not null, indexed
description	text
user_id	integer	not null, foreign key

• user_id references users
• index on title