Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int4 |
|
|
|
| gst | bool |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| profile_id | int4 |
|
|
|
| avatar | varchar |
|
|
|
| archived_at | timestamp |
|
|
|
| agreement_id | int8 |
|
|
|
| company_id | int8 |
|
|
|
| engagement_type | varchar |
|
|
|
| role_helper | bool |
|
|
|
| role_supplier | bool |
|
|
|
| role_clinician | bool |
|
|
|
| flagged_by_admin | bool |
|
|
|
| provider_travel_chargeable | bool |
|
|
|
| client_transport_chargeable | bool |
|
|
|
| opportunity_filter | text |
|
|
|
| employee_type | varchar |
|
|
|
| weekly_capacity | interval |
|
|
|
| pending_at | timestamp |
|
|
|
| hide_product_prices | bool |
|
|
|
| vendor_contact_id | int8 |
|
|
The vendor_contact id. @example 1. |
| archive_reason_id | int8 |
|
|
The archive reason id. @example 1. |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| archived_at_in_company_tz | timestamp |
|
|
|
| pending_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_helpers_pkey | Primary key | Asc | id |
| edge_helpers_agreement_id_idx | Performance | Asc | agreement_id |
| edge_helpers_archive_reason_id_idx | Performance | Asc | archive_reason_id |
| edge_helpers_company_id_idx | Performance | Asc | company_id |
| edge_helpers_profile_id_idx | Performance | Asc | profile_id |
| edge_helpers_vendor_contact_id_idx | Performance | Asc | vendor_contact_id |