pusdatin - Laravel Schema Designer

users

id increments
uuid string
name string
email string
password string
is_active integer
created_by integer
timestamps timestamps
softDeletes softDeletes

company_types

id increments
uuid string
name string
timestamps timestamps
softDeletes softDeletes

companies

id increments
uuid string
company_type_id string
parent_id integer
name string
address text
city_id integer
zip_code string
phone string
email string
timestamps timestamps
softDeletes softDeletes

departments

id increments
uuid string
name string
company_id integer
timestamps timestamps
softDeletes softDeletes

sub_departments

id increments
uuid string
name string
department_id integer
timestamps timestamps
softDeletes softDeletes

employees

id increments
uuid string
number string
name string
title string
gender enum
pob string
dob date
nik string
address text
city_id integer
zip_code string
phone string
email string
join_year string
is_active integer
timestamps timestamps
softDeletes softDeletes

projects

id increments
uuid string
company_id integer
project_owner_id integer
project_category_id integer
name string
starting_date datetime
expected_finish_date datetime
desc text
created_by integer
timestamps timestamps
softDeletes softDeletes

epics

id increments
uuid string
project_id integer
name string
desc text
starting_date datetime
expected_finish_date datetime
timestamps timestamps
softDeletes softDeletes

stories

id increments
uuid string
epic_id integer
name string
desc text
starting_date datetime
expected_finish_date datetime
timestamps timestamps
softDeletes softDeletes

task_categories

id increments
uuid string
name string
timestamps timestamps
softDeletes softDeletes

tasks

id increments
uuid string
task_category_id integer
subject string
is_recurring integer
recurrence_type enum
has_reminder integer
starting_date datetime
expected_finish_date datetime
brief text
timestamps timestamps
softDeletes softDeletes

task_recurrences

id increments
uuid string
task_id integer
next_iteration_at datetime
previous_iteration_at datetime
timestamps timestamps
softDeletes softDeletes

task_reminder

id increments
uuid string
task_id integer
starting_at datetime
deadline_at datetime
timestamps timestamps
softDeletes softDeletes

task_attachments

id increments
uuid string
task_id integer
file_name string
path string
timestamps timestamps
softDeletes softDeletes

task_required_docs

id increments
uuid string
task_id integer
name string
timestamps timestamps
softDeletes softDeletes

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