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 |
|
| email | varchar | O |
|
| tax_id | varchar | 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 |
|
| email | 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 |
|
| email | 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 |
|
| email | 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 |
|
| external_id | varchar | O |
|
| name | varchar | M |
|
| type | varchar | O |
|
| mountaint_group | boolean | M |
|
| location | geometry | M |
|
| addresses | jsonb[ ] | M |
|
| phones | jsonb[ ] | M |
|
| email | varchar | M |
|
| working_hours | jsonb[ ] | O |
|
| is_active | boolean | O |
|
| legal_entity_id | uuid | M |
|
| status | enum ('') | M |
|
JSONB structures
Address
This data type defines address structure
| 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
This data type defines Phone structure
| Name | Type | M/O | Description and constraints |
|---|
| type | Dictionary: PHONE_TYPE | M |
|
| number | string | M |
|
Document
This data type defines Document structure
| Name | Type | M/O | Description and constraints |
|---|
| type | Dictionary: DOCUMENT_TYPE | M |
|
| number | string | M |
|
| issued_at | date | O |
|
| issued_by | string | O |
|
Emergency_contact
| Name | Type | M/O | Description and constraints |
|---|
| first_name | string | M |
|
| last_name | string | M |
|
| second_name | string | O |
|
| phones | jsonb [] | M |
|
Confidant_person
| Name | Type | M/O | Description and constraints |
|---|
| type | enum: [PRIMARY,
SECONDARY] | M |
|
| first_name | string | M |
|
| last_name | string | M |
|
| second_name | string | O |
|
| birth_date | date | M |
|
| birth_country | Dictionary: COUNTRY | M |
|
| birth_settlement | string | M |
|
| gender | string | M |
|
| tax_id | string | M |
|
| secret | string | O |
|
| documents_person | Document: jsonb[ ] | M |
|
| documents_relationship | Document: jsonb[ ] | M |
|
| phones | Phone: jsonb[ ] | M |
|
Authentification_method
| Name | Type | M/O | Description and constraints |
|---|
| type | enum['OFFLINE'/'MOBILE_PHONE'] | M |
|
| number | string | O |
|
...
| Name | Type | M/O | Description and constraints |
|---|
| country | Dictionary: COUNTRY | M |
|
| city | name | M |
|
| degree | Dictionary: SCIENCE_DEGREE | M |
|
| institution_name | varchar | M |
|
| diploma_number | varchar | M |
|
| speciality | date | M |
|
Properties
| Name | Type | M/O | Description and constraints |
|---|
| limit | number | M |
|
| counter | number | M |
|