Diagram
Source:
Tables
dracs_death_acts
Name | Description | Type |
|---|---|---|
id | Internal eHealth identifier | uuid |
ar_reg_date | Death act registration date in DRACS registry | timestamp |
ar_reg_number | Death act registration number in DRACS registry | varchar(255) |
op_date | Date of last operation with death act | timestamp |
ar_op_name | Name of last operation with death act | varchar(255) |
reg_numb | Death act number in the book of state registration of deaths | varchar(255) |
compose_date | Death act compose date | varchar(255) |
compose_org | The state organization who composed death act | varchar(255) |
is_restore | Restored (renewed) flag | smallint |
name | First name of deceased person | varchar(255) |
surname | Last name of deceased person | varchar(255) |
patronymic | Second name of deceased person | varchar(255) |
date_birth | Birth date of deceased person | varchar(255) |
birth_state | Birthplace country of deceased person | varchar(255) |
birth_region | Birthplace region of deceased person | varchar(255) |
birth_district | Birthplace district of deceased person | varchar(255) |
birth_locality_type | Birthplace locality type of deceased person | varchar(255) |
birth_locality | Birthplace locality name of deceased person | varchar(255) |
sex | Gender of deceased person | varchar(255) |
numident | Tax id of deceased person | varchar(255) |
date_death | Death date of deceased person | varchar(255) |
state | Residence country name of deceased person | text |
region | Residence area name of deceased person | text |
district | Residence district name of deceased person | text |
locality_type | Residence settlement type of deceased person | text |
locality | Residence locality name of deceased person | text |
street | Residence street name of deceased person including street type | text |
house | Residence house number of deceased person | text |
apartment | Residence apartment number of deceased person | text |
doc_seizes | Documents that were seized from a deceased person | jsonb |
inserted_at | Date and time when death act was inserted | timestamp |
updated_at | Date and time when death act was updated | timestamp |
persons_compare_status | Status of comparing death act with person records in MPI db | varchar |
parties_compare_status | Status of comparing death act with party records in PRM db | varchar |
settlement_id | Identifier of deceased persons residence address (calculated based on locality and district fields) | varchar |
dracs_death_acts_hstr
Name | Description | Type |
|---|---|---|
id | Internal record identifier | bigserial |
dracs_death_act_id | Death act identifier from dracs_death_acts table | uuid |
dracs_death_act_data | Full death act data in json format | jsonb |
inserted_at | Date and time when historic death act was inserted | timestamp |
dracs_death_acts_period_updates
Name | Description | Type |
|---|---|---|
id | Internal record identifier | bigserial |
ar_reg_date | Date of death acts registration | date |
updated_at | Date and time when death acts registration date was last time updated from DRACS registry | timestamp |
drfo_data
Name | Description | Type |
|---|---|---|
id | Internal eHealth identifier | uuid |
rnokpp | Identifier of the person in the DRFO registry. May contain tax ID, passport number, ID passport | varchar |
last_name | Last name of the person | varchar |
first_name | First name of the person | varchar |
middle_name | Second name of the person | varchar |
date_birth | Birth date of the person | date |
info_result | Result of InfoRNOKPP call | smallint |
info_error_message | Error message from InfoRNOKPP call. Returns in | varchar |
applications | Result of FindRNOKPPQuery call | [jsonb] |
find_result | Result of FindRNOKPPAnswer call | smallint |
inserted_at | Date and time the record was created | datetime |
inserted_by | User who triggered the record creation (system user if job; employee user if online using person request or DRFO api calls from admin panel). | uuid |
updated_at | Date and time the record was updated or synchronized with DRFO registry | datetime |
updated_by | User who triggered the record update (system user if job; employee user if online using person request or DRFO api calls from admin panel). | uuid |
oban_jobs
Name | Description | Type |
|---|---|---|
id | bigserial | |
queue | char_length between 1 and 127 | text |
worker | char_length between 1 and 127 | text |
args | jsonb | |
errors | _jsonb | |
attempt | Job performing attempts: value from 0 to max_attempts | int4 |
max_attempts | Maximum attempts allowed to perform job | int4 |
inserted_at | timestamp | |
scheduled_at | timestamp | |
attempted_at | timestamp | |
completed_at | timestamp | |
attempted_by | _text | |
discarded_at | timestamp | |
priority | Priority of job, values from 0 to 3 | int4 |
tags | _varchar | |
meta | jsonb | |
cancelled_at | timestamp | |
state | State of job, values according to
| enum |
oban_peers
Name | Description | Type |
|---|---|---|
name | text | |
node | text | |
started_at | timestamp | |
expires_at | timestamp |
unzr_data
Name | Description | Type |
|---|---|---|
id | Internal eHealth identifier | uuid |
unzr | UNZR. It is | string |
family_name | Last name of the person. | string |
given_name | First name of the person. | string |
patronymic_name | Second name of the person. | string |
date_birth | Birth date of the person. | date |
status | Status of the UNZR for a person.
| smallint |
description | Description of the status. | string |
inserted_at | Date and time the record was created | datetime |
updated_at | Date and time the record was updated | datetime |
mvs_passport_data
Name | Description | Type |
|---|---|---|
id | Internal eHealth identifier | uuid |
pass_type | Passport type.
| string |
pas_serial | Passport serial. Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict) | string |
pas_number | Passport number. | string |
pas_status | Passport status in the register.
| smallint |
inserted_at | Date and time the record was created | datetime |
updated_at | Date and time the record was updated | datetime |
dms_passport_data
Name | Description | Type |
|---|---|---|
id | Internal eHealth identifier | uuid |
pass_type | Passport type.
| string |
pas_serial | Passport serial. Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict) | string |
pas_number | Passport number. | string |
pas_status | Passport status in the register.
| smallint |
inserted_at | Date and time the record was created | datetime |
updated_at | Date and time the record was updated | datetime |
unzr_info
Name | Description | Type |
|---|---|---|
id | Internal eHealth identifier | uuid |
unzr | UNZR. It is | string |
job_status | Status of the data update performed by Oban job:
| string |
info | Personal information received from “unzr“ service (tag Info) | jsonb |
synced_at | Date and time when | datetime |
inserted_at | Date and time the record was created | datetime |
inserted_by | User who triggered the record creation (an employee’s user who called the “unzr” api from admin panel). | uuid |
updated_at | Date and time the record was updated or synchronized with EIS MVS registry | datetime |
updated_by | User who triggered the record update or synchronization (an employee’s user who called the “unzr“ api from admin panel). | uuid |