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 |
|
|
|
archive_reason | varchar |
|
|
|
company_id | int8 |
|
|
The owning tenant’s ID. @example 1. |
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 |
|
|
|
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 |
|
|