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 | |
is_active | boolean | M | |
id_form | varchar | M | |
parent_contract_id | uuid | O | |
nhs_signed_date | date | M | |
medical_program_id | uuid | M | |
inserted_at | now() timestamp | M | |
inserted_by | user from api-key | M | |
updated_at | now() timestamp | M | |
updated_by | user from api-key | M | |
signed_content_location | varchar | O | |
Contract division
Name | Type | M/O |
|---|---|---|
id | uuid | M |
division_id | uuid | M |
contract_id | uuid | M |
inserted_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 | M |