task-management - Laravel Schema Designer

opd

id increments
name string (255)
kunkerja char (191)
as_unkerja string (191)
softDeletes softDeletes
timestamps timestamps

project

id increments
opd_id tinyInteger
name string (255)
start_date datetime
end_date datetime
description text
staf_id integer
softDeletes softDeletes
timestamps timestamps

task

id increments
project_id integer
name string (255)
description text
start_date datetime
end_date datetime
staff_id integer
member_id integer
softDeletes softDeletes
timestamps timestamps

staf

id increments
full_name string (255)
user_id integer
opd_id string (255)
softDeletes softDeletes
timestamps timestamps

comment

id increments
task_id integer
user_id integer
title string (255)
comment text
url string (255)
file string (255)
softDeletes softDeletes
timestamps timestamps

member

id increments
user_id integer
full_name string (255)
softDeletes softDeletes
timestamps timestamps

users

id increments
name string (191)
timestamps timestamps
softDeletes softDeletes

comment_ratings

id increments
timestamps timestamps
softDeletes softDeletes
comment_id integer
user_id integer
rating integer

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