| 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)
|
|
|
|
| remedial_title |
varchar(220)
|
utf8mb4_unicode_ci
|
|
|
| remedial_reason |
enum('low_marks', 'attendance_issue', 'concept_gap', 'slow_learner', 'exam_preparation', 'chapter_pending', 'teacher_recommended', 'ai_recommended')
|
utf8mb4_unicode_ci
|
|
|
| student_group_type |
enum('selected_students', 'full_class', 'section_group', 'custom_group')
|
utf8mb4_unicode_ci
|
|
|
| student_ids |
text
|
utf8mb4_unicode_ci
|
|
|
| planned_date |
date
|
|
|
|
| start_time |
time
|
|
|
|
| end_time |
time
|
|
|
|
| topics |
text
|
utf8mb4_unicode_ci
|
|
|
| expected_outcome |
text
|
utf8mb4_unicode_ci
|
|
|
| ai_generated |
tinyint(1)
|
|
|
|
| ai_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| ai_student_risk_summary |
text
|
utf8mb4_unicode_ci
|
|
|
| execution_status |
enum('planned', 'completed', 'cancelled', 'postponed')
|
utf8mb4_unicode_ci
|
|
|
| teacher_feedback |
text
|
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
|
|
|
|