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