Schema

Database Schema

users

column name	data type	details
id	integer	not null, primary key
name	string	not null, indexed, unique
email	string	not null, indexed, unique
password_digest	string	not null
session_token	string	not null, indexed, unique

stories

column name	data type	details
id	integer	not null, primary key
title	string	not null
body	text	not null
topic	string
user_id	integer	not null, foreign key

• user_id references users

bookmarks

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed, foreign key
story_id	integer	not null, indexed, foreign key

• user_id references users
• story_id references stories

likes

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed, foreign key
story_id	integer	not null, indexed, foreign key

• user_id references users
• story_id references stories

comments

column name	data type	details
id	integer	not null, primary key
body	text	not null
user_id	integer	not null, indexed, foreign key
story_id	integer	not null, indexed, foreign key

• user_id references users
• story_id references stories

user_follows

column name	data type	details
id	integer	not null, primary key
follower_id	integer	not null, indexed, foreign key
followed_id	integer	not null, indexed, foreign key

• follower_id and followed_id reference users

tags

column name	data type	details
id	integer	not null, primary key
name	string	not null
story_id	integer	not null, foreign key

• story_id reference stories