| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| teacher_id |
int(11)
|
|
|
|
| template_id |
int(11)
|
|
|
|
| class_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| section_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| subject_id |
int(11)
|
|
|
|
| subject_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| lesson_id |
int(11)
|
|
|
|
| completion_scope |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| covered_topics_text |
text
|
utf8mb4_unicode_ci
|
|
|
| parent_display_note |
text
|
utf8mb4_unicode_ci
|
|
|
| homework_title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| homework_description |
text
|
utf8mb4_unicode_ci
|
|
|
| homework_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| due_date |
date
|
|
|
|
| assigned_students_count |
int(11)
|
|
|
|
| notify_parents |
tinyint(1)
|
|
|
|
| allow_parent_reply |
tinyint(1)
|
|
|
|
| status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|