Table of Contents

ERD

...

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
parent_contract_id	uuid	O
type	varchar	M
reason	string	O
signed_content_location	varchar	M
contractor_base	varchar	O

CONTRACT_EMPLOYEES

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

...