Skip to content

Time Tracking Schema

Schema: ext_timetracking | Auto-generated on 2026-03-30


Time tracking projects.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
customer_iduuidYES—
nametextNO—
descriptiontextYES—
colortextYES'#6366f1'
hourly_ratenumericYES0
is_billablebooleanYEStrue
is_activebooleanYEStrue
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Individual time log entries.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
project_iduuidYES—
customer_iduuidYES—
datedateNOCURRENT_DATE
start_timetimestamptzYES—
end_timetimestamptzYES—
duration_minutesintegerNO0
descriptiontextYES—
is_billablebooleanYEStrue
hourly_ratenumericYES0
invoicedbooleanYESfalse
invoice_iduuidYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Active timer state.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
project_iduuidYES—
customer_iduuidYES—
descriptiontextYES—
started_attimestamptzNOnow()
elapsed_secondsintegerNO0
is_pausedbooleanYESfalse
created_attimestamptzNOnow()

Time tracking user settings.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
default_hourly_ratenumericYES0
rounding_incrementintegerYES1
week_startintegerYES1
created_attimestamptzNOnow()
updated_attimestamptzNOnow()