Table of Contents

ERD

...

Data structures

Name	Type	M/O
id	uuid	M
last_name	varchar	M
first_name	varchar	M
second_name	varchar	O
birth_date	date	M
birth_country	varchar	M
birth_settlement	varchar	M
gender	varchar	M
email	varchar	O
tax_id	varchar	O
invalid_tax_id	boolean	O
death_date	date	O
is_active	boolean	M
documents	jsonb[ ]	M
addresses	jsonb[ ]	M
phones	jsonb[ ]	O
secret	varchar	O
emergency_contact	jsonb	M
confidant_person	jsonb[]	O
patient_signed	boolean	M
process_disclosure_data_consent	boolean	M
authentication_methods	jsonb	M
preferred_way_communication	varchar	M

Name	Type	M/O
id	uuid	M
last_name	varchar	M
first_name	varchar	M
second_name	varchar	O
person_id	uuid	O
email	varchar	M
birth_date	date	M
gender	varchar	M
tax_id	varchar	M
no_tax_id	boolean	O
documents	jsonb[]	M
phones	jsonb[]	M
educations	jsonb[]	O
qualifications	jsonb[]	O
specialities	jsonb[]	O
science_degree	jsonb	O
about_myself	date	O
working_experience	string	O

Name	Type	M/O
id	uuid	M
person_id	uuid	O
position	varchar	M
status	varchar	M
status_reason	varchar	O
employee	varchar	M
employee_type	varchar	M
is_active	boolean	M
start_date	timestamp	M
end_date	timestamp	O
legal_entity_id	uuid	M
division_id	uuid	O
speciality	jsonb	O
properties	jsonb	O

Name	Type	M/O
id	uuid	M
email	varchar	M
password	varchar	M
settings	jsonb	O
priv_settings	jsonb	O
is_blocked	boolean	O
block_reason	varchar	O
person_id	uuid	O
inserted_at	timeatamp	M
updated_at	timeatamp	M

Name	Type	M/O
id	uuid	M
name	varchar	M
short_name	varchar	M
public_name	varchar	M
status	varchar	M
type	varchar	M
owner_property_type	varchar	M
legal_form	varchar	M
edrpou	varchar	M
kveds	varchar	M
addresses	jsonb[ ]	M
phones	jsonb[ ]	M
email	varchar	M
is_active	boolean	M
mis_verified	boolean	O
nhs_verified	boolean	O
website	varchar	O
beneficiary	varchar	O
receiver_funds_code	varchar	O
archive	jsonb	O

...

Name	Type	M/O	Description and constraints
type	Dictionary: ADDRESS_TYPE	M
country	Dictionary: COUNTRY	M
area	string	M
region	string	O
settlement	string	M
settlement_id	string	M	settlement_id must be a valid UAddresses entity
settlement_type	Dictionary: SETTLEMENT_TYPE	M
street_type	Dictionary: STREET_TYPE	M
street	string	O
building	string	M
apartment	string	O
zip	string	O

...