|
id
|
int(10) unsigned
|
|
|
|
|
series
|
varchar(10)
|
|
|
|
|
number
|
varchar(20)
|
|
|
|
|
last_name
|
varchar(100)
|
|
|
|
|
first_name
|
varchar(100)
|
|
|
|
|
middle_name
|
varchar(100)
|
|
|
|
|
birth_date
|
date
|
|
|
|
|
birth_place
|
varchar(255)
|
|
|
|
|
issue_date
|
date
|
|
|
|
|
expiry_date
|
date
|
|
|
|
|
issued_by
|
varchar(255)
|
|
|
|
|
iin
|
varchar(12)
|
|
|
|
|
notes
|
text
|
|
|
|
|
svedenie_no
|
varchar(50)
|
|
|
|
|
load_date
|
date
|
|
|
|
|
permission_number
|
varchar(30)
|
|
|
|
|
permission_date
|
date
|
|
|
|
|
position
|
varchar(255)
|
|
|
|
|
position_detail
|
varchar(255)
|
|
|
|
|
vacancy_code
|
varchar(100)
|
|
|
|
|
permission_from
|
date
|
|
|
|
|
permission_to
|
date
|
|
|
|
|
decision_info
|
varchar(150)
|
|
|
|
|
work_method
|
varchar(50)
|
|
|
|
|
status
|
varchar(30)
|
|
|
active
|
|
permission_file
|
varchar(255)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
|
|
pfz_no
|
varchar(80)
|
|
|
|
|
valid_from
|
date
|
|
|
|
|
valid_to
|
date
|
|
|
|