|
id
|
int(11)
|
|
|
|
|
user_id
|
int(11)
|
|
|
|
|
father_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
mother_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
spouse_name
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
nationality
|
varchar(11)
|
latin1_swedish_ci
|
|
|
|
nri_status
|
varchar(4)
|
latin1_swedish_ci
|
|
|
|
nri_country
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
religion
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
other_religion
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
gender
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
marital_status
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
comm_address
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
comm_state
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
comm_pincode
|
int(11)
|
|
|
|
|
perm_address
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
perm_state
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
perm_pincode
|
int(11)
|
|
|
|
|
phone_res
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
phone_off
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
category
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
ex_servicemen
|
int(11)
|
|
|
|
|
disability
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
disability_type
|
varchar(4)
|
latin1_swedish_ci
|
|
|
|
disability_percent
|
float
|
|
|
|
|
near_relative
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
near_relative_name
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
near_relative_designation
|
varchar(30)
|
latin1_swedish_ci
|
|
|
|
near_relative_relationship
|
varchar(30)
|
latin1_swedish_ci
|
|
|
|
other
|
varchar(300)
|
latin1_swedish_ci
|
|
|
|
birth_proof
|
varchar(250)
|
latin1_swedish_ci
|
|
|
|
category_proof
|
varchar(250)
|
latin1_swedish_ci
|
|
|
|
pwd_proof
|
varchar(250)
|
latin1_swedish_ci
|
|
|
|
phd_proof
|
varchar(250)
|
latin1_swedish_ci
|
|
|
|
date_created
|
timestamp
|
|
|
|
|
date_modified
|
timestamp
|
|
|
|
|
email_alt
|
varchar(50)
|
latin1_swedish_ci
|
|
|
