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)
control_no varchar(20) utf8mb4_unicode_ci
requestor_id int(11)
department_id int(11)
nature enum('official', 'personal') utf8mb4_unicode_ci
classification enum('employee', 'driver') utf8mb4_unicode_ci
driver_instruction varchar(255) utf8mb4_unicode_ci
travel_date date
destination varchar(200) utf8mb4_unicode_ci
purpose varchar(255) utf8mb4_unicode_ci
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') utf8mb4_unicode_ci
superior_id int(11)
superior_action_at datetime
superior_remarks varchar(255) utf8mb4_unicode_ci
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) utf8mb4_unicode_ci
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) utf8mb4_unicode_ci
closed_by int(11)
closed_at datetime
created_at datetime
updated_at datetime
Display order: