| id |
int(11)
|
|
|
|
| student_code |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| full_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| full_name_en |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| national_id |
varchar(14)
|
utf8mb4_general_ci
|
|
|
| faculty_id |
int(11)
|
|
|
|
| dept_id |
int(11)
|
|
|
|
| academic_year_id |
int(11)
|
|
|
|
| section_id |
int(11)
|
|
|
|
| gender |
enum('male', 'female')
|
utf8mb4_general_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| enrollment_year |
year(4)
|
|
|
|
| gpa |
decimal(4,2)
|
|
|
|
| photo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| status |
enum('active', 'suspended', 'graduated', 'transferred', 'withdrawn')
|
utf8mb4_general_ci
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
