id
|
int(11)
|
|
|
|
User Reg Id
|
varchar(10)
|
utf8_general_ci
|
|
|
Application No.
|
int(5)
|
|
|
|
Candidate Name
|
tinytext
|
utf8_general_ci
|
|
|
Gender
|
varchar(6)
|
utf8_general_ci
|
|
|
Single Child (if Female)
|
varchar(2)
|
utf8_general_ci
|
|
|
Fathers Name
|
tinytext
|
utf8_general_ci
|
|
|
Mothers Name
|
tinytext
|
utf8_general_ci
|
|
|
Guardians Name
|
tinytext
|
utf8_general_ci
|
|
|
Parents Guardians Contact No
|
bigint(10)
|
|
|
|
Date of Birth
|
date
|
|
|
|
Age as on 1/4/2020
|
int(2)
|
|
|
|
Email Id
|
tinytext
|
utf8_general_ci
|
|
|
Mobile No.
|
bigint(10)
|
|
|
|
Category
|
varchar(20)
|
utf8_general_ci
|
|
|
Differently Abled
|
varchar(2)
|
utf8_general_ci
|
|
|
Disability Category
|
varchar(10)
|
utf8_general_ci
|
|
|
Are you a Defense Personnel
|
varchar(2)
|
utf8_general_ci
|
|
|
Religion
|
varchar(9)
|
utf8_general_ci
|
|
|
Other Religion
|
varchar(10)
|
utf8_general_ci
|
|
|
Nationality
|
varchar(6)
|
utf8_general_ci
|
|
|
Are you Native of Puducherry Union Territory
|
varchar(2)
|
utf8_general_ci
|
|
|
Native / Residence of Karaikal
|
varchar(10)
|
utf8_general_ci
|
|
|
Are you Domicile of Jammu & Kashmir
|
varchar(2)
|
utf8_general_ci
|
|
|
Are you from URBAN/RURAL area
|
varchar(5)
|
utf8_general_ci
|
|
|
Permanent Address
|
tinytext
|
utf8_general_ci
|
|
|
Pincode
|
int(6)
|
|
|
|
City
|
varchar(12)
|
utf8_general_ci
|
|
|
State
|
tinytext
|
utf8_general_ci
|
|
|
Perm Country
|
tinytext
|
utf8_general_ci
|
|
|
Correspondence Address
|
tinytext
|
utf8_general_ci
|
|
|
Pincode2
|
int(6)
|
|
|
|
City2
|
tinytext
|
utf8_general_ci
|
|
|
State2
|
tinytext
|
utf8_general_ci
|
|
|
Comm Country
|
tinytext
|
utf8_general_ci
|
|
|
Preferred Test City 1
|
varchar(18)
|
utf8_general_ci
|
|
|
Preferred Test City 2
|
varchar(8)
|
utf8_general_ci
|
|
|
10th Subject/Specialization
|
varchar(7)
|
utf8_general_ci
|
|
|
10th Register/Roll No
|
int(6)
|
|
|
|
10th Duration of Course
|
int(2)
|
|
|
|
10th Name of University Board/University
|
varchar(27)
|
utf8_general_ci
|
|
|
10th Year of Completion
|
int(4)
|
|
|
|
10th Result
|
varchar(7)
|
utf8_general_ci
|
|
|
10th Percentage
|
int(3)
|
|
|
|
12th Degree Name
|
varchar(11)
|
utf8_general_ci
|
|
|
12th Subject/Specialization
|
varchar(7)
|
utf8_general_ci
|
|
|
12th Register/Roll No
|
int(7)
|
|
|
|
12th Duration of Course
|
int(1)
|
|
|
|
12th Name of University Board/University
|
varchar(27)
|
utf8_general_ci
|
|
|
12th Year of Completion
|
int(4)
|
|
|
|
12th Result
|
varchar(4)
|
utf8_general_ci
|
|
|
12th Percentage
|
decimal(3,1)
|
|
|
|
UG Degree Name
|
varchar(4)
|
utf8_general_ci
|
|
|
UG Subject/Specialization
|
varchar(7)
|
utf8_general_ci
|
|
|
UG Register/Roll No
|
bigint(11)
|
|
|
|
UG Duration of Course
|
int(1)
|
|
|
|
UG Name of University Board/University
|
varchar(20)
|
utf8_general_ci
|
|
|
UG Year of Completion
|
int(4)
|
|
|
|
UG Result
|
varchar(7)
|
utf8_general_ci
|
|
|
UG Percentage
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Degree Name
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Subject/Specialization
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Register/Roll No
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Duration of Course
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Name of University Board/University
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Year of Completion
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Result
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Percentage
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Degree Name
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Subject/Specialization
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Register/Roll No
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Duration of Course
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Name of University Board/University
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Year of Completion
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Result
|
varchar(10)
|
utf8_general_ci
|
|
|
PG Integrated Percentage
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Degree Name
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Subject/Specialization
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Register/Roll No
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Duration of Course
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Name of University Board/University
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Year of Completion
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Result
|
varchar(10)
|
utf8_general_ci
|
|
|
OTHER Percentage
|
varchar(10)
|
utf8_general_ci
|
|
|
Programme Type
|
varchar(17)
|
utf8_general_ci
|
|
|
Specialization
|
varchar(13)
|
utf8_general_ci
|
|
|
PHD Type
|
varchar(10)
|
utf8_general_ci
|
|
|
Exemption for PhD Entrance Exam under Clause
|
varchar(10)
|
utf8_general_ci
|
|
|
Specialization Preference 1
|
varchar(10)
|
utf8_general_ci
|
|
|
Specialization Preference 2
|
varchar(10)
|
utf8_general_ci
|
|
|
Specialization Preference 3
|
varchar(10)
|
utf8_general_ci
|
|
|
Do you Have Work Experience
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_1
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_1
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 1 (Year, Month, days)_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization 2_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_1_1
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_1_1
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_1_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 2 (Year, Month, days)_1
|
varchar(10)
|
utf8_general_ci
|
|
|
No of Publications_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Do you Have Work Experience_2
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization1_2
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_2
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_2
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_2
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 1 (Year, Month, days)_2
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization 2_2
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_2_1
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_2_1
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_2_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 2 (Year, Month, days)_2
|
varchar(10)
|
utf8_general_ci
|
|
|
No of Publications_2
|
varchar(10)
|
utf8_general_ci
|
|
|
Do you Have Work Experience_3
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization1_3
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_3
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_3
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_3
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 1 (Year, Month, days)_3
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization 2_3
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_3_1
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_3_1
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_3_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 2 (Year, Month, days)_3
|
varchar(10)
|
utf8_general_ci
|
|
|
No of Publications_3
|
varchar(10)
|
utf8_general_ci
|
|
|
Do you Have Work Experience_4
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization1_4
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_4
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_4
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_4
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 1 (Year, Month, days)_4
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization 2_4
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_4_1
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_4_1
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_4_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 2 (Year, Month, days)_4
|
varchar(10)
|
utf8_general_ci
|
|
|
No of Publications_4
|
varchar(10)
|
utf8_general_ci
|
|
|
Do you Have Work Experience_5
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization1_5
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_5
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_5
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_5
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 1 (Year, Month, days)_5
|
varchar(10)
|
utf8_general_ci
|
|
|
Name of Organization 2_5
|
varchar(10)
|
utf8_general_ci
|
|
|
Post Held_5_1
|
varchar(10)
|
utf8_general_ci
|
|
|
From Date_5_1
|
varchar(10)
|
utf8_general_ci
|
|
|
TO Date_5_1
|
varchar(10)
|
utf8_general_ci
|
|
|
Work Experience 2 (Year, Month, days)_5
|
varchar(10)
|
utf8_general_ci
|
|
|
No of Publications_5
|
varchar(10)
|
utf8_general_ci
|
|
|
Payment Status
|
varchar(1)
|
utf8_general_ci
|
|
|
Payment Date
|
varchar(29)
|
utf8_general_ci
|
|
|
Basic Registration Date
|
varchar(16)
|
utf8_general_ci
|
|
|
Profile Submission Date
|
varchar(10)
|
utf8_general_ci
|
|
|
NSEIT Transaction number
|
varchar(12)
|
utf8_general_ci
|
|
|
Status
|
varchar(21)
|
utf8_general_ci
|
|
|
Course_Code
|
varchar(6)
|
utf8_general_ci
|
|
|
Rank
|
varchar(6)
|
utf8_general_ci
|
|
|
Total_Score
|
varchar(6)
|
utf8_general_ci
|
|
|