Entities (tables)

Legal entity

This entity defines Parties information structure

Name	Type	M/O
last_name	string	M
first_name	string	M
second_name	string	O
birth_date	string	M
gender	string Dictionary: GENDER	M
tax_id	string	M
documents	Document: jsonb[]	M
phones	Phone: jsonb[]	M
inserted_at	timestamp	M
inserted_by	uuid	M
updated_at	timestamp	M
updated_by	uuid	M

This entity defines Employees information structure

Name	Type	M/O
legel_entity_id	uuid	M
party_id	uuid	M
division_id	uuid	O
position	Dictionary: Position	M
start_date	date	M
end_date	date	M
inserted_at	timestamp	M
inserted_by	uuid	M
updated_by	uuid	M
updated_at	timestamp	M
status	enum Status Charts	M
employee_type	Dictionary: EMPLOYEE_TYPE	M
additional_info	JSON	M

This entity defines DOCTOR information structure

Name	Type	M/O
education	jsonb[]	M
qualification	jsonb[]	O
specialities	jsonb[]	M
science_degree	jsonb[]	O

This entity defines EDUCATION structure

Name	Type	M/O
country	string Dictionary: COUNTRY	M
city	string	M
institution_name	string	M
issued_date	string	O
diploma_number	string	M
degree	string	M
speciality	string	M

This entity defines QUALIFICATION structure

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

This entity defines SPECIALITY structure

Name	Type	M/O
speciality	string Dictionary: SPECIALITY_TYPE	M
speciality_officio	boolean	M
level	string Dictionary: SPECIALITY_LEVEL	M
qualification_type	string Dictionary: SPEC_QUALIFICATION_TYPE	M
attestation_name	string	M
attestation_date	date	M
valid_to_date	date	O
certificate_number	string	M

This entity defines SCIENCE_DEGREE structure

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

This entity defines PHARMACIST information structure

Name	Type	M/O
education	jsonb[]	O
qualification	jsonb[]	O
specialities	jsonb[]	O
science_degree	jsonb[]	O

Doctor and Pharmacist comparable table

	Name	Type	DOCTOR		PHARMACIST
	Name	Type	FLAG	M/O	FALG	M/O
EDUCATION	country	string Dictionary: COUNTRY	1	M
	city	string	1	M
	institution_name	string	1	M
	issued_date	string	1	O
	diploma_number	string	1	M
	degree	string	1	M
	speciality	string	1	M
QULIFICATION	type	string Dictionary: QUALIFICATION_TYPE	1	M
	institution_name	string	1	M
	speciality	string	1	M
	issued_date	date	1	O
	certificate_number	string	1	O
	valid_to	date	1	O
	additional_info	string	1	O
SPECIALITY	speciality	string Dictionary: SPECIALITY_TYPE	1	M
	speciality_officio	boolean	1	M
	level	string Dictionary: SPECIALITY_LEVEL	1	M
	qualification_type	string Dictionary: SPEC_QUALIFICATION_TYPE	1	M
	attestation_name	string	1	M
	attestation_date	date	1	M
	valid_to_date	date	1	O
	certificate_number	string	1	M
SCIENCE_DEGREE	country	string Dictionary: COUNTRY	1	M
	city	string	1	M
	degree	string Dictionary: SCIENCE_DEGREE	1	M
	institution_name	string	1	M
	diploma_number	string	1	M
	speciality	string	1	M
	issued_date	date	1	O
ACCREDITATION_CATEGORY	Атестація (вид, присвоєння/підтвердження, категорія (друга, перша, вища), дата отримання, назва органу, що проводив атестацію)		0		1