Shifts
The shifts table contains data about shifts, which are tied to shift fields attached to entities in the organization .
This table can be used to determine what shifts are attached to which shift fields, as well as metadata about the shift such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| target_type | The name of the class of object this shift is attached to. Always TaggableLogbook. |
VARCHAR | Yes |
| target_id | The numerical identifier of the related piece of info for this shift. Relates to the id column in the taggable_logbooks table. |
INT8 | Yes |
| created_by_id | The numerical identifier of the user that created this shift. Relates to the id column in the users table. An ID of 1 typically means a machine-created shift, such as over the API. |
INT8 | No |
| deleted_by_id | This column is deprecated and always blank. | INT8 | Yes |
| timezone | The timezone the shift and associated shift times are in, in standard timezone name format. | 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 |