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(10)
company_id int(10)
branch_id int(10)
academic_year_id int(10)
alert_type enum('pending_syllabus', 'exam_risk', 'holiday_impact', 'teacher_overload', 'low_completion', 'revision_pending', 'remedial_required', 'extra_class_required', 'planner_not_updated', 'approval_pending', 'academic_risk') utf8mb4_unicode_ci
alert_title varchar(220) utf8mb4_unicode_ci
alert_message text utf8mb4_unicode_ci
reference_table varchar(120) utf8mb4_unicode_ci
reference_id int(10)
class_id int(10)
section_id int(10)
subject_id int(10)
teacher_id int(10)
severity enum('info', 'low', 'medium', 'high', 'critical') utf8mb4_unicode_ci
ai_generated tinyint(1)
ai_recommendation text utf8mb4_unicode_ci
action_status enum('open', 'in_review', 'action_taken', 'ignored', 'closed') utf8mb4_unicode_ci
action_taken_by int(10)
action_taken_at datetime
action_note text utf8mb4_unicode_ci
notify_principal tinyint(1)
notify_hod tinyint(1)
notify_teacher tinyint(1)
notify_parent tinyint(1)
notify_student tinyint(1)
notification_status enum('not_sent', 'drafted', 'sent', 'failed') utf8mb4_unicode_ci
delete_status tinyint(1)
created_by int(10)
updated_by int(10)
created_at datetime
updated_at datetime