Table of Contents

ERD

See detailed data model here

Data structures

...

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
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

...