id |
int(5) |
|
|
|
|
site |
varchar(10) |
latin1_swedish_ci |
|
|
|
e_code |
varchar(30) |
latin1_swedish_ci |
|
|
|
card_no |
int(40) |
|
|
|
|
employee |
int(10) |
|
|
|
|
shift_category |
varchar(40) |
latin1_swedish_ci |
|
|
|
shift_start |
time |
|
|
|
|
shiftstart_AMPM |
varchar(5) |
latin1_swedish_ci |
|
|
|
shift_end |
time |
|
|
|
|
shiftend_AMPM |
varchar(5) |
latin1_swedish_ci |
|
|
|
time_in |
varchar(10) |
latin1_swedish_ci |
|
|
|
timein_AMPM |
varchar(5) |
latin1_swedish_ci |
|
|
|
time_out |
time |
|
|
|
|
timeout_AMPM |
varchar(5) |
latin1_swedish_ci |
|
|
|
late_arrival |
time |
|
|
|
|
office_hours |
time |
|
|
|
|
work_hrs |
time |
|
|
|
|
ot_hrs |
time |
|
|
|
|
leave_code |
varchar(20) |
latin1_swedish_ci |
|
|
|
out_date |
date |
|
|
|
|
attendance_date |
date |
|
|
|
|
created_date |
date |
|
|
|
|
attendance_day |
varchar(5) |
latin1_swedish_ci |
|
|
|
attendance_month |
varchar(5) |
latin1_swedish_ci |
|
|
|
attendance_year |
varchar(5) |
latin1_swedish_ci |
|
|
|
pres_abs |
varchar(50) |
latin1_swedish_ci |
|
|
|
others |
text |
latin1_swedish_ci |
|
|
|
created_by |
varchar(10) |
latin1_swedish_ci |
|
|
|
modified_date |
date |
|
|
|
|
companyId |
int(11) |
|
|
|
|
biometric_emp_id |
int(11) |
|
|
|
|