Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| created_by_id | int8 |
|
|
The foreign key to the profile of the staffer who created the period. @example 1 |
| time_range | tsrange |
|
|
The time range representing the period the statements will represent. @example 2025-01-01T00:00:00Z to 2025-02-01T00:00:00Z |
| status | varchar |
|
|
The status of the statements. @example preparing |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| statements_emailed_at | timestamp |
|
|
A UTC timestamp indicating when statements where emailed, or nil. @example 2025-04-24 06:56:46.656280 |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| statements_emailed_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 0e2780e8c3912983ce2649e3a8c35dc1 | Performance | Asc | company_id |
| f628b06b11983fdcc8fac25e904a6ded | Performance | Asc | created_by_id |