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)
year_planner_id int(10)
monthly_planner_id int(10)
weekly_planner_id int(10)
syllabus_planner_id int(10)
lesson_date date
period_no int(10)
lesson_title varchar(220) utf8mb4_unicode_ci
lesson_objective text utf8mb4_unicode_ci
teaching_method varchar(160) utf8mb4_unicode_ci
teaching_aid text utf8mb4_unicode_ci
planned_content text utf8mb4_unicode_ci
actual_content text utf8mb4_unicode_ci
homework_given text utf8mb4_unicode_ci
assignment_given text utf8mb4_unicode_ci
execution_status enum('planned', 'completed', 'partially_completed', 'not_taken', 'substituted', 'postponed', 'cancelled') utf8mb4_unicode_ci
completion_percentage decimal(5,2)
teacher_execution_note text utf8mb4_unicode_ci
student_response_note text utf8mb4_unicode_ci
ai_generated tinyint(1)
ai_lesson_summary text utf8mb4_unicode_ci
ai_followup_suggestion 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