
id : int(11)
|

control_no : varchar(20)
|

requestor_id : int(11)
|

department_id : int(11)
|

nature : enum('official','personal')
|

classification : enum('employee','driver')
|

driver_instruction : varchar(255)
|

travel_date : date
|

destination : varchar(200)
|

purpose : varchar(255)
|

time_from : time
|

time_to : time
|

needs_vehicle : tinyint(1)
|

preferred_vehicle_id : int(11)
|

status : enum('pending_superior','pending_hr','pending_arrangement','approved','departed','returned','closed','rejected','cancelled','expired')
|

superior_id : int(11)
|

superior_action_at : datetime
|

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
|

departure_time : datetime
|

km_out : int(11)
|

guard_out_id : int(11)
|

arrival_time : datetime
|

km_in : int(11)
|

guard_in_id : int(11)
|

closed_by : int(11)
|

closed_at : datetime
|

created_at : datetime
|

updated_at : datetime
|