| id |
int(11)
|
|
|
|
| staff_id |
int(11)
|
|
|
|
| course_id |
int(11)
|
|
|
|
| semester_id |
int(11)
|
|
|
|
| section_name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| section_id |
int(11)
|
|
|
|
| group_type |
enum('regular', 'shared', 'visiting')
|
utf8mb4_unicode_ci
|
|
|
| shared_depts |
text
|
utf8mb4_unicode_ci
|
|
|
| space_preference |
int(11)
|
|
|
|
| student_count |
int(11)
|
|
|
|
| teaching_type |
enum('theory', 'practical', 'both')
|
utf8mb4_unicode_ci
|
|
|
| weekly_theory_hours |
decimal(4,1)
|
|
|
|
| weekly_practical_hours |
decimal(4,1)
|
|
|
|
| is_extra |
tinyint(1)
|
|
|
|
| notes |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|