|
id
|
int(11)
|
|
|
|
|
id_emp
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Employee
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Designation
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Salary
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Previous_reserved
|
int(50)
|
|
|
|
|
Worked
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Mis_Count
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Get_Previous
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Annual
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
public_holidays
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Lieu_Avail_In_Month
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Payable_Days
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
cut_days
|
decimal(20,0)
|
|
|
|
|
Now_reserved
|
int(20)
|
|
|
|
|
Total_reserved
|
int(50)
|
|
|
|
|
Bonus
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Earned_Bonus
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
OverTime
|
int(20)
|
|
|
|
|
Advance
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
Payable
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
post_date
|
date
|
|
|
|
|
branch
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
cell
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
bank_transfer_option
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
title_name
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
bank_name
|
varchar(200)
|
utf8mb4_general_ci
|
|
|
|
account_number
|
varchar(200)
|
utf8mb4_general_ci
|
|
|
|
status
|
int(50)
|
|
|
|
