| id |
bigint(20)
|
|
|
|
| pegawai_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| jenis_lembur |
enum('terjadwal', 'emergency')
|
utf8mb4_unicode_ci
|
|
|
| tanggal_lembur |
date
|
|
|
|
| jam_mulai |
time
|
|
|
|
| jam_selesai |
time
|
|
|
|
| jam_masuk_real |
datetime
|
|
|
|
| jam_keluar_real |
datetime
|
|
|
|
| total_jam |
decimal(6,2)
|
|
|
|
| alasan_lembur |
text
|
utf8mb4_unicode_ci
|
|
|
| kegiatan_lembur |
text
|
utf8mb4_unicode_ci
|
|
|
| bukti_lembur |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| foto_masuk |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| foto_keluar |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| lokasi_lembur |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| latitude_masuk |
decimal(10,8)
|
|
|
|
| longitude_masuk |
decimal(11,8)
|
|
|
|
| latitude_keluar |
decimal(10,8)
|
|
|
|
| longitude_keluar |
decimal(11,8)
|
|
|
|
| alamat_masuk |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| alamat_keluar |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| status_pengajuan |
int(11)
|
|
|
|
| level_approval |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| catatan_approval |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
