ERD

See detailed data model here

Data structures

Name		Type	M/O	Capitation vs Reimbursment
id		uuid	M	+
contractor_legal_entity_id		uuid	M	+
contractor_owner_id		uuid	M	+
contractor_base		varchar (255)	M	+
contractor_payment_details		jsonb	M	+
	bank_name	varchar (255)	M	+
	MFO	varchar (255)	O	+
	payer_account	varchar (255)	M	+
contractor_rmsp_amount		integer	M	-
external_contractor_flag		boolean	O	-
external_contractors		jsonb	O	-
contractor_employee_divisions		jsonb	O	-
contractor_divisions		uuid[]	M	+
start_date		date	M	+
end_date		date	M	+
nhs_legal_entity_id		uuid	O	+
nhs_signer_id		uuid	O	+
nhs_signer_base		varchar (255)	O	+
assignee_id		uuid	O	+
issue_city		varchar (255)	O	+
status		varchar (255)	M	+
status_reason		text	O	+
nhs_contract_price		double precision	O	-
nhs_payment_method		varchar (255)	O	+
nhs_signed_date		date	O	+
previous_request_id		uuid	O	+
misc		text	O	+
contract_number		varchar (255)	O	+
contract_id		uuid	O	+
parent_contract_id		uuid	O	+
printout_content		text	O	+
data		jsonb	O	+
id_form		varchar (255)	M	+
inserted_by		uuid	M	+
inserted_at		timestamp	M	+
updated_by		uuid	M	+
updated_at		timestamp	M	+
medical_programs		uuid[]	M	+
type		varchar(255)	M	+
contractor_signed		boolean	M	+

Name		Type	M/O	Capitation vs Reimbursment
id		uuid	M	+
start_date		date	M	+
end_date		date	M	+
status		varchar (255)	M	+
status_reason		text	O	+
contractor_legal_entity_id		uuid	M	+
contractor_owner_id		uuid	M	+
contractor_base		varchar (255)	M	+
contractor_payment_details		jsonb	M	+
	bank_name	varchar (255)
	MFO	varchar (255)
	payer_account	varchar (255)
contractor_rmsp_amount		integer	M	-
external_contractor_flag		boolean	O	-
external_contractors		jsonb	O	-
nhs_legal_entity_id		uuid	M	+
nhs_signer_id		uuid	M	+
nhs_payment_method		varchar (255)	M	+
nhs_signer_base		varchar (255)	M	+
issue_city		varchar (255)	M	+
nhs_contract_price		double precision	M	-
contract_number		varchar (255)	M	+
contract_request_id		uuid	M	+
is_suspended		boolean	M	+
is_active		boolean	M	+
id_form		varchar (255)	M	+
inserted_by		uuid	M	+
inserted_at		timestamp	M	+
updated_by		uuid	M	+
updated_at		timestamp	M	+
parent_contract_id		uuid
nhs_signed_date		date
type		varchar (255)
reason		text
signed_content_location		varchar (255)
skip_provision_deactivation		boolean

Name	Type	M/O
id	uuid	M
employee_id	uuid	M
staff_units	number	M
declaration_limit	number	M
division_id	number	M
contract_id	uuid	M
start_date	date	M
end_date	date	O
inserted_by	uuid	M
inserted_at	timestamp	M
updated_by	uuid	M
updated_at	timestamp	M

Name	Type	M/O
id	uuid	M
division_id	number	M
contract_id	uuid	M
inserted_by	uuid	M
inserted_at	timestamp	M
updated_by	uuid	M
updated_at	timestamp	M

Name	Type	M/O
payer_account	varchar	M
MFO	varchar	M
bank_name	varchar	M

Name	sub_fields	Type	M/O	Description
legal_entity_id		uuid	M	external_contractor_id
contract{}		object	M
	number	varchar	M
	issued_at	timestamp	M
	expires_at	timestamp	M
divisions[{}]		array	M
	id	uuid	M
	medical_service	DICTIONARY	M

Name	Type	M/O
employee_id	uuid	M
staff_units	number	M
declaration_limit	number	M
division_id	uuid	M

Атрибут	Значення	Тип
id	Ідентифікатор атрибуту	uuid
medical_program_id	Ідентифікатор атрибуту	uuid
contract_id	Ідентифікатор атрибуту	uuid
inserted_by	Ідентифікатор особи, що внесла запис до системи	uuid
updated_by	Ідентифікатор особи, що редагувала запис в системі	uuid
inserted_at	Коли було внесено запис до системи	timestamp
updated_at	Коли було відредаговано	timestamp