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) |
|---|---|---|---|
| edge_time_tracking_logs_pkey | Primary key | Asc | id |
| edge_time_tracking_logs_company_id_idx | Performance | Asc | company_id |
| edge_time_tracking_logs_created_by_id_idx | Performance | Asc | created_by_id |
| edge_time_tracking_logs_external_system_id_idx | Performance | Asc | external_system_id |
| edge_time_tracking_logs_membership_id_idx | Performance | Asc | membership_id |
| edge_time_tracking_logs_person_involved_id_idx | Performance | Asc | person_involved_id |
| edge_time_tracking_logs_product_id_idx | Performance | Asc | product_id |
| edge_time_tracking_logs_source_id_idx | Performance | Asc | source_id |