| request_id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| teacher_id |
int(11)
|
|
|
|
| request_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| template_id |
int(11)
|
|
|
|
| syllabus_name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| class_name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| subject_id |
int(11)
|
|
|
|
| subject_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| lesson_id |
int(11)
|
|
|
|
| topic_ids |
text
|
utf8mb4_unicode_ci
|
|
|
| requested_title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| requested_description |
text
|
utf8mb4_unicode_ci
|
|
|
| homework_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| reason |
text
|
utf8mb4_unicode_ci
|
|
|
| approval_status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| admin_remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
int(11)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|