| id |
int(11)
|
|
|
|
| course_code |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| course_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| course_name_en |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| credits |
int(11)
|
|
|
|
| theory_hours |
int(11)
|
|
|
|
| practical_hours |
int(11)
|
|
|
|
| level |
int(11)
|
|
|
|
| semester |
enum('الفصل الأول', 'الفصل الثاني', 'الفصل الصيفي')
|
utf8mb4_general_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| prerequisite_course_id |
int(11)
|
|
|
|
| max_students |
int(11)
|
|
|
|
| is_elective |
tinyint(1)
|
|
|
|
| course_type |
enum('إجباري', 'اختياري', 'متطلب جامعة')
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
