scs - Laravel Schema Designer

users

id increments
name string
email string
password string (60)
timestamps timestamps
role_id integer

roles

id increments
name string
display_name string
description string
timestamps timestamps

permissions

name string
id increments
display_name string
description string
timestamps timestamps

tasks

id increments
name string
status string
note string
project_id integer
start_date datetime
end_date datetime
completed_on datetime
timestamps timestamps

subtasks

id increments
task_id integer
user_id integer
timestamps timestamps

projects

id increments
project_name string
project_client string
description text
note text
start_date date
end_date date
status string (20)
completed_on datetime
mark_completed_by string
timestamps timestamps

quicknotes

id increments
text text
user_id integer
timestamps timestamps

timesheets

id increments
timestamps timestamps
title string
task_id string
date date
total_time_spent integer
total_hours integer
total_minutes integer
start_time datetime
end_time datetime
details text
remarks text
user_id integer

todos

id increments
timestamps timestamps
text string
status string
due_date datetime
user_id integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01