Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| helper_leave_period_id | int8 |
|
|
A unique ID assigned to each helper leave period, E.g. 19. |
|||
| helper_id | int8 |
|
|
The ID of the helper taking leave, E.g. 14. |
|||
| reason_name | varchar |
|
|
The name of the leave reason, E.g. “Annual leave”. |
|||
| reason_reporting_code | varchar |
|
|
The reporting code for the leave reason, E.g. “A/L”. |
|||
| time_range | tsrange |
|
|
The time range of the leave period, E.g. 2021-03-02 00:15:49.000000 - 2021-03-17 22:59:01.999999. |
|||
| created_at | timestamp |
|
|
The time that the leave period was created in UTC, E.g. 2021-03-02 00:15:49.996204. |
|||
| updated_at | timestamp |
|
|
The time that the leave period was updated in UTC, E.g. 2021-03-02 00:15:49.996204. |
|||
| status | varchar |
|
|
The status of the leave period. One of: pending, approved, declined, cancelled. |
|||
| supersedes_helper_leave_period_id | int8 |
|
|
The ID of the leave period that this leave period supersedes, E.g. 19. |
|||
| ticket_id | int8 |
|
|
The ID of the ticket associated with the leave period, E.g. 123. |
|||
| company_id | int8 |
|
|
The company ID, E.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_helper_leave_periods_pkey | Primary key | Asc | helper_leave_period_id |
| fct_helper_leave_periods_company_id_idx | Performance | Asc | company_id |
| fct_helper_leave_periods_helper_id_idx | Performance | Asc | helper_id |
| fct_helper_leave_periods_ticket_id_idx | Performance | Asc | ticket_id |