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