|
id
|
int(11)
|
|
|
|
|
ref_no
|
varchar(30)
|
|
|
|
|
requester_id
|
int(11)
|
|
|
|
|
request_type
|
enum
|
-- |
|
|
|
for_employee
|
tinyint(1)
|
|
|
1
|
|
for_driver
|
tinyint(1)
|
|
|
0
|
|
driver_instruction
|
text
|
|
|
|
|
needs_vehicle
|
tinyint(1)
|
|
|
0
|
|
travel_date
|
date
|
|
|
|
|
destination
|
varchar(255)
|
|
|
|
|
dest_lat
|
decimal(10,7)
|
|
|
|
|
dest_lng
|
decimal(10,7)
|
|
|
|
|
dest_address
|
varchar(255)
|
|
|
|
|
purpose
|
varchar(255)
|
|
|
|
|
time_from
|
time
|
|
|
|
|
time_to
|
time
|
|
|
|
|
department_id
|
int(11)
|
|
|
|
|
requisitioner_name
|
varchar(150)
|
|
|
|
|
approver_id
|
int(11)
|
|
|
|
|
approver_name
|
varchar(150)
|
|
|
|
|
status
|
enum
|
-- |
|
PENDING
|
|
approver_remarks
|
varchar(255)
|
|
|
|
|
decided_at
|
datetime
|
|
|
|
|
qr_token
|
char(40)
|
|
|
|
|
qr_sent_at
|
datetime
|
|
|
|
|
admin_status
|
enum
|
-- |
|
NOT_REQUIRED
|
|
date_received
|
date
|
|
|
|
|
vehicle_id
|
int(11)
|
|
|
|
|
driver1_id
|
int(11)
|
|
|
|
|
driver2_id
|
int(11)
|
|
|
|
|
driver_sched_departure
|
datetime
|
|
|
|
|
driver_sched_arrival
|
datetime
|
|
|
|
|
arrangement_made_by
|
varchar(150)
|
|
|
|
|
arrangement_approved_by
|
varchar(150)
|
|
|
|
|
admin_remarks
|
varchar(255)
|
|
|
|
|
admin_updated_by
|
int(11)
|
|
|
|
|
admin_updated_at
|
datetime
|
|
|
|
|
guard_status
|
enum
|
-- |
|
WAITING
|
|
time_departure
|
datetime
|
|
|
|
|
km_out
|
decimal(10,1)
|
|
|
|
|
time_arrival
|
datetime
|
|
|
|
|
km_in
|
decimal(10,1)
|
|
|
|
|
guard_id
|
int(11)
|
|
|
|
|
guard_name
|
varchar(150)
|
|
|
|
|
guard_remarks
|
varchar(255)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|