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)
hostel_id int(11)
student_id int(11)
alert_type enum('Attendance', 'Overdue Return', 'Visitor', 'Complaint', 'Fee Due', 'Medical', 'Security', 'General') utf8mb4_unicode_ci
reference_id int(11)
alert_title varchar(200) utf8mb4_unicode_ci
alert_message text utf8mb4_unicode_ci
alert_priority enum('Low', 'Medium', 'High', 'Critical') utf8mb4_unicode_ci
alert_status enum('New', 'Seen', 'Actioned', 'Closed') utf8mb4_unicode_ci
notify_parent tinyint(1)
notify_warden tinyint(1)
notify_admin tinyint(1)
action_by int(11)
action_note text utf8mb4_unicode_ci
delete_status tinyint(1)
created_by int(11)
updated_by int(11)
created_at datetime
updated_at datetime