| 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)
|
|
|
|
| assignment_title |
varchar(220)
|
utf8mb4_unicode_ci
|
|
|
| assignment_type |
enum('homework', 'classwork', 'project', 'worksheet', 'revision_test', 'practice_set')
|
utf8mb4_unicode_ci
|
|
|
| assigned_date |
date
|
|
|
|
| due_date |
date
|
|
|
|
| instructions |
text
|
utf8mb4_unicode_ci
|
|
|
| expected_outcome |
text
|
utf8mb4_unicode_ci
|
|
|
| submission_required |
tinyint(1)
|
|
|
|
| ai_generated |
tinyint(1)
|
|
|
|
| ai_assignment_note |
text
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('planned', 'assigned', 'completed', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|