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)
syllabus_planner_id int(10)
daily_lesson_id int(10)
plan_type enum('revision', 'remedial', 'extra_class', 'bridge_course', 'practice_test', 'doubt_clearing') utf8mb4_unicode_ci
plan_title varchar(220) utf8mb4_unicode_ci
target_group enum('whole_class', 'slow_learners', 'absentees', 'high_achievers', 'selected_students') utf8mb4_unicode_ci
target_student_count int(10)
planned_date date
start_time time
end_time time
planned_periods int(10)
topic_area varchar(220) utf8mb4_unicode_ci
learning_gap text utf8mb4_unicode_ci
planned_activity text utf8mb4_unicode_ci
assessment_method varchar(180) utf8mb4_unicode_ci
completion_status enum('planned', 'in_progress', 'completed', 'postponed', 'cancelled') utf8mb4_unicode_ci
completion_percentage decimal(5,2)
pre_assessment_score decimal(5,2)
post_assessment_score decimal(5,2)
improvement_percentage decimal(5,2)
ai_generated tinyint(1)
ai_gap_analysis text utf8mb4_unicode_ci
ai_recommendation text utf8mb4_unicode_ci
ai_priority_score decimal(6,2)
ai_risk_level enum('low', 'medium', 'high', 'critical') utf8mb4_unicode_ci
teacher_remarks text utf8mb4_unicode_ci
hod_remarks text utf8mb4_unicode_ci
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