| Table of Contents |
|---|
HL7 comparison
...
Entities (tables)
Legal entity
This entity defines Legal entity information structure
| Name | Type | M/O |
|---|
| Description and constraints |
|---|
| name |
| string |
[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 |
Нема просто адреси, тобто е тільки фактичне місцезнаходження
[medical_service_providers].licenses
[medical_service_providers].accreditation
[legal_entities].email | varchar
Data structures
...
| 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
| Info |
|---|
Нема ЄДРПОУ. Підрозділи що мають ЄДРПОУ мають бути внесені у [legal_entities] |
...
| Name | Type | M/O | Description and constraints | type | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| name | string | M | country | Dictionary: COUNTRY | M | area | string | M | region+include "номер відокремленого підрозділу" | ||||||
| addresses | Address: jsonb | M | |||||||||||||
| external_id | string | O | |||||||||||||
| settlementphones | string | M | |||||||||||||
| settlement_idemail | string | M | settlement_id must be a valid UAddresses entity | ||||||||||||
| settlement_mountain_group | string | O | |||||||||||||
| type | Dictionary: SETTLEMENTDIVISION_TYPE | M | |||||||||||||
| street_typestatus | Dictionary: | STREET_TYPE????? | M | street | string | O | building | string | M | apartment | string | O | zip | string | O |
...
| |||
| 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 | назва органу, що видав |