Shift Times
The shift_times table contains data about shift times tied to shifts, which are tied to shift fields attached to entities in the organization .
This table can be used to determine what shift times are allocated to what shifts, as well as metadata about the shift time such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| day_of_week | The day of the week this shift time is for. One of monday, tuesday, wednesday, thursday, friday, saturday, or sunday. |
VARCHAR | Yes |
| start_time | The start time of the shift. | VARCHAR | Yes |
| end_time | The end time of the shift. | VARCHAR | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was last updated. | TIMESTAMP | No |
| shift_id | The numerical identifier of the shift this time is connected to. Relates to the id column in the shifts table. |
INT8 | Yes |