|
s_id
|
int(5)
|
|
|
|
|
reg_number
|
varchar(30)
|
latin1_swedish_ci
|
|
|
|
student_id
|
int(11)
|
|
|
|
|
reg_id
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
full_name
|
varchar(80)
|
latin1_swedish_ci
|
|
|
|
app_no
|
int(10)
|
|
|
|
|
category
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
admitted_category
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
email_old
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
personal_email
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
alt_email
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
program_code
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
religion
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
mobile_alt
|
bigint(10)
|
|
|
|
|
gender
|
varchar(1)
|
latin1_swedish_ci
|
|
|
|
address
|
varchar(256)
|
latin1_swedish_ci
|
|
|
|
pincode
|
int(6)
|
|
|
|
|
city
|
varchar(24)
|
latin1_swedish_ci
|
|
|
|
state
|
varchar(35)
|
latin1_swedish_ci
|
|
|
|
geocode
|
char(5)
|
latin1_swedish_ci
|
|
|
|
ssc_subjects
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
ssc_rollno
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
ssc_board
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
ssc_year
|
year(4)
|
|
|
|
|
ssc_marks
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
hsc_subjects
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
hsc_rollno
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
hsc_board
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
hsc_year
|
year(4)
|
|
|
|
|
hsc_marks
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
degree1
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
degree1_subjects
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
degree1_rollno
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
degree1_board
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
degree1_year
|
year(4)
|
|
|
|
|
degree1_marks
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
degree2
|
varchar(60)
|
latin1_swedish_ci
|
|
|
|
degree2_subjects
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
degree2_rollno
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
degree2_board
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
degree2_year
|
varchar(4)
|
latin1_swedish_ci
|
|
|
|
degree2_marks
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
degree2_college
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
degree2_convocation
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
nationality
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
date_modified
|
timestamp
|
|
|
|
|
aadhar
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
blood_group
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
library_no
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
father_name
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
mother_name
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
father_mobile
|
char(10)
|
latin1_swedish_ci
|
|
|
|
income
|
int(10)
|
|
|
|
|
single_girl
|
char(1)
|
latin1_swedish_ci
|
|
|
|
disability
|
char(1)
|
latin1_swedish_ci
|
|
|
|
joined_year
|
year(4)
|
|
|
|
|
session
|
char(1)
|
latin1_swedish_ci
|
|
|
|
hosteler
|
char(1)
|
latin1_swedish_ci
|
|
|
|
photo
|
varchar(256)
|
latin1_swedish_ci
|
|
|
|
signature
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
voucher
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
old_mobile
|
bigint(10)
|
|
|
|
|
defence
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
native_py
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
entrance_rank
|
int(11)
|
|
|
|
|
entrance_score
|
int(11)
|
|
|
|
|
family_income
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
date_admission
|
datetime
|
|
|
|
|
nodue_hostel
|
tinyint(4)
|
|
|
|
|
hostel_remarks
|
varchar(300)
|
latin1_swedish_ci
|
|
|
|
nodue_library
|
tinyint(4)
|
|
|
|
|
library_remarks
|
varchar(300)
|
latin1_swedish_ci
|
|
|
|
nodue_dept
|
tinyint(4)
|
|
|
|
|
dept_remarks
|
varchar(300)
|
latin1_swedish_ci
|
|
|
|
course_completion
|
int(11)
|
|
|
|
|
readmission
|
tinyint(4)
|
|
|
|
|
consolidated_folio
|
int(11)
|
|
|
|
|
provisional_folio
|
varchar(11)
|
latin1_swedish_ci
|
|
|
|
provisional_issue_date
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
degree_folio
|
int(11)
|
|
|
|
|
phd_type
|
int(11)
|
|
|
|
|
jrf
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
account_holder_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
bank_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
account_number
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
ifsc_code
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
bank_passbook
|
varchar(256)
|
latin1_swedish_ci
|
|
|
|
bank_details_verification
|
tinyint(2)
|
|
|
|
|
hostel_type
|
int(11)
|
|
|
|
