edge_time_tracking_logs


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. Australia/Brisbane.

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

Relationships