Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| helper_id | int8 |
|
|
The foreign key to the care worker record that owns the shift. |
| recurrence_id | int8 |
|
|
The foreign key to the recurrence record. If null, the shift is one-off. When present, the shift is recurring. |
| company_id | int8 |
|
|
|
| beginning_at | timestamp |
|
|
A timestamp that is when the shift begins. Value is in UTC. |
| award_processing_status | varchar |
|
|
Status of the award conditions calculation for this shift @example: pending, complete |
| ending_at | timestamp |
|
|
A timestamp that is when the shift begins. Value is in UTC. |
| award_last_processed_at | timestamp |
|
|
A timestamp representing when the award conditions for this shift were last calculated. Value is in UTC. |
| locked_at | timestamp |
|
|
UTC timestamp for when the shift was locked. Locked shifts are ignored by auto shift adjustment services. @example 2024-01-01 00:00:00.000000 |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| beginning_at_in_company_tz | timestamp |
|
|
|
| ending_at_in_company_tz | timestamp |
|
|
|
| award_last_processed_at_in_company_tz | timestamp |
|
|
|
| locked_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_shifts_pkey | Primary key | Asc | id |