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)
alert_date date
alert_type enum('Delay', 'Breakdown', 'Emergency', 'Route Deviation', 'Overspeed', 'Student Missing Pickup', 'Student Missing Drop', 'GPS Offline', 'Maintenance Due', 'Document Expiry', 'Other') utf8mb4_unicode_ci
priority enum('Low', 'Medium', 'High', 'Critical') utf8mb4_unicode_ci
route_id int(11)
vehicle_id int(11)
driver_id int(11)
student_id int(11)
trip_session_id int(11)
latitude decimal(10,7)
longitude decimal(10,7)
alert_title varchar(200) utf8mb4_unicode_ci
alert_message text utf8mb4_unicode_ci
alert_status enum('Open', 'In Progress', 'Resolved', 'Closed') utf8mb4_unicode_ci
resolved_by int(11)
resolved_at datetime
resolution_note text utf8mb4_unicode_ci
resolution_notes text utf8mb4_unicode_ci
parent_notified tinyint(1)
admin_notified tinyint(1)
created_by int(11)
updated_by int(11)
delete_status tinyint(1)
created_at datetime
updated_at datetime
Display order: