hr - Laravel Schema Designer

users

id increments
name string (191)
first_name string (50)
last_name string (50)
identification string
phone string (191)
email string (50)
password string (255)
balance double (15,2)
notify boolean
online boolean
lang string (4)
status string
lat double
lng double
address string (255)
gender string (20)
birthdate date
social_status string (30)
vacation_count_current_year integer
sick_vacation_count_current_year integer
non_paid_vacation_current_year integer
salary double
currency string
timestamps timestamps

packages

id increments
timestamps timestamps
number_of_users integer

user_settings

id increments
name string (255)
val longText
type char (20)
timestamps timestamps

attend_leaves

id increments
attend_time datetime
leave_time datetime
leave_note text
timestamps timestamps

departments

id increments
name string
timestamps timestamps

positions

id increments
name string
timestamps timestamps

offices

id increments
timestamps timestamps
name string
is_main_office tinyInteger
is_active tinyInteger
lat double
lng double

expenses

id increments
timestamps timestamps
amount double
description text
date datetime

adjustments

id increments
name string
type string
modelable_type string (255)
modelable_id bigInteger
adjustment_type string
amount double
date datetime
note text
timestamps timestamps

employee_requests

id increments
name string
type string
note text
start_at date
end_at date
timestamps timestamps

convenants

id increments
name string
description text
timestamps timestamps

holidays

id increments
timestamps timestamps
name string
start_date datetime
end_date datetime

vacations

id increments
name string
annual_leaves_count integer
sick_count integer
non_paid_count integer
request_before_days integer
timestamps timestamps

shifts

id increments
name string
type string
start_attend_time time
end_attend_time time
start_leave_time time
end_leave_time time
working_hours double
off_days json
timestamps timestamps

delay_segments

id increments
name string
from time
to time
timestamps timestamps

delay_violations

id increments
name string
violation_discount double
timestamps timestamps

areas

id increments
name string
lat double
lng double
timestamps timestamps

user_violations

id increments
violation_amount double
timestamps timestamps

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