Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Table of Contents

Global budget

Contract

Mnow() timestamp

Name		Type	M/O	id		uuid
type		varchar	M
contractor_legal_entity_id		uuid	M
contractor_owner_id		uuid	M
contractor_base		varchar	M
contractor_payment_details		jsonb	M
	bank_name	varchar	M
	MFO	varchar	O
	payer_account	varchar	M
start_date		date	M
end_date		date	M
status		varchar	M
status_reason		varchar	O
nhs_signer_base		varchar	M
nhs_payment_method		varchar	M
nhs_signer_id		uuid	M
nhs_legal_entity_id		uuid	M
issue_city		varchar	O
contract_number		varchar	M
is_suspended		boolean	M
id_form		varchar	M
parent_contract_id		uuid	O
nhs_signed_date		date	M
medical_program_id		uuid	M
insertedsigned_content_at		location		varchar	M
inserted_by		user from api-key	M
updated_at		now() timestamp	M
updated_by		user from api-key
reason		varchar	O
nhs_contract_price		float	O

Contract division

Name	Type	M/O
division_id	uuid	M
contract_id	uuid	M

Contract

...

employees

Name	Type	M/O
employee_id	uuid	M
division_id	uuid	M
contract_id	uuid	M
insertedstart_at	now() timestamp	M
inserted_by	user from api-key	M
updated_at	now() timestamp	M
updated_by	user from api-key	M
is_active	boolean	Mdate	date	O
end_date	date	O
staff_units	float	O
declaration_limit	integer	O