Schema
.png?version=1&modificationDate=1726065884244&cacheVersion=1&api=v2&width=760&height=445)
Source file:
Tables
person_verifications
The table in MPI db is used to store results of synchronization with external registries that characterizes a person
Name | Type | M/O | Description |
|---|---|---|---|
id | uuid | M | Internal eHealth identifier |
person_id | uuid | M | Person mpi identifier, unique |
drfo_data_id | uuid | O | Identifier of the record from mimir.drfo_data |
drfo_data_result | smallint | O | Result of the last synchronization with DRFO. Value according to DRFO_RESULT dictionary |
drfo_synced_at | datetime | O | Date and time of the last synchronization with DRFO |
drfo_verification_status | varchar | M | Verification status according to DRFO for the current person |
drfo_verification_reason | varchar | M | Reason of the DRFO verification status |
drfo_unverified_at | datetime | O | Date and time of DRFO verification status change to ‘NOT_VERIFIED’ |
dracs_death_act_id | uuid | O | Identifier of the record from mimir.dracs_death_acts |
dracs_death_online_status | varchar | M | Online sync status with DRACS death acts registry for the current person |
dracs_death_verification_status | varchar | M | Verification status according to DRACS death acts for the current person |
dracs_death_verification_reason | varchar | M | Reason of the DRACS death acts verification status |
dracs_death_verification_comment | varchar | O | Comment for DRACS death acts verification status |
dracs_death_unverified_at | datetime | O | Date and time of DRACS death acts verification status change to ‘NOT_VERIFIED’ |
nhs_verification_status | varchar | M | Verification status according to manual NHS rules for the current person |
nhs_verification_reason | varchar | M | Reason of the manual NHS rules verification status |
nhs_verification_comment | varchar | O | Comment for manual NHS rules verification status |
nhs_unverified_at | datetime | O | Date and time of manual NHS rules verification status change to ‘NOT_VERIFIED’ |
unzr_data_id | uuid | O | Identifier of the record from mimir.unzr_data |
unzr_data_status | smallint | O | Status of the last synchronization with UNZR register (MVS). Value according to EIS_MVS_STATUS dictionary |
unzr_synced_at | datetime | O | Date and time of the last synchronization with UNZR register |
unzr_verification_status | varchar | M | Verification status according to UNZR for the current person |
unzr_verification_reason | varchar | M | Reason of the UNZR verification status |
unzr_unverified_at | datetime | O | Date and time of UNZR verification status change to ‘NOT_VERIFIED’ |
mvs_passport_data_id | uuid | O | Identifier of the record from mimir.mvs_passport_data |
mvs_passport_data_status | smallint | O | Status of the last synchronization with Passport register (MVS). Value according to EIS_MVS_STATUS dictionary |
mvs_passport_synced_at | datetime | O | Date and time of the last synchronization with Passport register (MVS) |
mvs_passport_verification_status | varchar | M | Verification status of Passport (MVS) for the current person |
mvs_passport_verification_reason | varchar | M | Reason of the verification status for the Passport (MVS) |
mvs_passport_unverified_at | datetime | O | Date and time of Passport (MVS) verification status change to ‘NOT_VERIFIED’ |
dms_passport_data_id | uuid | O | Identifier of the record from mimir.dms_passport_data |
dms_passport_data_status | smallint | O | Status of the last synchronization with Passport register (DMS). Value according to EIS_MVS_STATUS dictionary |
dms_passport_synced_at | datetime | O | Date and time of the last synchronization with Passport register (DMS) |
dms_passport_verification_status | varchar | M | Verification status of Passport (DMS) for the current person |
dms_passport_verification_reason | varchar | M | Reason of the verification status for the Passport (DMS) |
dms_passport_unverified_at | datetime | O | Date and time of Passport (DMS) verification status change to ‘NOT_VERIFIED’ |
inserted_at | datetime | M | Date and time the record was created |
inserted_by | uuid | M | User who triggered the record creation (system user if job; employee user if online using person request or DRFO api calls from admin panel). |
updated_at | datetime | M | Date and time the record was updated |
updated_by | uuid | M | User who triggered the record update (system user if job; employee user if online using person request or DRFO api calls from admin panel). |
Assumed unique constraint on person_id:
create unique index person_verifications_person_id_index
on person_verifications (person_id);
person_verification_candidates
The table in MPI db is used to store links between person_id and dracs_death_act_id that were created as the result of comparing persons data with death act data
Name | Type | M/O | Description |
|---|---|---|---|
id | uuid | M | Internal record identifier |
person_id | uuid | M | Person mpi identifier, unique |
entity_id | uuid | M | Identifier of entity that created candidate, type is specified in entity_type field |
entity_type | varchar | M | Type of entity that triggered verification candidate pair Values:
|
status | varchar | M | Status of verification candidate Values:
|
status_reason | varchar | O | Optional reason of verification candidate status Values:
|
config | jsonb | O | Variables that were used in comparison process |
details | jsonb | O | Additional details of comparison process |
score | float | O | Logistic regression comparison score |
inserted_at | timestamp | M | Date and time the record was created |
updated_at | timestamp | M | Date and time the record was updated |
drfo_data
The table in MIMIR db used to store drfo data about person that were received from DRFO registry.
Model described at https://e-health-ua.atlassian.net/wiki/spaces/RNOKPP/pages/17158111293/DRFO+integration+data+model#drfo_data
unzr_data
The table in MIMIR db used to store unzr data about person that were received from UNZR registry bu means of checkunzr service.
Model described at https://e-health-ua.atlassian.net/wiki/spaces/EDDR/pages/18049171555/MVS+integration+data+model#unzr_data
mvs_passport_data
The table in MIMIR db used to store data about passport documents that were received from registry of stolen and lost ones by means of CheckPassportStatus service.
Model described at https://e-health-ua.atlassian.net/wiki/spaces/EDDR/pages/18049171555/MVS+integration+data+model#mvs_passport_data
dms_passport_data
The table in MIMIR db used to store data about passport documents that were received from registry of invalid ones by means of CheckPassportDMSStatus service.
Model described at https://e-health-ua.atlassian.net/wiki/spaces/EDDR/pages/18049171555/MVS+integration+data+model#dms_passport_data