| id | bigint(20) unsigned |
|
|
|
| pegawai_id | int(10) unsigned |
|
|
|
| jadwal_kerja_multi_id | bigint(20) unsigned |
|
|
 浏览不相关的值 |
| tanggal_presensi | date |
|
|
|
| jam_masuk | time |
|
|
|
| jam_keluar | time |
|
|
|
| foto_masuk | varchar(255) |
|
|
|
| latitude_masuk | decimal(10,8) |
|
|
|
| longitude_masuk | decimal(11,8) |
|
|
|
| gps_accuracy_masuk | decimal(10,2) |
|
|
|
| alamat_masuk | varchar(255) |
|
|
|
| foto_keluar | varchar(255) |
|
|
|
| latitude_keluar | decimal(10,8) |
|
|
|
| longitude_keluar | decimal(11,8) |
|
|
|
| gps_accuracy_keluar | decimal(10,2) |
|
|
|
| alamat_keluar | varchar(255) |
|
|
|
| is_location_suspicious | tinyint(1) |
|
|
0
|
| device_info | varchar(255) |
|
|
|
| ip_address | varchar(255) |
|
|
|
| status_masuk | tinyint(1) |
|
|
0
|
| status_keluar | tinyint(1) |
|
|
0
|
| status_kehadiran | int(11) |
|
|
1
|
| menit_terlambat | int(11) |
|
|
0
|
| menit_pulang_cepat | int(11) |
|
|
0
|
| total_jam_kerja | decimal(5,2) |
|
|
0.00
|
| is_lembur | tinyint(1) |
|
|
0
|
| jam_lembur | decimal(5,2) |
|
|
0.00
|
| keterangan | text |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
