erp_salary - Laravel Schema Designer

salaries

id increments
timestamps timestamps

deducts

id increments
employee_id integer
note text
duration_type enum
duration double
amount double
status enum
deducted_at date
aproved_at date
action_type enum
timestamps timestamps
alter_employee_id integer

bonuses

id increments
timestamps timestamps

permission_requests

id increments
employee_id integer
manager_id integer
date string
note text
permission_number string
manager_status enum
duration integer
hr_status enum
deduct_amount double
manager_action_at timestamp
hr_action_at timestamp
timestamps timestamps

attendance_fingerprints

id increments
timestamps timestamps

vacations

id increments
vacation_type_id ^FK integer
employee_id integer
strat_date date
end_date date
note text
alter_employee_status enum
reject_resone text
vacation_number string
final_status enum
timestamps timestamps
hr_action_at timestamp
manager_action_at timestamp
alter_employee_action_at timestamp

vacation_types

id increments
title string
duration integer
timestamps timestamps
is_relaying boolean

hr_settings

id increments
attend_time time
leave_time time
start_month_date integer
permission_duration integer
timestamps timestamps

vacationa_attachments

id increments
timestamps timestamps
title string
duration integer

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