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)
company_id int(11)
branch_id int(11)
route_code varchar(50) utf8mb4_unicode_ci
route_name varchar(150) utf8mb4_unicode_ci
route_direction enum('Morning', 'Evening', 'Both') utf8mb4_unicode_ci
start_point varchar(200) utf8mb4_unicode_ci
end_point varchar(200) utf8mb4_unicode_ci
total_distance_km decimal(10,2)
estimated_duration_min int(11)
vehicle_id int(11)
driver_id int(11)
helper_id int(11)
morning_start_time time
morning_end_time time
evening_start_time time
evening_end_time time
route_status enum('Active', 'Inactive', 'Temporary Closed') utf8mb4_unicode_ci
remarks text utf8mb4_unicode_ci
created_by int(11)
updated_by int(11)
delete_status tinyint(1)
created_at datetime
updated_at datetime
Display order: