# Toggl Track schema ERD

Table and field reference for the Fivetran Toggl Track connector.

## 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 | PK, FK |
| archived | Unknown |  |
| name | Unknown |  |
| server_deleted_at | Unknown |  |
| update_at | Unknown |  |

### workspace_project_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| group_id | Unknown | FK |
| project_id | Unknown | FK |

### group_user

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| avatar_url | Unknown |  |
| joined | Unknown |  |
| name | Unknown |  |

### group_workspace

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |
| updated_at | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| 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 | PK, FK |
| time_entry_id | Unknown | PK, FK |

### 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 | PK, FK |
| user_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Unknown | PK |
| user_id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| 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 | PK, FK |
| deleted_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### project_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| 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 | PK, FK |
| start_date | Unknown | PK, FK |
| timesheet_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| active | Unknown |  |
| avatar_url | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |

### timesheet_error

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| timesheet_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| code | Unknown |  |
| message | Unknown |  |

### timesheet_review

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| timesheet_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- client(workspace_id) → workspace(id)
- workspace_project_group(workspace_id) → workspace(id)
- workspace_project_group(project_id) → project(id)
- workspace_project_group(group_id) → groups(id)
- group_user(user_id) → users(user_id)
- group_user(group_id) → groups(id)
- group_workspace(workspace_id) → workspace(id)
- group_workspace(group_id) → groups(id)
- groups(organization_id) → organization(id)
- project(workspace_id) → workspace(id)
- project(client_id) → client(id)
- time_entry_tag(tag_id) → tags(id)
- time_entry_tag(time_entry_id) → time_entry(id)
- time_entry(user_id) → users(user_id)
- time_entry(task_id) → task(id)
- time_entry(project_id) → project(id)
- users_group(group_id) → groups(id)
- users_group(user_id) → users(user_id)
- users(workspace_id) → workspace(id)
- tags(workspace_id) → workspace(id)
- project_user(project_id) → project(id)
- project_user(user_id) → users(user_id)
- project_user(workspace_id) → workspace(id)
- project_user(group_id) → groups(id)
- timesheet_approver(user_id) → users(user_id)
- timesheet_approver(timesheet_id) → timesheet(id)
- timesheet_approver(start_date) → timesheet(start_date)
- timesheet_approver(member_id) → timesheet(member_id)
- timesheet_approver(workspace_id) → timesheet(workspace_id)
- timesheet_error(timesheet_id) → timesheet(id)
- timesheet_error(start_date) → timesheet(start_date)
- timesheet_error(member_id) → timesheet(member_id)
- timesheet_error(workspace_id) → timesheet(workspace_id)
- timesheet_review(user_id) → users(user_id)
- timesheet_review(timesheet_id) → timesheet(id)
- timesheet_review(start_date) → timesheet(start_date)
- timesheet_review(member_id) → timesheet(member_id)
- timesheet_review(workspace_id) → timesheet(workspace_id)
- timesheet(workspace_id) → workspace(id)
- task(user_id) → users(user_id)
- task(workspace_id) → workspace(id)
- task(project_id) → project(id)
- organization(id) → workspace(organization_id)