project_management - Laravel Schema Designer

projects

id increments
title string (500)
description longText
department_id integer
start_date date
due_date date
have_deadline enum
note longText
timestamps timestamps
softDeletes softDeletes

users

id increments
name string (100)
email string (200)
password string (500)
department string (150)
title string (250)
role_id integer
status enum
gender enum
phone string (20)
address string (500)
joining_date datetime
timestamps timestamps
softDeletes softDeletes

roles

id increments
role string (100)
timestamps timestamps
softDeletes softDeletes

user_projects

id increments
user_id integer
project_id integer
timestamps timestamps
softDeletes softDeletes

files

id increments
model_type string (200)
model_id integer
name string (500)
path string (1000)
size string
mimetype string
timestamps timestamps
softDeletes softDeletes

statuses

id increments
name string (100)
hex_color string (10)
type enum
timestamps timestamps
softDeletes softDeletes

project_status

id increments
project_id integer
status_id integer
timestamps timestamps
softDeletes softDeletes

tasks

id increments
name string (100)
project_id integer
priority_id string
timestamps timestamps
softDeletes softDeletes

task_statuses

id increments
task_id integer
status_id integer
softDeletes softDeletes
timestamps timestamps

user_tasks

id increments
user_id string
task_id string
timestamps timestamps
softDeletes softDeletes

permissions

id increments
name string
abilities string
timestamps timestamps
softDeletes softDeletes

priorities

id increments
name string
color string
timestamps timestamps
softDeletes softDeletes

comments

id increments
content text
comment_id string
lft string
rgt string
depth string
status enum
model_type string
model_id string
timestamps timestamps
softDeletes softDeletes

notes

id increments
name string
content string
file_id string
model_type string
model_id string
timestamps timestamps
softDeletes softDeletes

action_logs

id increments
user_id string
content string
model_type string
model_id string
timestamps timestamps
softDeletes softDeletes

role_permissions

id increments
role_id string
permision_id string
softDeletes softDeletes
timestamps timestamps

notifications

id increments
title string
content string
model_type string
model_id string
softDeletes softDeletes
timestamps timestamps

vaults

id increments
timestamps timestamps
softDeletes softDeletes
name string
password string
color string

vault_websites

id increments
vault_id string
name string
url string
password string
extra string
softDeletes softDeletes
timestamps timestamps
vault_file_id string

vault_settings

id increments
security_question string
security_answer string
vault_id string
support_pin string
timestamps timestamps
softDeletes softDeletes

user_vaults

id increments
user_id string
vault_id string
timestamps timestamps
softDeletes softDeletes

vault_securities

id increments
level string
name string
hash string
static_key string
algorithm string
setting_id string
timestamps timestamps
softDeletes softDeletes

vault_files

id increments
timestamps timestamps
vault_id string

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