Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| helper_leave_period_id | int8 |
|
|
|
| actor_id | int8 |
|
|
|
| actioned_at | timestamp |
|
|
|
| previous_status | varchar |
|
|
|
| new_status | varchar |
|
|
|
| note | text |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| company_id | int8 |
|
|
The owning tenant’s ID. @example 1. |
| actioned_at_in_company_tz | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 0ca75b17ccd45b48b813169755016f3a | Performance | Asc | company_id |
| 2d5fb13c0fc437c0f5351a6f4a8d4df5 | Performance | Asc | actor_id |
| 87bd65c5cf1049e74273825420f30387 | Performance | Asc | helper_leave_period_id |