Table of Contents |
---|
...
Name | Type | M/O | Description and constraints |
---|---|---|---|
id | uuid | M | |
start_date | date | M | |
end_date | date | M | |
status | varchar | 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 | varchar | M | |
nhs_payment_details | jsonb | M | |
nhs_signer_base | varchar | M | |
issue_city | varchar | M | |
nhs_contract_price | numberdouble precision | M | |
contract_number | varchar | M | |
contract_request_id | uuid | M | |
is_suspended | boolean | M | |
is_active | boolean | M | |
inserted_by | uuid | M | |
inserted_at | timestamp | M | |
updated_by | uuid | M | |
updated_at | timestamp | M |
CONTRACT_EMPLOYEES
...