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