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