Schema

users

column name	type	description
id	integer	null: false
username	string	null: false, unique
email	string	null: false, unique
password_digest	string	null: false
session_token	string	null: false, unique
created_at	datetime	null: false
updated_at	datetime	null: false

• has_many: tracks
• has_many: comments through: tracks

tracks

column name	type	description
id	integer	null: false
title	string	null: false
user_id	integer	null: false
created_at	datetime	null: false
updated_at	datetime	null: false

• user_id references user
• has_many: comments

comments

column name	type	description
id	integer	null: false
author_id	integer	null: false
track_id	integer	null: false
body	text	null: false
created_at	datetime	null: false
updated_at	datetime	null: false

• add_index :comments, [:author_id, :id]
• has_one: author -author_id references users
• has_one: track - track_id references tracks