| Table of Contents |
|---|
ERD
Data structures
PERSONS
| Name | Type | M/O | Description and constraints | Report |
|---|---|---|---|---|
| id | uuid | M | X | |
| last_name | varchar | M | ||
| first_name | varchar | M | ||
| second_name | varchar | O | ||
| birth_date | date | M | X | |
| 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 | X | |
| is_active | boolean | M | ||
| documents | jsonb[ ] | M | ||
| addresses | jsonb[ ] | M | X | |
| 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 | Report |
|---|---|---|---|---|
| id | uuid | M | X | |
| last_name | varchar | M | X | |
| first_name | varchar | M | X | |
| second_name | varchar | O | X | |
| 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 | ||
| properties | jsonb | O |
EMPLOYEES
| Name | Type | M/O | Description and constraints | Report | |||
|---|---|---|---|---|---|---|---|
| id | uuid | M | X | ||||
| person_id | uuid | O | |||||
| position | varchar | M | X | ||||
| status | varchar | M | X | ||||
| status_reason | varchar | O | |||||
| employee | varchar | M | |||||
| employee_type | varchar | M | X | ||||
| is_active | boolean | M | X | ||||
| start_date | timestamp | M | X | ||||
| end_date | timestamp | O | X | ||||
| legal_entity_id | uuid | M | X | ||||
| division_id | uuid | O | speciality | jsonb | O | propertiesX | |
| speciality | 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 | Report |
|---|---|---|---|---|
| id | uuid | M | X | |
| name | varchar | M | X | |
| short_name | varchar | M | X | |
| public_name | varchar | M | X | |
| status | varchar | M | X | |
| type | varchar | M | X | |
| owner_property_type | varchar | M | X | |
| legal_form | varchar | M | X | |
| edrpou | varchar | M | X | |
| kveds | varchar | M | X | |
| addresses | jsonb[ ] | M | X | |
| phones | jsonb[ ] | M | X | |
| varchar | M | X | ||
| is_active | boolean | M | X | |
| mis_verified | boolean | O | X | |
| nhs_verified | boolean | O | X | |
| website | varchar | O | X | |
| beneficiary | varchar | O | ||
| receiver_funds_code | varchar | O | ||
| archive | jsonb | O |
...
| Name | Type | M/O | Description and constraints | Report |
|---|---|---|---|---|
| id | uuid | M | X | |
| external_id | varchar | O | X | |
| name | varchar | M | X | |
| type | varchar | O | X | |
| mountaint_group | boolean | M | X | |
| location | geometry | M | X | |
| addresses | jsonb[ ] | M | X | |
| phones | jsonb[ ] | M | X | |
| varchar | M | X | ||
| working_hours | jsonb[ ] | O | X | |
| is_active | boolean | O | X | |
| legal_entity_id | uuid | M | X | |
| status | enum ('') | M | X |
REGISTERS
| 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
...