|
id
|
int(11)
|
|
|
|
|
control_no
|
varchar(20)
|
|
|
|
|
requestor_id
|
int(11)
|
|
|
|
|
department_id
|
int(11)
|
|
|
|
|
nature
|
enum
|
-- |
|
|
|
classification
|
enum
|
-- |
|
employee
|
|
driver_instruction
|
varchar(255)
|
|
|
|
|
travel_date
|
date
|
|
|
|
|
destination
|
varchar(200)
|
|
|
|
|
purpose
|
varchar(255)
|
|
|
|
|
time_from
|
time
|
|
|
|
|
time_to
|
time
|
|
|
|
|
needs_vehicle
|
tinyint(1)
|
|
|
0
|
|
preferred_vehicle_id
|
int(11)
|
|
|
|
|
status
|
enum
|
-- |
|
pending_superior
|
|
superior_id
|
int(11)
|
|
|
|
|
superior_action_at
|
datetime
|
|
|
|
|
superior_remarks
|
varchar(255)
|
|
|
|
|
hr_received_at
|
datetime
|
|
|
|
|
vehicle_id
|
int(11)
|
|
|
|
|
driver_id
|
int(11)
|
|
|
|
|
arranged_by
|
int(11)
|
|
|
|
|
arranged_at
|
datetime
|
|
|
|
|
arrangement_approved_by
|
int(11)
|
|
|
|
|
arrangement_approved_at
|
datetime
|
|
|
|
|
hr_remarks
|
varchar(255)
|
|
|
|
|
departure_time
|
datetime
|
|
|
|
|
km_out
|
int(11)
|
|
|
|
|
guard_out_id
|
int(11)
|
|
|
|
|
arrival_time
|
datetime
|
|
|
|
|
km_in
|
int(11)
|
|
|
|
|
guard_in_id
|
int(11)
|
|
|
|
|
guard_remarks
|
varchar(255)
|
|
|
|
|
closed_by
|
int(11)
|
|
|
|
|
closed_at
|
datetime
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|