Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int4 |
|
|
|
| gst | bool |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| profile_id | int4 |
|
|
|
| avatar | varchar |
|
|
|
| archived_at | timestamp |
|
|
|
| note | text |
|
|
|
| abn | varchar |
|
|
|
| company_name | varchar |
|
|
|
| agreement_id | int8 |
|
|
|
| company_id | int8 |
|
|
|
| engagement_type | varchar |
|
|
|
| role_helper | bool |
|
|
|
| role_supplier | bool |
|
|
|
| role_clinician | bool |
|
|
|
| flagged_by_admin | bool |
|
|
|
| bio_prompts | jsonb |
|
|
|
| provider_travel_chargeable | bool |
|
|
|
| client_transport_chargeable | bool |
|
|
|
| availability_note | text |
|
|
|
| opportunity_filter | text |
|
|
|
| employee_type | varchar |
|
|
|
| weekly_capacity | interval |
|
|
|
| pending_at | timestamp |
|
|
|
| pending_reason | text |
|
|
|
| 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 |