Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| beginning_at | timestamp |
|
|
A timestamp that is when the shift begins. Value is in UTC. |
| paid | bool |
|
|
Whether or not the break is paid or unpaid. |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| verified_at | timestamp |
|
|
This value is added when the care worker marks the break as taken or skipped. |
| skipped_reason | varchar |
|
|
The reason for skipping the break. |
| duration | interval |
|
|
How long the break is set for. Value is in minutes. |
| source_type | varchar |
|
|
The source type for this break. @example: Visit, Shift, or null. When the source is a visit, the break is known as in-visit breaks. This is used in combination with source_id. |
| source_id | int8 |
|
|
The source id for this break. It’s used in combination with source_type. |
| helper_id | int8 |
|
|
The foreign key to the care worker record that owns the break. |
| company_id | int8 |
|
|
|
| recurrence_id | int8 |
|
|
The foreign key to the recurrence record. If null, the break is one-off. When present, the break is recurring. |
| beginning_at_in_company_tz | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| verified_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_shift_breaks_pkey | Primary key | Asc | id |