Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| description | varchar |
|
|
The description of the cancelation reason. @example: ‘Helper unwell’ |
| code | varchar |
|
|
String identifier for legacy cancellation reasons. Used for API compatibility and internal system use. Custom records will leave this blank. @example: ‘helper_absent’ |
| helper_selectable | bool |
|
|
Whether a helper can select this reason. @example: true @example: false |
| member_selectable | bool |
|
|
Whether a member can select this reason. @example: true @example: false |
| ticket_template_id | int8 |
|
|
Foreign key to the ticket template that should be used to create a ticket when this cancellation reason is used. NULL indicates that a ticket should not be created. @example: 1 |
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| archived_at | timestamp |
|
|
When this visit cancelation reason was archived. @example 2025-01-15 10:30:00 |
| observation_category_id | int8 |
|
|
The observation category id. @example 1. |
| helper_description | varchar |
|
|
Optional, helper-facing version of the cancelation reason. Shown to helpers instead of the admin-facing text. @example ‘I am unwell’ (vs admin-facing ‘The helper is unwell’). |
| member_description | varchar |
|
|
Optional, member-facing version of the cancelation reason. Shown to members instead of the admin-facing text. @example ‘I am unwell’ (vs admin-facing ‘The member is unwell’). |
| reporting_code | varchar |
|
|
Optional non-unique code for external reporting systems @example ‘external system id’ |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| archived_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_visit_cancelation_reasons_pkey | Primary key | Asc | id |