Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
ref_no varchar(30) utf8mb4_unicode_ci
requester_id int(11)
request_type enum('OB', 'PERSONAL') utf8mb4_unicode_ci
for_employee tinyint(1)
for_driver tinyint(1)
driver_instruction text utf8mb4_unicode_ci
needs_vehicle tinyint(1)
travel_date date
destination varchar(255) utf8mb4_unicode_ci
dest_lat decimal(10,7)
dest_lng decimal(10,7)
dest_address varchar(255) utf8mb4_unicode_ci
purpose varchar(255) utf8mb4_unicode_ci
time_from time
time_to time
department_id int(11)
requisitioner_name varchar(150) utf8mb4_unicode_ci
approver_id int(11)
approver_name varchar(150) utf8mb4_unicode_ci
status enum('PENDING', 'APPROVED', 'DECLINED', 'CANCELLED') utf8mb4_unicode_ci
approver_remarks varchar(255) utf8mb4_unicode_ci
decided_at datetime
qr_token char(40) utf8mb4_unicode_ci
qr_sent_at datetime
admin_status enum('NOT_REQUIRED', 'PENDING', 'ARRANGED', 'NO_DRIVER') utf8mb4_unicode_ci
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) utf8mb4_unicode_ci
arrangement_approved_by varchar(150) utf8mb4_unicode_ci
admin_remarks varchar(255) utf8mb4_unicode_ci
admin_updated_by int(11)
admin_updated_at datetime
guard_status enum('WAITING', 'OUT', 'RETURNED') utf8mb4_unicode_ci
time_departure datetime
km_out decimal(10,1)
time_arrival datetime
km_in decimal(10,1)
guard_id int(11)
guard_name varchar(150) utf8mb4_unicode_ci
guard_remarks varchar(255) utf8mb4_unicode_ci
created_at datetime
updated_at datetime
Display order: