id
|
int(11)
|
|
|
|
reg_id
|
varchar(10)
|
utf8_general_ci
|
|
|
app_no
|
int(6)
|
|
|
|
name
|
varchar(35)
|
utf8_general_ci
|
|
|
gender
|
varchar(1)
|
utf8_general_ci
|
|
|
father_name
|
varchar(34)
|
utf8_general_ci
|
|
|
mother_name
|
varchar(39)
|
utf8_general_ci
|
|
|
program_type
|
varchar(10)
|
utf8_general_ci
|
|
|
course_code
|
int(3)
|
|
|
|
dob
|
varchar(10)
|
utf8_general_ci
|
|
|
religion
|
varchar(9)
|
utf8_general_ci
|
|
|
category
|
varchar(12)
|
utf8_general_ci
|
|
|
disability
|
varchar(3)
|
utf8_general_ci
|
|
|
mobile
|
bigint(10)
|
|
|
|
address1
|
varchar(70)
|
utf8_general_ci
|
|
|
address2
|
varchar(21)
|
utf8_general_ci
|
|
|
address3
|
varchar(14)
|
utf8_general_ci
|
|
|
pincode
|
int(7)
|
|
|
|
city
|
varchar(24)
|
utf8_general_ci
|
|
|
state
|
varchar(17)
|
utf8_general_ci
|
|
|
ssc_subjects
|
varchar(64)
|
utf8_general_ci
|
|
|
ssc_rollno
|
varchar(19)
|
utf8_general_ci
|
|
|
ssc_board
|
varchar(50)
|
utf8_general_ci
|
|
|
ssc_year
|
varchar(4)
|
utf8_general_ci
|
|
|
ssc_marks
|
varchar(5)
|
utf8_general_ci
|
|
|
hsc_subjects
|
varchar(61)
|
utf8_general_ci
|
|
|
hsc_rollno
|
varchar(16)
|
utf8_general_ci
|
|
|
hsc_board
|
varchar(50)
|
utf8_general_ci
|
|
|
hsc_year
|
varchar(4)
|
utf8_general_ci
|
|
|
hsc_marks
|
varchar(4)
|
utf8_general_ci
|
|
|
degree1
|
varchar(42)
|
utf8_general_ci
|
|
|
degree1_subjects
|
varchar(60)
|
utf8_general_ci
|
|
|
degree1_rollno
|
varchar(16)
|
utf8_general_ci
|
|
|
degree1_board
|
varchar(50)
|
utf8_general_ci
|
|
|
degree1_year
|
varchar(4)
|
utf8_general_ci
|
|
|
degree1_marks
|
varchar(4)
|
utf8_general_ci
|
|
|
degree2
|
varchar(10)
|
utf8_general_ci
|
|
|
degree2_subjects
|
varchar(10)
|
utf8_general_ci
|
|
|
degree2_rollno
|
varchar(10)
|
utf8_general_ci
|
|
|
degree2_board
|
varchar(10)
|
utf8_general_ci
|
|
|
degree2_year
|
varchar(10)
|
utf8_general_ci
|
|
|
degree2_marks
|
varchar(10)
|
utf8_general_ci
|
|
|
nationality
|
varchar(10)
|
utf8_general_ci
|
|
|
program_id
|
int(11)
|
|
|
|
dept_id
|
varchar(10)
|
utf8_general_ci
|
|
|
school_id
|
varchar(10)
|
utf8_general_ci
|
|
|
entrance_rank
|
varchar(10)
|
utf8_general_ci
|
|
|
entrance_score
|
varchar(10)
|
utf8_general_ci
|
|
|
single_girl
|
varchar(3)
|
utf8_general_ci
|
|
|
program_name
|
varchar(51)
|
utf8_general_ci
|
|
|
admitted_category
|
varchar(19)
|
utf8_general_ci
|
|
|
hosteler
|
varchar(3)
|
utf8_general_ci
|
|
|