| id |
int(11)
|
|
|
|
| course_code |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| name_ar |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| name_en |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| faculty_id |
int(11)
|
|
|
|
| academic_dept_id |
int(11)
|
|
|
|
| year_level |
enum('1', '2', '3', '4', '5', '6', 'all')
|
utf8mb4_unicode_ci
|
|
|
| credit_hours |
int(11)
|
|
|
|
| theory_hours |
int(11)
|
|
|
|
| practical_hours |
int(11)
|
|
|
|
| level |
tinyint(4)
|
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
