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