ЕСОЗ - публічна документація

Third Party Contract Data Models

Owned by Vadim Maslovskiy (Deactivated)

Last updated: Aug 28, 2020

1 min read

1 Global budget
- 1.1 Contract
- 1.2 Contract division
- 1.3 Contract employees

Global budget

Contract

Name		Type	M/O

Name		Type	M/O
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
signed_content_location		varchar	M
reason		varchar	O
nhs_contract_price		float	O

Contract division

Name	Type	M/O

Name	Type	M/O
division_id	uuid	M
contract_id	uuid	M

Contract employees

Name	Type	M/O

Name	Type	M/O
employee_id	uuid	M
division_id	uuid	M
contract_id	uuid	M
start_date	date	O
end_date	date	O
staff_units	float	O
declaration_limit	integer	O

ЕСОЗ - публічна документація