Table of Contents |
---|
HL7 comparison
...
Entities (tables)
Legal entity
This entity defines Legal entity information structure
Name | Type | M/O |
---|
[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].accreditation
[legal_entities].email | varchar
Entities (tables)
...
This entity defines Legal entity extended information structure
...
Info |
---|
Сделать Mandatory |
...
Info |
---|
Не нашел справочник |
...
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 | timestampDescription 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 | legal_entity_id | uuid |
| ||
updated_by | uuid | M | |||||
is_active | boolean | M | |||||
kveds | array: Dictionary: KVEDS | M |
...
...
This entity defines division structure
Info |
---|
Нема ЄДРПОУ. Підрозділи що мають ЄДРПОУ мають бути внесені у [legal_entities] |
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 |
Info |
---|
Не нашел справочник |
Info |
---|
Не нашел справочник |
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 | location | geometry | O |
Data structures
...
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 | назва органу, що видав |
...