Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| duration | interval |
|
|
The duration in minutes. @example: ‘15’ |
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| membership_id | int8 |
|
|
The id of the membership associated with the time tracking log. @example ‘1’ |
| created_by_id | int8 |
|
|
The foreign key to the profile which created the record. @example 1 |
| source_type | varchar |
|
|
The type of the optional underlying source. @example: Ticket |
| source_id | int8 |
|
|
The id of the optional underlying source. @example: Ticket |
| product_id | int8 |
|
|
The foreign key to the product for the record. @example 1 |
| invoiced_at | timestamp |
|
|
The time this time tracking log was invoiced at. @example 2025-07-01T00:00:00Z |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| took_place_on | date |
|
|
The date on which the tracked time took place. @example: 2025-08-06 |
| sah_funding_source | varchar |
|
|
The Support at Home funding source for care management. @example ‘RC’ |
| external_system_id | varchar |
|
|
An optional id to cross reference with another system. @example ABC-123 |
| person_involved_id | int8 |
|
|
The id of the person to whom this time tracking relates. Will generally be the member, but may be authorised representative, billing recipient, etc. @example 1 |
| invoiced_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) |
|---|---|---|---|
| 02bc094b17ee53fd720389d020ad942b | Performance | Asc | external_system_id |
| 2bd504ebb72ef3ca850723129bb9fdda | Performance | Asc | source_id |
| 4a48c1e2b2292f04c8e8aad73ecd8ac1 | Performance | Asc | membership_id |
| 51e08611e5e49c6be3e2d7ade62ca774 | Performance | Asc | company_id |
| 8870e7553b04894f61440ba38c8f5294 | Performance | Asc | product_id |
| 9a0ddec4eaf3f1ce50e5fce814228a65 | Performance | Asc | created_by_id |
| efd72adb5ffabab3cb47dad7a1aae435 | Performance | Asc | person_involved_id |