| id | int(11) |
|
|
|
| employee_id | varchar(200) |
|
|
|
| lang_id | int(11) |
|
|
|
| department | int(11) |
|
|
0
|
| designation | int(11) |
|
|
0
|
| qualification | varchar(200) |
|
|
|
| work_exp | varchar(200) |
|
|
|
| name | varchar(200) |
|
|
|
| surname | varchar(200) |
|
|
|
| father_name | varchar(200) |
|
|
|
| mother_name | varchar(200) |
|
|
|
| contact_no | varchar(200) |
|
|
|
| emergency_contact_no | varchar(200) |
|
|
|
| email | varchar(200) |
|
|
|
| dob | date |
|
|
|
| marital_status | varchar(100) |
|
|
|
| date_of_joining | date |
|
|
|
| date_of_leaving | date |
|
|
|
| local_address | varchar(300) |
|
|
|
| permanent_address | varchar(200) |
|
|
|
| note | varchar(200) |
|
|
|
| image | varchar(200) |
|
|
|
| password | varchar(250) |
|
|
|
| gender | varchar(50) |
|
|
|
| account_title | varchar(200) |
|
|
|
| bank_account_no | varchar(200) |
|
|
|
| bank_name | varchar(200) |
|
|
|
| ifsc_code | varchar(200) |
|
|
|
| bank_branch | varchar(100) |
|
|
|
| payscale | varchar(200) |
|
|
|
| basic_salary | varchar(200) |
|
|
|
| epf_no | varchar(200) |
|
|
|
| contract_type | varchar(100) |
|
|
|
| shift | varchar(100) |
|
|
|
| location | varchar(100) |
|
|
|
| facebook | varchar(200) |
|
|
|
| twitter | varchar(200) |
|
|
|
| linkedin | varchar(200) |
|
|
|
| instagram | varchar(200) |
|
|
|
| resume | varchar(200) |
|
|
|
| joining_letter | varchar(200) |
|
|
|
| resignation_letter | varchar(200) |
|
|
|
| other_document_name | varchar(200) |
|
|
|
| other_document_file | varchar(200) |
|
|
|
| user_id | int(11) |
|
|
|
| is_active | int(11) |
|
|
|
| verification_code | varchar(100) |
|
|
|
`abcschool333`.`expenses`