Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Table of Contents

ERD

View file

name	erd_example_v5.pdf
height	250

Data structures

PERSONS

Name	Type	M/O	Description and constraints
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		M
email		O
tax_id		O
death_date		O
is_active		M
documents		M
addresses		M
phones		O
secret		O
emergency_contact		M
confidant_person		O
patient_signed		M
process_disclosure_data_consent		M
authentication_methods		M
preferred_way_communication		M

PARTIES

Name	Type	M/O	Description and constraints
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

EMPLOYEES

Name	Type	M/O	Description and constraints
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

USERS

Name	Type	M/O	Description and constraints
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

LEGAL_ENTITIES

Name	Type	M/O	Description and constraints
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	jsonb	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

DIVISIONS

Name	Type	M/O	Description and constraints
id	uuid	M
external_id	varchar	O
name	varchar	M
type	varchar	O
mountaint_group	boolean	M
location	geometry	M
addresses	jsonb	M
phones	jsonb	M
email	varchar	M
working_hours	jsonb	O
is_active	jsonb	O
legal_entity_id	uuid	M
status	enum ('')	M