| id |
int(10)
|
|
|
|
| employee_id |
varchar(80)
|
utf8_general_ci
|
|
|
| employee_code |
varchar(80)
|
utf8_general_ci
|
|
|
| employee_name |
varchar(180)
|
utf8_general_ci
|
|
|
| tanggal |
date
|
|
|
|
| type |
enum('masuk', 'pulang')
|
utf8_general_ci
|
|
|
| check_time |
datetime
|
|
|
|
| latitude |
decimal(12,8)
|
|
|
|
| longitude |
decimal(12,8)
|
|
|
|
| accuracy |
decimal(10,2)
|
|
|
|
| distance_meter |
decimal(12,2)
|
|
|
|
| status |
varchar(40)
|
utf8_general_ci
|
|
|
| note |
varchar(255)
|
utf8_general_ci
|
|
|
| photo_path |
varchar(255)
|
utf8_general_ci
|
|
|
| device_hash |
varchar(80)
|
utf8_general_ci
|
|
|
| ip_address |
varchar(80)
|
utf8_general_ci
|
|
|
| user_agent |
text
|
utf8_general_ci
|
|
|
| created_by |
varchar(120)
|
utf8_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| photo_blob |
mediumblob
|
|
|
|
| photo_mime |
varchar(80)
|
utf8_general_ci
|
|
|
| session |
varchar(20)
|
utf8_general_ci
|
|
|
| early_checkin_minutes |
int(10)
|
|
|
|
| late_minutes |
int(10)
|
|
|
|
| early_leave_minutes |
int(10)
|
|
|
|
