Entities (tables)
...
| Name | Type | M/O | Description and constraints |
|---|
| name | string | M |
|
| short_name | string | O |
|
| public_name | string | O |
|
| type | Dictionary: LEGAL_ENTITY_TYPE | M |
|
| edrpou | string | M |
|
| addresses | Address: jsonb[] | M |
|
| phones | Phone: jsonb[] | O |
|
| email | string | O |
|
| inserted_at | timestamp | M |
|
| inserted_by | uuid | M |
|
| updated_at | timestamp | M | |
| updated_by | uuid | M |
|
| is_active | boolean | M |
|
| kveds | array: Dictionary: KVEDS | M |
|
| status | Dictionary: LEGAL_ENTITY_STATUS | M |
|
| owner_property_type | Dictionary: OWNER_PROPERTY_TYPE | M |
|
| legal_form | Dictionary: LEGAL_FORM | M |
|
| created_via_mis_client_id | uuid | M |
|
| nhs_verified | boolean | M |
|
| mis_verified | Dictionary: ????? | M | |
| Contract_info | string ??? | O |
| Info |
|---|
Восстановить атрибут в erd ( в БД остался) |
|
Medical service provider
This entity defines Legal entity extended information structure
| Name | Type | M/O | Description and constraints |
|---|
| accreditation | Accreditation: jsonb | M |
|
| licenses | License: jsonb[] | O |
|
| inserted_at | timestamp | M |
|
| updated_at | timestamp | M |
|
| legal_entity_id | uuid | M |
|
Division
This entity defines division structure
...
| Name | Type | M/O | Description and constraints |
|---|
| name | string | M | +include "номер відокремленого підрозділу" file: eHealth_HL7 Compare erd |
| addresses | Address: jsonb | M |
|
| external_id | string | O |
|
| phones | string | M |
|
| email | string | M |
|
| mountain_group | string | O |
|
| type | Dictionary: DIVISION_TYPE | M |
|
| status | Dictionary: ????? | M | |
| is_active | boolean | M |
|
| inserted_at | timestamp | M |
|
| updated_at | timestamp | M |
|
| location | geometry | O |
|
Data structures
LicenseThis data type defines medical license structure
| Name | Type | M/O | Description and constraints |
|---|
| license_number | string | M | +include "серія (optional)" file: eHealth_HL7 Compare erd |
| issued_by | string | M |
|
| issued_date | string | M |
|
| expiry_date | string | O |
|
| active_from_date | string | M |
|
| what_licensed | string | O |
|
| Anchor |
|---|
| Accreditation |
|---|
| Accreditation |
|---|
|
AccreditationThis data type defines medical accreditation structure
| Name | Type | M/O | Description and constraints |
|---|
| category | Dictionary: ACCREDITATION_CATEGORY | M |
|
| issued_date | string | O |
|
| expiry_date | string | O |
|
| order_no | string | M |
|
| order_date | string | M |
|
| sertificate_no | string | M | номер сертифікату акредитації file: eHealth_HL7 Compare erd
|
| issued_by | string | O | назва органу, що видав file: eHealth_HL7 Compare erd
|
...