Time Tracking Schema

ext_timetracking - Time Tracking

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

---

projects

Time tracking projects.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
customer_id	uuid	YES	—
name	text	NO	—
description	text	YES	—
color	text	YES	'#6366f1'
hourly_rate	numeric	YES	0
is_billable	boolean	YES	true
is_active	boolean	YES	true
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

time_entries

Individual time log entries.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
project_id	uuid	YES	—
customer_id	uuid	YES	—
date	date	NO	CURRENT_DATE
start_time	timestamptz	YES	—
end_time	timestamptz	YES	—
duration_minutes	integer	NO	0
description	text	YES	—
is_billable	boolean	YES	true
hourly_rate	numeric	YES	0
invoiced	boolean	YES	false
invoice_id	uuid	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

timer_state

Active timer state.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
project_id	uuid	YES	—
customer_id	uuid	YES	—
description	text	YES	—
started_at	timestamptz	NO	now()
elapsed_seconds	integer	NO	0
is_paused	boolean	YES	false
created_at	timestamptz	NO	now()

settings

Time tracking user settings.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
default_hourly_rate	numeric	YES	0
rounding_increment	integer	YES	1
week_start	integer	YES	1
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()