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)
exam_name varchar(180) utf8mb4_unicode_ci
exam_type enum('unit_test', 'monthly_test', 'mid_term', 'pre_final', 'final_exam', 'board_exam', 'practice_exam') utf8mb4_unicode_ci
preparation_title varchar(220) utf8mb4_unicode_ci
preparation_start_date date
preparation_end_date date
exam_date date
syllabus_covered_percentage decimal(5,2)
revision_completed_percentage decimal(5,2)
question_bank_completed_percentage decimal(5,2)
mock_test_completed_count int(10)
important_chapters text utf8mb4_unicode_ci
weak_chapters text utf8mb4_unicode_ci
revision_strategy text utf8mb4_unicode_ci
practice_plan text utf8mb4_unicode_ci
target_average_score decimal(5,2)
current_average_score decimal(5,2)
expected_average_score decimal(5,2)
readiness_score decimal(6,2)
risk_level enum('low', 'medium', 'high', 'critical') utf8mb4_unicode_ci
planner_status enum('not_started', 'in_progress', 'ready', 'attention_needed', 'critical') utf8mb4_unicode_ci
ai_generated tinyint(1)
ai_exam_summary text utf8mb4_unicode_ci
ai_gap_note text utf8mb4_unicode_ci
ai_recommendation text utf8mb4_unicode_ci
ai_priority_score decimal(6,2)
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