| Table of Contents |
|---|
To be deleted!!! HL7 comparison
...
[legal_entities].edrpou | varchar(255) | not null unique
...
Address: [legal_entities].addresses | jsonb[] | not null
...
Address: [legal_entities].addresses | jsonb[] | not null
...
| Info |
|---|
New entity |
...
| Table of Contents |
|---|
Entities (tables)
Legal entity
This entity defines Legal entity extended information structure
| 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 | |||
| 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 |
|
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 "номер відокремленого підрозділу" | ||
| addresses | Address: jsonb | M | |||
| external_id | string | O | |||
| phones | string | M | |||
| 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
| Anchor | ||||
|---|---|---|---|---|
|
This data type defines medical license structure
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| license_number | string | M | +include "серія (optional)" |
| issued_by | string | M | |
| issued_date | string | M | |
| expiry_date | string | O | |
| active_from_date | string | M | |
| what_licensed | string | O |
| Anchor | ||||
|---|---|---|---|---|
|
This 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 | номер сертифікату акредитації |
| issued_by | string | O | назва органу, що видав |
...