Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| interval | varchar |
|
|
How often the target object will recur. @example: weekly, fortnightly, monthly |
| source | varchar |
|
|
The target of this recurrence. @example: shifts, breaks |
| end_date | date |
|
|
The date to stop the recurrence. When null, the recurrence goes on indefinitely. |
| company_id | int8 |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| excluded_dates | _varchar |
|
|
A set of dates that will be skipped when generating recurring objects. |
| 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) |
|---|---|---|---|
| d5a0741ede3c1d398bee288c73b8d685 | Performance | Asc | company_id |