| hw_id |
int(11)
|
|
|
|
| homework_type |
varchar(50)
|
latin1_swedish_ci
|
|
|
| attachment |
text
|
latin1_swedish_ci
|
|
|
| homework_content |
text
|
latin1_swedish_ci
|
|
|
| date_of_home_work |
date
|
|
|
|
| due_date |
date
|
|
|
|
| location_id |
int(11)
|
|
|
|
| subject_id |
int(11)
|
|
|
|
| course_id |
int(11)
|
|
|
|
| course_name |
varchar(50)
|
latin1_swedish_ci
|
|
|
| section_id |
int(11)
|
|
|
|
| section_name |
varchar(50)
|
latin1_swedish_ci
|
|
|
| chapter_id |
varchar(50)
|
latin1_swedish_ci
|
|
|
| publish_status |
tinyint(4)
|
|
|
|
| published_by |
int(11)
|
|
|
|
| published_at |
datetime
|
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| publish_by |
int(11)
|
|
|
|
| publish_teacher |
varchar(100)
|
latin1_swedish_ci
|
|
|
| verified_by |
int(11)
|
|
|
|
| verify_status |
tinyint(4)
|
|
|
|
| veryfied_date |
date
|
|
|
|
| yr_id |
int(11)
|
|
|
|
| added_by |
varchar(50)
|
latin1_swedish_ci
|
|
|
| added_at |
timestamp
|
|
|
|
| modified_by |
int(11)
|
|
|
|
| modified_at |
datetime
|
|
|
|
| delete_status |
tinyint(4)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| teacher_id |
int(11)
|
|
|
|
| teacher_name |
varchar(150)
|
latin1_swedish_ci
|
|
|