id | int(11) |
|
|
0
|
reg_id | varchar(15) |
|
|
|
app_no | varchar(10) |
|
|
|
name | varchar(58) |
|
|
|
dob | date |
|
|
|
mobile | char(10) |
|
|
|
email | tinytext |
|
|
|
category | varchar(20) |
|
|
|
disability | varchar(50) |
|
|
|
nop | varchar(3) |
|
|
|
nok | varchar(3) |
|
|
|
type | varchar(18) |
|
|
|
program | varchar(81) |
|
|
|
program_id | int(11) |
|
|
0
|
program_code | int(3) |
|
|
|
program_type | tinyint(4) |
|
|
1
|
dept_id | varchar(3) |
|
|
|
school_id | varchar(3) |
|
|
|
year_joined | int(4) |
|
|
|
role | tinyint(4) |
|
|
5
|
entry_type | varchar(10) |
|
|
1
|
phd_type | varchar(10) |
|
|
|
rank | int(5) |
|
|
|
score | int(5) |
|
|
|
interview_score | varchar(5) |
|
|
0
|
total_score | varchar(5) |
|
|
0
|
date_admission | datetime |
|
|
|
entrance_score_converted | varchar(5) |
|
|
0
|
status | varchar(3) |
|
|
0
|
remarks | varchar(255) |
|
|
|
date_modified | datetime |
|
|
CURRENT_TIMESTAMP
|