ЕСОЗ - публічна документація

RC_MVS integration data model (DMS)

Schema

 

mvs integration data model v2.drawio.png

Tables

The tables used in the MVS synchronization process are listed there.

unzr_data

The table in MIMIR db used to store unzr data about person that were received from UNZR registry by means of checkunzr service. Records should not store links to mpi.

Name

Type

M/O

Description

Name

Type

M/O

Description

id

uuid

M

 Internal eHealth identifier

unzr

string

M

UNZR. It is UNZR field from request of checkunzr service

family_name

string

M

Last name of the person. familyName field from request of checkunzr service

given_name

string

M

First name of the person. givenName field from request of checkunzr service

patronymic_name

string

M

Second name of the person. patronymicName field from request of checkunzr service

date_birth

date

M

Birth date of the person. dateBirth field from request of checkunzr service

status

smallint

M

Status of the UNZR for a person. Status field from response of checkunzr service. Available values:

  • 0 - record not found;

  • 1 - record found;

  • -1 - mandatory fields are not filled in or filled in incorrectly;

  • -2 - internal server error

description

string

M

Description of the status. Description field from response of checkunzr service

inserted_at

datetime

M

Date and time the record was created

updated_at

datetime

M

Date and time the record was updated

Assumed unique index on unzr:

create unique index unzr_data_unzr_index on unzr_data (unzr);

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. Records should not store links to mpi.

Name

Type

M/O

Description

Name

Type

M/O

Description

id

uuid

M

 Internal eHealth identifier

pass_type

string

M

Passport type. PassType field from request of CheckPassportStatus service. Available values are:

  • 0101 - “Паспорт громадянина України” (PASSPORT, NATIONAL_ID from DOCUMENT_TYPE dict)

  • 0102 - “Паспорт громадянина України для виїзду за кордон” (absent in the DOCUMENT_TYPE dict and won’t be used at the moment)

pas_serial

string

O

Passport serial. PasSerial field from request of CheckPassportStatus service

Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict)

pas_number

string

M

Passport number. PasNumber field from request of CheckPassportStatus service

pas_status

smallint

M

Passport status in the register. PasStatus field from a response of CheckPassportStatus service. Available values:

  • 0 - record not found;

  • 1 - record found;

  • -1 - mandatory fields are not filled in or filled in incorrectly;

  • -2 - internal server error

inserted_at

datetime

M

Date and time the record was created

updated_at

datetime

M

Date and time the record was updated

Assumed unique index on pass_type, pas_serial, pas_number:

create unique index mvs_passport_data_pass_type_pas_serial_pas_number_index on mvs_passport_data (pass_type, pas_serial, pas_number);

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. Records should not store links to mpi.

Name

Type

M/O

Description

Name

Type

M/O

Description

id

uuid

M

 Internal eHealth identifier

pass_type

string

M

Passport type. PassType field from request of CheckPassportDMSStatus service. Available values are:

  • 0101 - “Паспорт громадянина України” (PASSPORT, NATIONAL_ID from DOCUMENT_TYPE dict)

  • 0102 - “Паспорт громадянина України для виїзду за кордон” (absent in the DOCUMENT_TYPE dict and won’t be used at the moment)

pas_serial

string

O

Passport serial. PasSerial field from request of CheckPassportDMSStatus service

Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict)

pas_number

string

M

Passport number. PasNumber field from request of CheckPassportDMSStatus service

pas_status

smallint

M

Passport status in the register. PasStatus field from a response of CheckPassportDMSStatus service. Available values:

  • 0 - record not found;

  • 1 - record found;

  • -1 - mandatory fields are not filled in or filled in incorrectly;

  • -2 - internal server error

inserted_at

datetime

M

Date and time the record was created

updated_at

datetime

M

Date and time the record was updated

Assumed unique index on pass_type, pas_serial, pas_number:

create unique index dms_passport_data_pass_type_pas_serial_pas_number_index on dms_passport_data (pass_type, pas_serial, pas_number);

person_verifications

The table in MPI db is used to store results of synchronization with external registries that characterizes a person

Model described Person verification status model_EN | person_verifications

party_verifications

The table in PRM db is used to store results of synchronization with external registries that characterizes a party

Model described Party verification data model | party_verifications

unzr_info

The table in MIMIR db used to store personal information of Persons were received by UNZR from EIS MVS registry using unzr service. Records should not store links to mpi.

Name

Type

M/O

Description

Name

Type

M/O

Description

id

uuid

M

 Internal eHealth identifier

unzr

string

M

UNZR. It is unzr field from request of unzr service, unique

job_status

string

M

Status of the data update performed by Oban job:

  • pending

  • processed

  • failed

info

jsonb

O

Personal information received from “unzr“ service (tag Info)

synced_at

datetime

O

Date and time when info was successfully synced with register

inserted_at

datetime

M

Date and time the record was created

inserted_by

uuid

M

User who triggered the record creation (an employee’s user who called the “unzr” api from admin panel).

updated_at

datetime

M

Date and time the record was updated or synchronized with EIS MVS registry

updated_by

uuid

M

User who triggered the record update or synchronization (an employee’s user who called the “unzr“ api from admin panel).

Assumed unique index on unzr:

ЕСОЗ - публічна документація