id | int(11) |
|
|
|
em_id | varchar(64) |
|
|
|
em_code | varchar(64) |
|
|
|
des_id | int(11) |
|
|
|
dep_id | int(11) |
|
|
|
first_name | varchar(128) |
|
|
|
last_name | varchar(128) |
|
|
|
em_email | varchar(64) |
|
|
|
em_password | varchar(512) |
|
|
|
em_role | enum | -- |
|
EMPLOYEE
|
em_address | varchar(512) |
|
|
|
status | enum | -- |
|
ACTIVE
|
em_gender | enum | -- |
|
Male
|
em_phone | varchar(64) |
|
|
|
em_birthday | varchar(128) |
|
|
|
em_blood_group | enum | -- |
|
|
em_joining_date | varchar(128) |
|
|
|
em_contact_end | varchar(128) |
|
|
|
em_image | varchar(128) |
|
|
|
em_nid | varchar(64) |
|
|
|