|
id
|
int(11)
|
|
|
|
|
first_name
|
varchar(255)
|
|
|
|
|
sur_name
|
varchar(255)
|
|
|
|
|
gender
|
varchar(120)
|
|
|
|
|
date_of_birth
|
date
|
|
|
|
|
nationality_id
|
int(11)
|
|
|
|
|
religion_id
|
int(11)
|
|
|
|
|
mobile_no_1
|
text
|
|
|
|
|
is_whatsapp_mobile_1
|
int(11)
|
|
|
|
|
is_comon_mobile_1
|
int(11)
|
|
|
|
|
mobile_no_2
|
text
|
|
|
|
|
is_whatsapp_mobile_2
|
int(11)
|
|
|
|
|
is_comon_mobile_2
|
int(11)
|
|
|
|
|
email
|
text
|
|
|
|
|
city
|
varchar(255)
|
|
|
|
|
town
|
varchar(255)
|
|
|
|
|
street
|
text
|
|
|
|
|
social_security_no
|
varchar(255)
|
|
|
|
|
tax_no
|
varchar(255)
|
|
|
|
|
profession_id
|
int(11)
|
|
|
|
|
sector_id
|
int(11)
|
|
|
|
|
can_read
|
int(11)
|
|
|
|
|
can_write
|
int(11)
|
|
|
|
|
is_lives_in_project_staff_house
|
int(11)
|
|
|
|
|
from_date
|
date
|
|
|
|
|
to_date
|
date
|
|
|
|
|
ResignType
|
varchar(255)
|
|
|
|
|
image
|
text
|
|
|
|
|
signature_image
|
varchar(255)
|
|
|
|
|
status
|
int(11)
|
|
|
1
|
|
deleted
|
int(11)
|
|
|
0
|
|
addedOn
|
datetime
|
|
|
|
|
addedBy
|
int(11)
|
|
|
|
|
modifiedBy
|
int(11)
|
|
|
|
|
modifiedOn
|
timestamp
|
|
|
current_timestamp()
|