project_management - Laravel Schema Designer

users

id increments
name string (191)
email string (191)
password string
photo string
email_verified_at string
remember_token string
isAdmin boolean
timestamps timestamps

projects

id increments
name string
description string
created_by ^FK integer
manager string
status enum
duration string
timestamps timestamps

tasks

id increments
name string
description string
start_date date
end_date date
status enum
created_by ^FK integer
assigned_to ^FK integer
priority enum
completion_date date
timestamps timestamps

invitations

id increments
project_id ^FK integer
user_id ^FK integer
role_id ^FK integer
status enum
timestamps timestamps

roles

id increments
name string
timestamps timestamps

subtasks

id increments
name string (191)
task_id ^FK integer
description string
start_date date
end_date date
priority enum
status enum
timestamps timestamps

user_tasks

id increments
user_id ^FK integer
task_id ^FK integer
timestamps timestamps

user_projects

id increments
user_id ^FK integer
project_id ^FK integer
timestamps timestamps

notifications

id increments
timestamps timestamps
message string
isRead boolean
user_id integer

comments

id increments
timestamps timestamps
task_id integer
comment string

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