Table of Contents

ERD

...

View file
name erd_example_v5.pdf
height 400

Data structures
PERSONS

Name Type M/O Description and constraints 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 Description and constraints 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 Description and constraints 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
jsonbO
properties
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 Description and constraints
id uuid M
person_id uuid M
type varchar M
open_id varchar M

LEGAL_ENTITIES

Name Type M/O Description and constraints 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
type	Dictionary: SPECIALITY_TYPE	M
speciality_officio	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 14

New Version Current

Key

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

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

Page Comparison

Versions Compared

Old Version 14

New Version Current

Key

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