Toggl Track
Explore the interactive ERD
Table & Field Reference
workspace
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
admin | Unknown | |
business_ws | Unknown | |
constraint_description_present | Unknown | |
constraint_project_present | Unknown | |
constraint_tag_present | Unknown | |
constraint_task_present | Unknown | |
constraint_time_entry_constraints_enabled | Unknown | |
csv_upload_at | Unknown | |
csv_upload_log_id | Unknown | |
default_currency | Unknown | |
default_hourly_rate | Unknown | |
ical_enabled | Unknown | |
ical_url | Unknown | |
logo_url | Unknown | |
name | Unknown | |
only_admins_may_create_projects | Unknown | |
only_admins_may_create_tags | Unknown | |
only_admins_see_billable_rates | Unknown | |
only_admins_see_team_dashboard | Unknown | |
organization_id | Unknown | |
premium | Unknown | |
profile | Unknown | |
projects_billable_by_default | Unknown | |
rate_last_updated | Unknown | |
reports_collapse | Unknown | |
rounding | Unknown | |
rounding_minutes | Unknown | |
server_deleted_at | Unknown | |
subscription_auto_renew | Unknown | |
subscription_card_details | Unknown | |
subscription_company_id | Unknown | |
subscription_contact_detail | Unknown | |
subscription_created_at | Unknown | |
subscription_currency | Unknown | |
subscription_customer_id | Unknown | |
subscription_deleted_at | Unknown | |
subscription_last_pricing_plan_id | Unknown | |
subscription_organization_id | Unknown | |
subscription_payment_details | Unknown | |
subscription_pricing_plan_id | Unknown | |
subscription_renewal_at | Unknown | |
subscription_subscription_id | Unknown | |
subscription_subscription_period | Unknown | |
subscription_workspace_id | Unknown | |
suspended_at | Unknown | |
updated_at | Unknown | |
working_hours_in_minutes | Unknown |
client
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
archived | Unknown | |
name | Unknown | |
server_deleted_at | Unknown | |
update_at | Unknown |
workspace_project_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
group_id | Unknown | FK |
project_id | Unknown | FK |
group_user
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
avatar_url | Unknown | |
joined | Unknown | |
name | Unknown |
group_workspace
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
name | Unknown | |
updated_at | Unknown |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
client_id | Unknown | FK |
active | Unknown | |
actual_hours | Unknown | |
auto_estimates | Unknown | |
billable | Unknown | |
color | Unknown | |
created_at | Unknown | |
currency | Unknown | |
current_period | Unknown | |
estimated_hours | Unknown | |
fixed_fee | Unknown | |
is_private | Unknown | |
name | Unknown | |
rate | Unknown | |
rate_last_updated | Unknown | |
recurring | Unknown | |
recurring_parameters | Unknown | |
server_deleted_at | Unknown | |
template | Unknown | |
updated_at | Unknown |
time_entry_tag
| Column | Type | Keys |
|---|---|---|
tag_id | Unknown | PKFK |
time_entry_id | Unknown | PKFK |
time_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
task_id | Unknown | FK |
user_id | Unknown | FK |
billable | Unknown | |
billable_amount_in_cents | Unknown | |
currency | Unknown | |
description | Unknown | |
hourly_rate_in_cents | Unknown | |
seconds | Unknown | |
start | Unknown | |
stop | Unknown | |
updated_at | Unknown | |
username | Unknown |
users_group
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
organization_id | Unknown | PK |
user_id | Unknown | PK |
workspace_id | Unknown | PKFK |
active | Unknown | |
avatar_file_name | Unknown | |
email | Unknown | |
id | Unknown | |
invitation_code | Unknown | |
invite_url | Unknown | |
is_admin | Unknown | |
is_direct | Unknown | |
is_inactive | Unknown | |
labour_cost | Unknown | |
name | Unknown | |
organization_admin | Unknown | |
rate | Unknown | |
rate_last_updated | Unknown | |
timezone | Unknown | |
updated_at | Unknown | |
working_hours_in_minutes | Unknown | |
workspace_admin | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
deleted_at | Unknown | |
name | Unknown | |
updated_at | Unknown |
project_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
group_id | Unknown | FK |
project_id | Unknown | FK |
user_id | Unknown | FK |
manager | Unknown |
timesheet_approver
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
start_date | Unknown | PKFK |
timesheet_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
user_id | Unknown | FK |
active | Unknown | |
avatar_url | Unknown | |
deleted | Unknown | |
name | Unknown |
timesheet_error
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
start_date | Unknown | PKFK |
timesheet_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
code | Unknown | |
message | Unknown |
timesheet_review
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
start_date | Unknown | PKFK |
timesheet_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
user_id | Unknown | FK |
approved | Unknown | |
avatar_url | Unknown | |
force_approved | Unknown | |
name | Unknown | |
rejection_comment | Unknown | |
updated_at | Unknown |
timesheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PK |
start_date | Unknown | PK |
workspace_id | Unknown | PKFK |
approved_or_rejected_at | Unknown | |
approved_or_rejected_id | Unknown | |
approved_or_rejected_name | Unknown | |
approver_avatar_url | Unknown | |
approver_id | Unknown | |
approver_name | Unknown | |
approvers_layers | Json | |
end_date | Unknown | |
member_avatar_url | Unknown | |
member_name | Unknown | |
period_editable | Unknown | |
period_end | Unknown | |
period_locked | Unknown | |
period_start | Unknown | |
periodicity | Unknown | |
permission | Json | |
rejection_comment | Unknown | |
reminder_day | Unknown | |
reminder_sent_at | Unknown | |
reminder_time | Unknown | |
review_layer | Unknown | |
status | Unknown | |
submitted_at | Unknown | |
timezone | Unknown | |
working_hours_in_minutes | Unknown |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
project_id | Unknown | FK |
user_id | Unknown | FK |
active | Unknown | |
estimated_seconds | Unknown | |
name | Unknown | |
recurring | Unknown | |
server_deleted_at | Unknown | |
tracked_seconds | Unknown | |
updated_at | Unknown |
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
created_at | Unknown | |
is_admin | Unknown | |
is_multi_workspace_enabled | Unknown | |
is_trial | Unknown | |
is_trial_available | Unknown | |
is_unified | Unknown | |
last_pricing_plan_id | Unknown | |
max_workspace | Unknown | |
modified_at | Unknown | |
name | Unknown | |
next_payment_date | Unknown | |
owner | Unknown | |
payment_methods | Unknown | |
pricing_plan_id | Unknown | |
server_deleted_at | Unknown | |
suspended_at | Unknown | |
trial_end_date | Unknown | |
user_count | Unknown |