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)
class_id int(10)
section_id int(10)
subject_id int(10)
teacher_id int(10)
source_module enum('year_planner', 'monthly_planner', 'weekly_planner', 'daily_lesson_planner', 'syllabus_planner', 'teacher_wise_planner', 'class_wise_planner', 'revision_remedial_planner', 'exam_preparation_planner', 'manual_review') utf8mb4_unicode_ci
source_record_id int(10)
gap_title varchar(220) utf8mb4_unicode_ci
gap_category enum('syllabus_delay', 'low_completion', 'teacher_workload', 'class_readiness', 'exam_readiness', 'learning_gap', 'approval_delay', 'attendance_impact', 'manual_gap') utf8mb4_unicode_ci
gap_description text utf8mb4_unicode_ci
detected_date date
target_completion_date date
severity_level enum('low', 'medium', 'high', 'critical') utf8mb4_unicode_ci
priority_score decimal(6,2)
impact_area enum('student', 'teacher', 'class', 'subject', 'exam', 'management') utf8mb4_unicode_ci
current_value decimal(8,2)
expected_value decimal(8,2)
gap_value decimal(8,2)
suggested_action text utf8mb4_unicode_ci
auto_action_type enum('create_revision_plan', 'create_remedial_plan', 'create_extra_class', 'notify_teacher', 'notify_hod', 'escalate_approval', 'monitor_only') utf8mb4_unicode_ci
suggested_owner_role varchar(80) utf8mb4_unicode_ci
suggested_owner_id int(10)
ai_confidence_score decimal(6,2)
ai_reasoning_note text utf8mb4_unicode_ci
ai_recommendation text utf8mb4_unicode_ci
action_status enum('open', 'accepted', 'in_progress', 'completed', 'ignored', 'escalated') utf8mb4_unicode_ci
action_taken_note text utf8mb4_unicode_ci
action_taken_at datetime
approval_status enum('draft', 'submitted', 'approved', 'rejected', 'locked') utf8mb4_unicode_ci
status enum('active', 'inactive') utf8mb4_unicode_ci
delete_status tinyint(1)
created_by int(10)
updated_by int(10)
created_at datetime
updated_at datetime