| id |
int(11)
|
|
|
|
| payroll_month |
char(7)
|
utf8mb4_general_ci
|
|
|
| employee_id |
int(11)
|
|
|
|
| base_salary |
decimal(12,2)
|
|
|
|
| meal_allowance |
decimal(12,2)
|
|
|
|
| total_salary |
decimal(12,2)
|
|
|
|
| work_days |
decimal(6,2)
|
|
|
|
| is_full_month |
tinyint(1)
|
|
|
|
| calc_start_date |
date
|
|
|
|
| calc_end_date |
date
|
|
|
|
| payable_salary |
decimal(12,2)
|
|
|
|
| labor_insured_amount |
decimal(12,2)
|
|
|
|
| health_insured_amount |
decimal(12,2)
|
|
|
|
| overtime_133_hours |
decimal(8,2)
|
|
|
|
| overtime_166_hours |
decimal(8,2)
|
|
|
|
| overtime_200_hours |
decimal(8,2)
|
|
|
|
| overtime_267_hours |
decimal(8,2)
|
|
|
|
| overtime_pay |
decimal(12,2)
|
|
|
|
| paid_leave_hours |
decimal(8,2)
|
|
|
|
| personal_leave_hours |
decimal(8,2)
|
|
|
|
| sick_leave_half_hours |
decimal(8,2)
|
|
|
|
| personal_leave_deduction |
decimal(12,2)
|
|
|
|
| sick_leave_deduction |
decimal(12,2)
|
|
|
|
| labor_insurance_mode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| health_insurance_mode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| labor_deduction |
decimal(12,2)
|
|
|
|
| health_dependents |
int(11)
|
|
|
|
| health_deduction |
decimal(12,2)
|
|
|
|
| net_salary |
decimal(12,2)
|
|
|
|
| note |
text
|
utf8mb4_general_ci
|
|
|
| status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| created_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
