| uuid |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| att_date |
date
|
|
|
|
| weekday |
smallint(6)
|
|
|
|
| check_in |
datetime(6)
|
|
|
|
| check_out |
datetime(6)
|
|
|
|
| duration |
int(11)
|
|
|
|
| duty_duration |
int(11)
|
|
|
|
| work_day |
double
|
|
|
|
| clock_in |
datetime(6)
|
|
|
|
| clock_out |
datetime(6)
|
|
|
|
| total_time |
int(11)
|
|
|
|
| duty_worked |
int(11)
|
|
|
|
| actual_worked |
int(11)
|
|
|
|
| unscheduled |
int(11)
|
|
|
|
| remaining |
int(11)
|
|
|
|
| total_worked |
int(11)
|
|
|
|
| late |
int(11)
|
|
|
|
| early_leave |
int(11)
|
|
|
|
| short |
int(11)
|
|
|
|
| absent |
int(11)
|
|
|
|
| leave |
int(11)
|
|
|
|
| exception |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| day_off |
smallint(6)
|
|
|
|
| break_time_id |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| emp_id |
int(11)
|
|
|
Browse foreign values
|
| overtime_id |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| timetable_id |
int(11)
|
|
|
Browse foreign values
|