| id |
int(11)
|
|
|
|
| student_id |
int(11)
|
|
|
|
| course_id |
int(11)
|
|
|
|
| academic_year |
int(11)
|
|
|
|
| semester |
enum('الفصل الأول', 'الفصل الثاني', 'الفصل الصيفي')
|
utf8mb4_general_ci
|
|
|
| midterm_exam |
decimal(5,2)
|
|
|
|
| final_exam |
decimal(5,2)
|
|
|
|
| practical_exam |
decimal(5,2)
|
|
|
|
| assignments |
decimal(5,2)
|
|
|
|
| projects |
decimal(5,2)
|
|
|
|
| participation |
decimal(5,2)
|
|
|
|
| quizzes |
decimal(5,2)
|
|
|
|
| total_grade |
decimal(5,2)
|
|
|
|
| grade_point |
decimal(3,2)
|
|
|
|
| letter_grade |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| status |
enum('مسجل', 'معتمد', 'معاد', 'غير مكتمل')
|
utf8mb4_general_ci
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| recorded_by |
int(11)
|
|
|
|
| recorded_at |
timestamp
|
|
|
|
| approved_by |
int(11)
|
|
|
|
| approval_date |
timestamp
|
|
|
|