| id |
int(11)
|
|
|
|
| org_id |
int(11)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| source_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| doc_type |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| issuing_country |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| surname |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| first_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| patronymic |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| document_number |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| nationality |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| birth_date |
date
|
|
|
|
| sex |
char(1)
|
utf8mb4_general_ci
|
|
|
| issue_date |
date
|
|
|
|
| expiry_date |
date
|
|
|
|
| authority |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| mrz_found |
tinyint(1)
|
|
|
|
| raw_ocr_text |
text
|
utf8mb4_general_ci
|
|
|
| status |
enum('ok', 'needs_review', 'rejected')
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| emp_id |
int(11)
|
|
|
|
| svedenie_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| attached_org_id |
int(11)
|
|
|
|
| attached_at |
datetime
|
|
|
|
| is_verified |
tinyint(1)
|
|
|
|
| edited_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| field_name |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| container_id |
int(10)
|
|
|
|