ERD

See detailed data model here

Data structures

Name	Type	M/O	Description and constraints
id	uuid	M
contract_type	capitation, reimbursement	M
contractor_legal_entity_id	uuid	M
contractor_owner_id	uuid	M
contractor_base	varchar (255)	M
contractor_payment_details	jsonb	M
contractor_rmsp_amount	number	M
external_contractor_flag	boolean	O
external_contractors	jsonb[]	O
contractor_employee_divisions	jsonb[]	O
contractor_divisions	array	M
start_date	date	M
end_date	date	M
nhs_legal_entity_id	uuid	O
nhs_signer_id	uuid	O
nhs_signer_base	varchar	O
assignee_id	uuid	O
issue_city	varchar	O
status	NEW, in_PROCESS, DECLINED, APPROVED, PENDING_NHS_SIGN, NHS_SIGNED, SIGNED, TERMINATED	M
status_reason	varchar	O
nhs_contract_price	number	O
nhs_payment_method	DICTIONARY	O
nhs_signed_date	date	O
misc	varchar	O
contract_number	varchar	O
contract_id	uuid	O
parent_contract_id	uuid	O	Reference to parent contract Should be filled for update flow
printout_content	varchar	O
data	jsonb	O
id_form	DICTIONARY	M
inserted_by	uuid	M
inserted_at	timestamp	M
updated_by	uuid	M
updated_at	timestamp	M

Name	Type	M/O
id	uuid	M
~~contract_type~~	capitation, reimbursement	M
start_date	date	M
end_date	date	M
status	enum('TERMINATED', 'VERIFIED')	M
~~status_reason~~	string	O
contractor_legal_entity_id	uuid	M
contractor_owner_id	uuid	M
contractor_base	varchar	M
contractor_payment_details	jsonb	M
contractor_rmsp_amount	number	M
external_contractor_flag	boolean	O
external_contractors	jsonb[]	O
nhs_legal_entity_id	uuid	M
nhs_signer_id	uuid	M
nhs_payment_method	DICTIONARY	M
nhs_signed_date	date	O
~~misc~~	varchar	O
nhs_signer_base	varchar	M
issue_city	varchar	M
nhs_contract_price	number	M
contract_number	varchar	M
contract_request_id	uuid	M
is_suspended	boolean	M
is_active	boolean	M
id_form	DICTIONARY	M
inserted_by	uuid	M
inserted_at	timestamp	M
updated_by	uuid	M
updated_at	timestamp	M
parent_contract_id	uuid	O
type	varchar	M
reason	string	O
signed_content_location	varchar	M
contractor_base	varchar	O

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