reg_id |
int(10)
|
|
|
|
firstname |
varchar(50)
|
latin1_swedish_ci
|
|
|
lastname |
varchar(50)
|
latin1_swedish_ci
|
|
|
fname |
varchar(50)
|
latin1_swedish_ci
|
|
|
mname |
varchar(50)
|
latin1_swedish_ci
|
|
|
dob |
varchar(15)
|
latin1_swedish_ci
|
|
|
gender |
varchar(8)
|
latin1_swedish_ci
|
|
|
religion |
varchar(20)
|
latin1_swedish_ci
|
|
|
domicile |
varchar(50)
|
latin1_swedish_ci
|
|
|
course |
varchar(10)
|
latin1_swedish_ci
|
|
|
branch |
varchar(30)
|
latin1_swedish_ci
|
|
|
foccupation |
varchar(30)
|
latin1_swedish_ci
|
|
|
fphone |
varchar(15)
|
latin1_swedish_ci
|
|
|
gphone |
varchar(15)
|
latin1_swedish_ci
|
|
|
sphone |
varchar(15)
|
latin1_swedish_ci
|
|
|
pemail |
varchar(30)
|
latin1_swedish_ci
|
|
|
semail |
varchar(30)
|
latin1_swedish_ci
|
|
|
hostel |
varchar(10)
|
latin1_swedish_ci
|
|
|
category |
varchar(10)
|
latin1_swedish_ci
|
|
|
caddress |
varchar(200)
|
latin1_swedish_ci
|
|
|
paddress |
varchar(200)
|
latin1_swedish_ci
|
|
|
adm_mode |
varchar(20)
|
latin1_swedish_ci
|
|
|
rollno |
varchar(15)
|
latin1_swedish_ci
|
|
|
rank |
varchar(10)
|
latin1_swedish_ci
|
|
|
board_x |
varchar(50)
|
latin1_swedish_ci
|
|
|
subjects_x |
varchar(50)
|
latin1_swedish_ci
|
|
|
passed_year_x |
varchar(5)
|
latin1_swedish_ci
|
|
|
marks_x |
int(5)
|
|
|
|
total_x |
int(5)
|
|
|
|
percent_x |
double
|
|
|
|
division_x |
varchar(10)
|
latin1_swedish_ci
|
|
|
board_xii |
varchar(50)
|
latin1_swedish_ci
|
|
|
subjects_xii |
varchar(50)
|
latin1_swedish_ci
|
|
|
passed_year_xii |
int(5)
|
|
|
|
marks_xii |
int(5)
|
|
|
|
total_xii |
int(5)
|
|
|
|
percent_xii |
double
|
|
|
|
division_xii |
varchar(10)
|
latin1_swedish_ci
|
|
|
board_dip |
varchar(50)
|
latin1_swedish_ci
|
|
|
subjects_dip |
varchar(50)
|
latin1_swedish_ci
|
|
|
passed_year_dip |
int(5)
|
|
|
|
marks_dip |
int(5)
|
|
|
|
total_dip |
int(5)
|
|
|
|
percent_dip |
double
|
|
|
|
division_dip |
varchar(10)
|
latin1_swedish_ci
|
|
|
board_grad |
varchar(50)
|
latin1_swedish_ci
|
|
|
subjects_grad |
varchar(50)
|
latin1_swedish_ci
|
|
|
passed_year_grad |
int(5)
|
|
|
|
marks_grad |
int(5)
|
|
|
|
total_grad |
int(5)
|
|
|
|
percent_grad |
double
|
|
|
|
division_grad |
varchar(10)
|
latin1_swedish_ci
|
|
|
intermediate_pcm |
double
|
|
|
|
fannual |
varchar(8)
|
latin1_swedish_ci
|
|
|
transportation |
varchar(10)
|
latin1_swedish_ci
|
|
|
reference |
varchar(50)
|
latin1_swedish_ci
|
|
|
refered_by |
varchar(50)
|
latin1_swedish_ci
|
|
|
submitted_date |
varchar(50)
|
latin1_swedish_ci
|
|
|