...

...
name erd_example_v5.pdf
height 250

Table of Contents

ERD

View file

name	erd_example_v5.pdf
height	250400

Data structures

PERSONS

Name	Type	M/O	Report
id	uuid	M	X
last_name	varchar	M
first_name	varchar	M
second_name	varchar	O
birth_date	date	M	X
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	X
is_active	boolean	M
documents	jsonb[ ]	M
addresses	jsonb[ ]	M	X
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

PARTIES

Name	Type	M/O	Report
id	uuid	M	X
last_name	varchar	M	X
first_name	varchar	M	X
second_name	varchar	O	X
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
declaration_limit	varchar	O	X

EMPLOYEES

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

jsonbOproperties

jsonb

O

USERS

Name	Type	M/O	Description and constraints
id	uuid	M
email	varchar	M
tax_id	varchar	O	unique
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

OPEN_IDS

Name	Type	M/O
id	uuid	M
person_id	uuid	M
type	varchar	M
open_id	varchar	M

LEGAL_ENTITIES

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

DIVISIONS

Name	Type	M/O	Report
id	uuid	M	X
external_id	varchar	O	X
name	varchar	M	X
type	varchar	O	X
mountaint_group	boolean	M	X
location	geometry	M	X
addresses	jsonb[ ]	M	X
phones	jsonb[ ]	M	X
email	varchar	M	X
working_hours	jsonb[ ]	O	X
is_active	boolean	O	X
legal_entity_id	uuid	M	X
status	enum ('')	M	X

REGISTERS

Name	Type	M/O
id	uuid	M
file_name	varchar	M
status	enum[new, processing, processed ]	M
type	DICTIONARY='REGISTER_TYPE'	M
qty	jsonb: {not_found: number, processing: number, errors: number, total: number}	M
errors	array (e.g. ["Row has length 4 - expected length 5 on line 5"])	M
inserted_at	uuid	M
inserted_by	timestamp	M
updated_at	uuid	M
updated_by	timestamp	M

REGISTER_ENTRIES

Name	Source	M/O	Description and constraints
id	uuid	M
register_id	uuid	M

tax

repson_

idvarcharO

national_id

varcharO

passport

varcharO

birth_certificate

varcharO

temporary_certificate

varcharO

type	enum('')	M
type	DICTIONARY='DOCUMENT_TYPE'	M
number	varchar	M
status	enum (processing, matched, not_found)	M
inserted_at	uuid	M
inserted_by	timestamp	M
updated_at	uuid	M
updated_by	timestamp	M

JSONB structures

Address

This data type defines address structure

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

Phone

This data type defines Phone structure

Name	Type	M/O	Description and constraints
type	Dictionary: PHONE_TYPE	M
number	string	M

Document

This data type defines Document structure

Name	Type	M/O
type	Dictionary: DOCUMENT_TYPE	M
number	string	M
issued_at	date	O
issued_by	string	O

Emergency_contact

Name	Type	M/O
first_name	string	M
last_name	string	M
second_name	string	O
phones	jsonb []	M

Confidant_person

Name	Type	M/O
type	enum: [PRIMARY, SECONDARY]	M
first_name	string	M
last_name	string	M
second_name	string	O
birth_date	date	M
birth_country	Dictionary: COUNTRY	M
birth_settlement	string	M
gender	string	M
tax_id	string	M
secret	string	O
documents_person	Document: jsonb[ ]	M
documents_relationship	Document: jsonb[ ]	M
phones	Phone: jsonb[ ]	M

Authentification_method

Name	Type	M/O	Description and constraints
type	enum['OFFLINE'/'MOBILE_PHONE']	M
number	string	O

Education

Name	Type	M/O
country	Dictionary: COUNTRY	M
city	varchar	M
institution_name	varchar	M
issued_date	date	O
diploma_number	varchar	M
degree	Dictionary: EDUCATION_DEGREE	M
speciality	varchar	M

Qualification

Name	Type	M/O
type	Dictionary: QUALIFICATION_TYPE	M
institution_name	varchar	M
speciality	varchar	M
issued_date	date	O
certificate_number	varchar	O
valid_to	date	O
additional_info	varchar	O

Specialities

Name	Type	M/O
type	Dictionary: SPECIALITY_TYPE	M
level	Dictionary: SPECIALITY_LEVEL	M
qualification_type	Dictionary: SPEC_QUALIFICATION_TYPE	M
attestation_name	varchar	M
attestation_date	date	M
valid_to_date	date	O
certificate_number	varchar	M

Speciality

Name	Type	M/O	Description and constraints
type	Dictionary: SPECIALITY_TYPE	M
speciality_officio

boolean

true	M
level	Dictionary: SPECIALITY_LEVEL	M
qualification_type	Dictionary: SPEC_QUALIFICATION_TYPE	M
attestation_name	varchar	M
attestation_date	date	M
valid_to_date	date	O
certificate_number	varchar	M

Science_degree

Name	Type	M/O
country	Dictionary: COUNTRY	M
city	name	M
degree	Dictionary: SCIENCE_DEGREE	M
institution_name	varchar	M
diploma_number	varchar	M
speciality	date

M

Properties

NameTypeM/ODescription and constraintslimitnumberMcounternumber

M

Versions Compared

Old Version 8

New Version Current

Key

...
name erd_example_v5.pdf
height 250

Table of Contents

ERD

Data structures

PERSONS

PARTIES

EMPLOYEES

USERS

OPEN_IDS

LEGAL_ENTITIES

DIVISIONS

REGISTERS

JSONB structures

Address

Phone

Document

Confidant_person

Authentification_method

Archive

Education

Qualification

Specialities

Speciality

Science_degree

Properties

Page Comparison

Versions Compared

Old Version 8

New Version Current

Key

<span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-0">[data-colorid=</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-2">e7223ivj6m</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-3">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-4">e7223ivj6m</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-5">]{color:</span>

Table of ContentsERD

Data structures

PERSONS

PARTIES

EMPLOYEES

USERS

OPEN_IDS

LEGAL_ENTITIES

DIVISIONS

REGISTERS

JSONB structures

Address

Phone

Document

Confidant_person

Authentification_method

Archive

Education

Qualification

Specialities

Speciality

Science_degree

Properties

Table of Contents

ERD