Entities (tables)

Legal entity

This entity defines Legal entity 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
email	string	O
inserted_at	timestamp	M
inserted_by	uuid	M
updated_at	timestamp	M	Сделать Mandatory
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	Восстановить атрибут в erd ( в БД остался)

This entity defines Legal entity extended information structure

Name	Type	M/O
accreditation	Accreditation: jsonb	M
licenses	License: jsonb[]	O
inserted_at	timestamp	M
updated_at	timestamp	M
legal_entity_id	uuid	M

This entity defines division structure

Нема ЄДРПОУ. Підрозділи що мають ЄДРПОУ мають бути внесені у [legal_entities]

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

This 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

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	номер сертифікату акредитації file: eHealth_HL7 Compare erd
issued_by	string	O	назва органу, що видав file: eHealth_HL7 Compare erd