| user_id |
int(10)
|
|
|
|
| student_code |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| faculty |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| major |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| year_level |
tinyint(3)
|
|
|
|
| advisor_id |
int(10)
|
|
|
|
| name_en |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| national_id |
varchar(17)
|
utf8mb4_general_ci
|
|
|
| birth_date |
date
|
|
|
|
| nationality |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| ethnicity |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| religion |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| personal_email |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| address |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| emergency_name |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| emergency_relation |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| emergency_phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| curriculum_year |
smallint(5)
|
|
|
|
| card_issued |
date
|
|
|
|
| card_expires |
date
|
|
|
|