| Table of Contents |
|---|
ERD
Data structures
PERSONS
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| last_name | varchar | M | |
| first_name | varchar | M | |
| second_name | varchar | O | |
| birth_date | date | M | |
| birth_country | varchar | M | |
| birth_settlement | varchar | M | |
| gender | varchar | M | |
| varchar | O | ||
| tax_id | varchar | O | |
| invalid_tax_id | boolean | O | |
| death_date | date | O | |
| is_active | boolean | M | |
| documents | jsonb[ ] | M | |
| addresses | jsonb[ ] | M | |
| phones | jsonb[ ] | O | |
| secret | varchar | O | |
| emergency_contact | jsonb | M | |
| confidant_person | jsonb[] | O | |
| patient_signed | boolean | M | |
| process_disclosure_data_consent | boolean | M | |
| authentication_methods | jsonb | M | |
| preferred_way_communication | varchar | M |
PARTIES
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| last_name | varchar | M | |
| first_name | varchar | M | |
| second_name | varchar | O | |
| person_id | uuid | O | |
| varchar | M | ||
| birth_date | date | M | |
| gender | varchar | M | |
| tax_id | varchar | M | |
| no_tax_id | boolean | O | |
| documents | jsonb[] | M | |
| phones | jsonb[] | M | |
| educations | jsonb[] | O | |
| qualifications | jsonb[] | O | |
| specialities | jsonb[] | O | |
| science_degree | jsonb | O | |
| about_myself | date | O | |
| working_experience | string | O |
EMPLOYEES
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| person_id | uuid | O | |
| position | varchar | M | |
| status | varchar | M | |
| status_reason | varchar | O | |
| employee | varchar | M | |
| employee_type | varchar | M | |
| is_active | boolean | M | |
| start_date | timestamp | M | |
| end_date | timestamp | O | |
| legal_entity_id | uuid | M | |
| division_id | uuid | O | |
| speciality | jsonb | O | |
| properties | jsonb | O |
USERS
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| varchar | M | ||
| password | varchar | M | |
| settings | jsonb | O | |
| priv_settings | jsonb | O | |
| is_blocked | boolean | O | |
| block_reason | varchar | O | |
| person_id | uuid | O | |
| inserted_at | timeatamp | M | |
| updated_at | timeatamp | M |
LEGAL_ENTITIES
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| name | varchar | M | |
| short_name | varchar | M | |
| public_name | varchar | M | |
| status | varchar | M | |
| type | varchar | M | |
| owner_property_type | varchar | M | |
| legal_form | varchar | M | |
| edrpou | varchar | M | |
| kveds | varchar | M | |
| addresses | jsonb[ ] | M | |
| phones | jsonb[ ] | M | |
| varchar | M | ||
| is_active | boolean | M | |
| mis_verified | boolean | O | |
| nhs_verified | boolean | O | |
| website | varchar | O | |
| beneficiary | varchar | O | |
| receiver_funds_code | varchar | O | |
| archive | jsonb | O |
...
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| file_name | varchar | M | |
| status | enum[new, processing, processed ] | M | |
| type | DICTIONARY='REGISTER_TYPE' | M | |
| qty | jsonb: {not_found: number, processing: number, errors: number, total: number} | M | |
| errors | array (e.g. ["Row has length 4 - expected length 5 on line 5"]) | M | |
| inserted_at | uuid | M | |
| inserted_by | timestamp | M | |
| updated_at | uuid | M | |
| updated_by | timestamp | M |
REGISTER_ENTRIES
| Name | Source | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| register_id | uuid | M | |
| tax_id | varchar | O | |
national_id | varchar | O | |
passport | varchar | O | |
birth_certificate | varchar | O | |
temporary_certificate | varchar | O | |
| status | enum (processing, matched, not_found) | M | |
| inserted_at | uuid | M | |
| inserted_by | timestamp | M | |
| updated_at | uuid | M | |
| updated_by | timestamp | M |
JSONB structures
Address
...
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| type | Dictionary: ADDRESS_TYPE | M | |
| country | Dictionary: COUNTRY | M | |
| area | string | M | |
| region | string | O | |
| settlement | string | M | |
| settlement_id | string | M | settlement_id must be a valid UAddresses entity |
| settlement_type | Dictionary: SETTLEMENT_TYPE | M | |
| street_type | Dictionary: STREET_TYPE | M | |
| street | string | O | |
| building | string | M | |
| apartment | string | O | |
| zip | string | O |
Phone
...
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| type | Dictionary: SPECIALITY_TYPE | M | |
| speciality_officio | booleantrue | M | |
| level | Dictionary: SPECIALITY_LEVEL | M | |
| qualification_type | Dictionary: SPEC_QUALIFICATION_TYPE | M | |
| attestation_name | varchar | M | |
| attestation_date | date | M | |
| valid_to_date | date | O | |
| certificate_number | varchar | M |
...