...
| Name | Type | M/O | Description and constraints | |||||
|---|---|---|---|---|---|---|---|---|
| id | uuid | M | ||||||
| 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 | ||||||
| contractor_employee_divisions | jsonb[] | M | ||||||
| start_date | date | M | ||||||
| end_date | date | M | ||||||
| nhs_legal_entity_id | uuid | O | ||||||
| nhs_signer_id | uuid | O | ||||||
| nhs_signer_base | varchar | O | ||||||
| issue_city | varchar | O | ||||||
| status | NEW, DECLINED, APPROVED, SIGNED, TERMINATED | M | ||||||
| status_reason | varchar | O | ||||||
| nhs_contract_price | number | O | ||||||
| nhs_payment_method | DICTIONARY | O | ||||||
| contract_number | varchar | O | ||||||
| contract_id | uuid | O | ||||||
| printout_content | varchar | O | ||||||
| data | jsonb | O | ||||||
| id_form | DICTIONARY | M | nhs_signed | |||||
| boolean | O | contractor_signed | boolean | O | inserted_by | uuid | M | |
| inserted_at | timestamp | M | ||||||
| updated_by | uuid | M | ||||||
| updated_at | timestamp | M |
...