cloudbiz-roster - Laravel Schema Designer

users

id increments
name string
password string
timestamps timestamps

employee

id increments
name string
id_number string
hire_date date
id_position ^FK integer
id_companies ^FK integer
id_schedule ^FK integer
id_modality ^FK integer
id_currency ^FK integer
timestamps timestamps

rol

id increments
timestamps timestamps
name string

users_has_rol

id increments
timestamps timestamps
id_user ^FK integer
id_rol ^FK integer

companies

id increments
name string
timestamps timestamps
rtn string
address string
id_users ^FK integer

actions_rols

id increments
timestamps timestamps
name string

rol_has_actions

id increments
timestamps timestamps
id_rol ^FK integer
id_actions ^FK integer

schedule

id increments
name string
id_companies ^FK integer
timestamps timestamps

modality

id increments
timestamps timestamps
name string
id_companies ^FK integer

currency

id increments
name string
timestamps timestamps
id_companies ^FK integer

deductions

id increments
name string
id_companies ^FK integer
type string
range_from integer
range_to integer
value integer
percentage integer
timestamps timestamps

bonus

id increments
name string
id_companies ^FK integer
type string
range_from integer
range_to integer
value integer
percentage integer
timestamps timestamps

position

id increments
name string
id_companies ^FK integer
timestamps timestamps

department

id increments
timestamps timestamps
name string
id_companies ^FK integer

settings

id increments
name string
range_from integer
range_to integer
porcentage integer
value integer
timestamps timestamps

payroll

id increments
date_from date
date_to date
id_modality ^FK integer
id_companies ^FK integer
timestamps timestamps

details_employees

id increments
id_employee ^FK integer
salary double
days integer
deductions_total double
bonus_total double
IHSS double
RAP double
IRS double
net_salary double
timestamps timestamps
twentyfive integer
fifty integer
seventyfive integer
hundred integer

payroll_has_details_employees

id increments
id_payroll ^FK integer
id_details_employees ^FK integer
timestamps timestamps

details_totals

id increments
salary double
deductions double
bonus double
IHSS double
RAP double
IRS double
net_salary double
timestamps timestamps

payroll_has_details_totals

id increments
id_payroll ^FK integer
id_details_totals ^FK integer
timestamps timestamps

details_bonus

id increments
name string
value double
timestamps timestamps

employees_bonus

id increments
id_details_employees ^FK integer
id_details_bonus ^FK integer
timestamps timestamps

details_deductions

id increments
timestamps timestamps
name string
value double

employee_deductions

id increments
timestamps timestamps
id_details_employee ^FK integer
id_details_deductions ^FK integer

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