schema

Database Schema

users

Column Name	Data Type	Details
id	integer	not null, primary key
email	string	not null, indexed, unique
password_digest	string	not null
fname	string	not null
lname	string	not null
session_token	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

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

notes

Column Name	Data Type	Details
id	integer	not null, primary key
heading	string
body	string
user_id	integer	not null, indexed, foreign key
notebook_id	integer	indexed, foreign key
tag_id	integer	indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• index on user_id
• index on notebook_id

notebooks

Column Name	Data Type	Details
id	integer	not null, primary key
title	string
user_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• index on user_id
• create a default "trash" notebook

tags

Column Name	Data Type	Details
id	integer	not null, primary key
note_id	integer	not null, indexed, foreign key
hashtag	string	not null
created_at	datetime	not null
updated_at	datetime	not null

tagged notes

Column Name	Data Type	Details
id	integer	not null, primary key
note_id	integer	not null, indexed, foreign key
tag_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• joins_table between tags and notes