Table of Contents

ERD

...

Name	Type	M/O	Capitation vs Reimbursment
id	uuid	M	+
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	-
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	+
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	+
medical_program_id	uuid	О	new
contract_type	reimbursement/ capitation	M	new

...

Name	Type	M/O	Capitation vs Reimbursment
id	uuid	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	+
program_id	uuid	О	new
contract_type	reimbursement/ capitation	M	new

...

Versions Compared