|
id
|
int(11)
|
|
|
|
|
employee_id
|
int(11)
|
|
|
|
|
ot_date
|
date
|
|
|
|
|
start_time
|
datetime
|
|
|
2026-07-26 13:59:27.000000
|
|
end_time
|
datetime
|
|
|
2026-07-26 13:59:27.000000
|
|
reason
|
text
|
|
|
|
|
attachment
|
varchar(255)
|
|
|
|
|
requested_hours
|
decimal(10,2)
|
|
|
0.00
|
|
approved_hours
|
decimal(10,2)
|
|
|
0.00
|
|
payable_hours
|
decimal(10,2)
|
|
|
0.00
|
|
is_pre_shift
|
tinyint(1)
|
|
|
0
|
|
status
|
enum
|
-- |
|
pending
|
|
supervisor_by
|
int(11)
|
|
|
|
|
supervisor_at
|
datetime
|
|
|
|
|
approved_by
|
int(11)
|
|
|
|
|
approved_at
|
datetime
|
|
|
|
|
remarks
|
text
|
|
|
|
|
created_by
|
int(11)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|