reg_id
|
int(11)
|
|
|
|
formNo
|
int(11)
|
|
|
|
Institute_name
|
varchar(22)
|
utf8mb4_general_ci
|
|
|
Post
|
varchar(100)
|
latin1_swedish_ci
|
|
|
post_code
|
varchar(10)
|
latin1_swedish_ci
|
|
|
firstName
|
varchar(100)
|
latin1_swedish_ci
|
|
|
gender
|
varchar(15)
|
latin1_swedish_ci
|
|
|
father_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
mother_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
nationality
|
varchar(6)
|
utf8mb4_general_ci
|
|
|
dob
|
date
|
|
|
|
telNo
|
varchar(50)
|
latin1_swedish_ci
|
|
|
category
|
varchar(10)
|
latin1_swedish_ci
|
|
|
marital_status
|
varchar(10)
|
latin1_swedish_ci
|
|
|
email
|
varchar(200)
|
latin1_swedish_ci
|
|
|
postalAdd1
|
varchar(500)
|
latin1_swedish_ci
|
|
|
postalState
|
varchar(100)
|
latin1_swedish_ci
|
|
|
postalPin
|
int(11)
|
|
|
|
permanentAdd1
|
varchar(500)
|
latin1_swedish_ci
|
|
|
permanentState
|
varchar(100)
|
latin1_swedish_ci
|
|
|
permanentPin
|
int(11)
|
|
|
|
photo_url
|
varchar(250)
|
latin1_swedish_ci
|
|
|
pwd
|
varchar(9)
|
latin1_swedish_ci
|
|
|