|
id
|
int(11)
|
|
|
|
|
emp_id
|
int(11)
|
|
|
|
|
pen_id
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
gender_tmp
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
father_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
mother_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
marital_status
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
spouse_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
nationality
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
category
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
appointed_against
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
religion
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
dob_tmp
|
date
|
|
|
|
|
staff_type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
employment_type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
designation_tmp
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
school_tmp
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
department_tmp
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
centre
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
section
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
other_entities
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
date_of_join
|
date
|
|
|
|
|
superannuation_date
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
permanent_address
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
permanent_city
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
permanent_state
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
permanent_pincode
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_address
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_city
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_state
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_pincode
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
mobile_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
phone_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
email_id
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
blood_group
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
disability
|
char(1)
|
latin1_swedish_ci
|
|
|
|
place_of_birth
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
home_town
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
quitted_service
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
quitted_service_type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
quitted_service_sub_type
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
salary_account_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
sav_contrib_type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
gpf_cpf_nps_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
society_no
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
pan_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
health_card_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
height
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
personal_identification_marks
|
text
|
latin1_swedish_ci
|
|
|
|
aadhar_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
date_created
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
