Schema

Database Schema

users

column name	data type	info
id	integer	null:false, unique:true, indexed
name	string	null:false, indexed
email	string	null:false, unique:true
password_digest	string	null:false, unique:true
session_token	string	null:false, unique:true, indexed
timestamps	datetime

projects

column name	data type	info
id	integer	null:false, unique:true, indexed
name	string	null:false, indexed
description	text
timestamps	datetime

Todo Lists

todo_lists

column name	data type	info
id	integer	null:false, unique:true, indexed
name	string	null:false, indexed
details	text
author_id	integer	null:false, indexed
follower_id	integer	indexed
timestamps	datetime

todo_items

column name	data type	info
id	integer	null:false, unique:true, indexed
description	string	null:false, indexed
assigned_id	integer	indexed
author_id	integer	null:false, indexed
notes	string
due	datetime
complete	boolean	null:false
timestamps	datetime

Message Board

messages

column name	data type	info
id	integer	null:false, unique:true, indexed
title	string	null:false, indexed
category	string	indexed
author_id	integer	null:false, indexed
body	text	null:false
timestamps	datetime

boosts

column name	data type	info
id	integer	null:false, unique:true, indexed
author_id	integer	null:false, indexed
message_id	integer	null:false, indexed
body	string	null:false
timestamps	datetime

Schedule

events

column name	data type	info
id	integer	null:false, unique:true, indexed
name	string	null:false, indexed
start	datetime	null:false
end	datetime	null:false
notes	text
author_id	integer	null:false
timestamps	datetime

Poloymorphic Associations:

subscriptions

column name	data type	info
id	integer	null:false, unique:true, indexed
user_id	integer	null:false, indexed
subscribable	reference	polymorphic: true
timestamps	datetime

• todo items, todo lists, todo items, messages, and schedule are subscribable

assignments

column name	data type	info
id	integer	null:false, unique:true, indexed
user_id	integer	null:false, indexed
assignable	reference	polymorphic: true
timestamps	datetime

• todo items, todo lists, todo items, messages, and schedule are assignable

comments

column name	data type	info
id	integer	null:false, unique:true, indexed
user_id	integer	null:false, indexed
commentable	reference	polymorphic: true
timestamps	datetime

• todo items, todo lists, todo items, messages, and schedule are commentable

Recent Updates Displayed at bottom of page

• Project Activity from timestamps info