Table of Contents |
---|
Global budget
Contract
Name | Type | M/O | |||
---|---|---|---|---|---|
id | uuid | M | |||
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 | now() timestamplocation | varchar | M | ||
inserted_by | user from api-key | M | |||
updated_at | now() timestamp | M | |||
updated_by | user from api-key | M |
Contract division
...
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 |
start_date | date | O |
end_date | date | O |
staff_units | float | O |
declaration_limit | integer | O |