|
id
|
int(11)
|
|
|
|
|
RegistrationId
|
varchar(15)
|
utf8_general_ci
|
|
|
|
active
|
int(1)
|
|
|
|
|
ApplicationNo
|
int(2)
|
|
|
|
|
EmailId
|
varchar(150)
|
utf8_general_ci
|
|
|
|
CandidateName
|
varchar(150)
|
utf8_general_ci
|
|
|
|
FatherName
|
varchar(150)
|
utf8_general_ci
|
|
|
|
MotherName
|
varchar(150)
|
utf8_general_ci
|
|
|
|
Applications_Course
|
varchar(150)
|
utf8_general_ci
|
|
|
|
CourseCode
|
int(3)
|
|
|
|
|
DateofBirth
|
date
|
|
|
|
|
Religion
|
varchar(5)
|
utf8_general_ci
|
|
|
|
Category
|
varchar(4)
|
utf8_general_ci
|
|
|
|
PhysicalDisability
|
varchar(20)
|
utf8_general_ci
|
|
|
|
MobileNo
|
bigint(10)
|
|
|
|
|
Gender
|
varchar(1)
|
utf8_general_ci
|
|
|
|
AddressLine1
|
varchar(150)
|
utf8_general_ci
|
|
|
|
AddressLine2
|
varchar(150)
|
utf8_general_ci
|
|
|
|
AddressLine3
|
varchar(150)
|
utf8_general_ci
|
|
|
|
PinCode
|
int(6)
|
|
|
|
|
City
|
varchar(50)
|
utf8_general_ci
|
|
|
|
LandlineNo
|
varchar(10)
|
utf8_general_ci
|
|
|
|
StateName
|
varchar(50)
|
utf8_general_ci
|
|
|
|
BelongstoDefence
|
varchar(2)
|
utf8_general_ci
|
|
|
|
nativeofPuducherry
|
varchar(3)
|
utf8_general_ci
|
|
|
|
NativePlace
|
varchar(2)
|
utf8_general_ci
|
|
|
|
DomicileOFJammuNKashmir
|
varchar(10)
|
utf8_general_ci
|
|
|
|
SSC
|
int(2)
|
|
|
|
|
SSCSubjects
|
varchar(150)
|
utf8_general_ci
|
|
|
|
SSCRollNo
|
int(7)
|
|
|
|
|
SSCDuration
|
int(2)
|
|
|
|
|
SSCBoard
|
varchar(100)
|
utf8_general_ci
|
|
|
|
SSCCompleteYear
|
int(4)
|
|
|
|
|
SSCMarks
|
int(2)
|
|
|
|
|
sscpassed
|
varchar(20)
|
utf8_general_ci
|
|
|
|
HSC
|
varchar(20)
|
utf8_general_ci
|
|
|
|
HSCSubjects
|
varchar(100)
|
utf8_general_ci
|
|
|
|
HSCRollNo
|
int(7)
|
|
|
|
|
HSCDuration
|
int(1)
|
|
|
|
|
HSCBoard
|
varchar(150)
|
utf8_general_ci
|
|
|
|
HSCCompleteYear
|
int(4)
|
|
|
|
|
HSCMarks
|
int(2)
|
|
|
|
|
hscpassedornot
|
varchar(20)
|
utf8_general_ci
|
|
|
|
Degree1
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree1Subjects
|
varchar(150)
|
utf8_general_ci
|
|
|
|
Degree1RollNo
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree1Duration
|
int(1)
|
|
|
|
|
Degree1Board
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree1ComleteYear
|
int(4)
|
|
|
|
|
Degree1Marks
|
int(2)
|
|
|
|
|
degree1passedornot
|
varchar(4)
|
utf8_general_ci
|
|
|
|
Degree2
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree2Subjects
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree2RollNo
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree2Duration
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree2Board
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree2CompleteYear
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree2Marks
|
varchar(10)
|
utf8_general_ci
|
|
|
|
degree2passedornot
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree3
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree3Subjects
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree3RollNo
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree3Duration
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree3Board
|
varchar(100)
|
utf8_general_ci
|
|
|
|
Degree3CompleteYear
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Degree3Marks
|
varchar(10)
|
utf8_general_ci
|
|
|
|
degree3passedornot
|
varchar(10)
|
utf8_general_ci
|
|
|
|
OrderofAdmission
|
varchar(10)
|
utf8_general_ci
|
|
|
|
OrderofUniversity
|
varchar(10)
|
utf8_general_ci
|
|
|
|
ExamCategory
|
varchar(10)
|
utf8_general_ci
|
|
|
|
SelectNETWithGate
|
varchar(10)
|
utf8_general_ci
|
|
|
|
NETWithGate
|
varchar(10)
|
utf8_general_ci
|
|
|
|
NETWithJRF
|
varchar(10)
|
utf8_general_ci
|
|
|
|
SelectNETWithJRF
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Exemption
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Nationality
|
varchar(10)
|
utf8_general_ci
|
|
|
|
NationalityType
|
varchar(10)
|
utf8_general_ci
|
|
|
|
PassportNo
|
varchar(10)
|
utf8_general_ci
|
|
|
|
PassportIssuingAthority
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Passportvalidupto
|
varchar(10)
|
utf8_general_ci
|
|
|
|
VisaNo
|
varchar(10)
|
utf8_general_ci
|
|
|
|
VisaIssuingAuthority
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Visavalidupto
|
varchar(10)
|
utf8_general_ci
|
|
|
|
NationalityPerAdd
|
varchar(10)
|
utf8_general_ci
|
|
|
|
Course Code
|
int(3)
|
|
|
|
|
Department
|
varchar(100)
|
utf8_general_ci
|
|
|
|
degreetype
|
varchar(20)
|
utf8_general_ci
|
|
|
|
school_code
|
varchar(20)
|
utf8_general_ci
|
|
|
|
Preference
|
varchar(100)
|
utf8_general_ci
|
|
|
|
OCCM_IS_ACTIVE
|
varchar(10)
|
utf8_general_ci
|
|
|
|
OVERALL_RANK
|
int(4)
|
|
|
|
|
SCORE
|
int(2)
|
|
|
|
|
Singlegirlchild
|
varchar(10)
|
utf8_general_ci
|
|
|
|
UrbanRural
|
varchar(5)
|
utf8_general_ci
|
|
|
|
CourseName
|
varchar(100)
|
utf8_general_ci
|
|
|
|
fyear
|
int(4)
|
|
|
|
