siprama-erp - Laravel Schema Designer

employees

id increments
timestamps timestamps
softDeletes softDeletes
nik string (191)
full_name string (191)
user_id integer
department_id integer
position_id integer
date_joined datetime
date_end datetime
gender string (25)
date_birth date

departments

id increments
timestamps timestamps
softDeletes softDeletes
name string (25)

posisitions

id increments
timestamps timestamps
softDeletes softDeletes
department_id integer
name string (191)
level tinyInteger

user_heads

id increments
user_id integer
head_user_id integer

form_request_employees

timestamps timestamps
id increments
softDeletes softDeletes
code string (3)
division_id integer
position_id integer
date_join_request date
client_id integer
type_request string (30)
location string (191)
location_info string (191)
reason_id integer
project_categorys_id integer
status string (191)
status_notes text
notes text
approval_manager_at timestamp
approval_hr_at timestamp

divisions

id increments
timestamps timestamps
name string (191)
type string (25)
sort_order integer

table_clients

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)

form_request_employees_reason

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
description text

position_rates

id increments
timestamps timestamps
softDeletes softDeletes
position_id integer
basic_sallary decimal (10,2)
daily_cost decimal (10,2)
insentive decimal (10,2)
allowance_phone decimal (10,2)
etc_cost decimal (10,2)

project_categorys

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
description text
group string (25)
parent_id integer
sort_order integer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
email string (191)
email_verified_at timestamp
password string (191)

password_resets

id increments
timestamps timestamps
softDeletes softDeletes
email string (191)
token string (191)
created_at timestamp

failed_jobs

id bigIncrements
timestamps timestamps
softDeletes softDeletes
connection text
queue text
payload longText
exception longText
failed_at timestamp

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