# Teamwork schema ERD

Table and field reference for the Fivetran Teamwork connector.

## Table & Field Reference

### time_tracking_assigned_team

| Column | Type | Keys |
| --- | --- | --- |
| assigned_team_id | Unknown | PK, FK |
| time_tracking_id | Unknown | PK, FK |

### time_tracking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted_by_user_id | Unknown | FK |
| edited_by_user_id | Unknown | FK |
| logged_by_user_id | Unknown | FK |
| project_billing_invoice_id | Unknown | FK |
| project_id | Unknown | FK |
| task_id | Unknown | FK |
| user_id | Unknown | FK |
| billable | Unknown |  |
| created_at | Unknown |  |
| date_created | Unknown |  |
| date_deleted | Unknown |  |
| date_edited | Unknown |  |
| deleted | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| desk_ticket_id | Unknown |  |
| exchange_rate | Json |  |
| has_start_time | Unknown |  |
| is_billable | Unknown |  |
| minutes | Unknown |  |
| rate | Unknown |  |
| task_id_pre_move | Unknown |  |
| time_logged | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |

### utilization

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| allocated_minute | Unknown |  |
| available_minute | Unknown |  |
| billable_minutes | Unknown |  |
| end_date | Unknown |  |
| estimated_minute | Unknown |  |
| logged_minute | Unknown |  |
| start_date | Unknown |  |
| unavailable_minute | Unknown |  |
| unbillable_minute | Unknown |  |

### notebook

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| project_id | Unknown | FK |
| updated_by | Unknown | FK |
| category_name | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| locked | Unknown |  |
| name | Unknown |  |
| private | Unknown |  |
| updated_date | Unknown |  |
| user_display_updated_date | Unknown |  |
| user_display_updated_time | Unknown |  |
| version | Unknown |  |

### workflow_project

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| workflow_id | Unknown | PK, FK |

### workflow_stage

| Column | Type | Keys |
| --- | --- | --- |
| stage_id | Unknown | PK |
| workflow_id | Unknown | PK, FK |

### workflow_company

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| workflow_id | Unknown | PK, FK |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| created_at | Unknown |  |
| default_workflow | Unknown |  |
| lockdown | Json |  |
| name | Unknown |  |
| project_specific | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### expense

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| created_by | Unknown | FK |
| invoice_id | Unknown | FK |
| project_id | Unknown | FK |
| cost | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### users_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| amount | Unknown |  |
| avatar_url | Unknown |  |
| can_access_portfolio | Unknown |  |
| can_add_projects | Unknown |  |
| can_manage_portfolio | Unknown |  |
| company_role_id | Unknown |  |
| company_type | Unknown |  |
| created_at | Unknown |  |
| created_by_user_id | Unknown |  |
| currency_id | Unknown |  |
| deleted | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_admin | Unknown |  |
| is_client_user | Unknown |  |
| is_placeholder_resource | Unknown |  |
| is_service_account | Unknown |  |
| job_role | Json |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| length_of_day | Unknown |  |
| skill | Json |  |
| timezone | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by_user_id | Unknown |  |
| user_cost | Unknown |  |
| user_rate | Unknown |  |
| working_hours_id | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| color | Unknown |  |
| count | Unknown |  |
| name | Unknown |  |

### clock_in

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| clock_in_datetime | Unknown |  |
| clock_in_info | Unknown |  |
| clock_in_source | Unknown |  |
| clock_out_datetime | Unknown |  |
| clock_out_info | Unknown |  |
| clock_out_source | Unknown |  |
| status | Unknown |  |
| updated_date_time | Unknown |  |

### task_change_follower

| Column | Type | Keys |
| --- | --- | --- |
| change_follower | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_comment_follower

| Column | Type | Keys |
| --- | --- | --- |
| comment_follower | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_complete_follower

| Column | Type | Keys |
| --- | --- | --- |
| complete_follower | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### assignee_user_task

| Column | Type | Keys |
| --- | --- | --- |
| assignee_user_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### assignee_team_task

| Column | Type | Keys |
| --- | --- | --- |
| assignee_team_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_crm_deal

| Column | Type | Keys |
| --- | --- | --- |
| crm_deal | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_sub_task

| Column | Type | Keys |
| --- | --- | --- |
| sub_task_id | Unknown | PK |
| task_id | Unknown | PK, FK |

### task_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_dependency

| Column | Type | Keys |
| --- | --- | --- |
| dependency_id | Unknown | PK |
| task_id | Unknown | PK, FK |

### assignee_company_task

| Column | Type | Keys |
| --- | --- | --- |
| assignee_company_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_predecessor

| Column | Type | Keys |
| --- | --- | --- |
| predecessor_id | Unknown | PK |
| task_id | Unknown | PK, FK |

### task_workflow_stage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| task_id | Unknown | PK, FK |
| stage_id | Unknown | FK |
| workflow_id | Unknown | FK |
| stage_task_display_order | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_task_id | Unknown | FK |
| tasklist_id | Unknown | FK |
| updated_by | Unknown | FK |
| accumulated_estimated_minute | Unknown |  |
| assignee_ids | Unknown |  |
| attachments | Json |  |
| capacity | Unknown |  |
| card | Unknown |  |
| columns | Json |  |
| completed_at | Unknown |  |
| completed_by | Unknown |  |
| completed_on | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| date_updated | Unknown |  |
| decimal_display_order | Unknown |  |
| deleted_at | Unknown |  |
| deleted_by | Unknown |  |
| description | Unknown |  |
| description_content_type | Unknown |  |
| display_order | Unknown |  |
| due_date | Unknown |  |
| due_date_offset | Unknown |  |
| estimate_minutes | Unknown |  |
| has_desk_tickets | Unknown |  |
| has_reminder | Unknown |  |
| is_archived | Unknown |  |
| is_blocked | Unknown |  |
| is_private | Unknown |  |
| latest_update | Json |  |
| lockdown | Unknown |  |
| name | Unknown |  |
| notify | Unknown |  |
| original_due_date | Unknown |  |
| out_of_sequence | Unknown |  |
| priority | Unknown |  |
| progress | Unknown |  |
| proof | Json |  |
| sequence_due_date | Unknown |  |
| sequence_id | Unknown |  |
| sequence_root_task | Unknown |  |
| sequence_start_date | Unknown |  |
| start_date | Unknown |  |
| start_date_offset | Unknown |  |
| status | Unknown |  |
| template_role_name | Unknown |  |
| timer | Unknown |  |
| updated_at | Unknown |  |
| user_permission_can_add_subtasks | Unknown |  |
| user_permission_can_complete | Unknown |  |
| user_permission_can_edit | Unknown |  |
| user_permission_can_log_time | Unknown |  |
| user_permission_can_view_est_time | Unknown |  |
| workflow_stages | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| company_id | Unknown | FK |
| created_by | Unknown | FK |
| financial_budget_id | Unknown | FK |
| time_budget_id | Unknown | FK |
| updated_by | Unknown | FK |
| active_page_billing | Unknown |  |
| active_page_board | Unknown |  |
| active_page_comments | Unknown |  |
| active_page_files | Unknown |  |
| active_page_finance | Unknown |  |
| active_page_forms | Unknown |  |
| active_page_gantt | Unknown |  |
| active_page_links | Unknown |  |
| active_page_list | Unknown |  |
| active_page_messages | Unknown |  |
| active_page_milestones | Unknown |  |
| active_page_notebooks | Unknown |  |
| active_page_proofs | Unknown |  |
| active_page_risk_register | Unknown |  |
| active_page_table | Unknown |  |
| active_page_tasks | Unknown |  |
| active_page_tickets | Unknown |  |
| active_page_time | Unknown |  |
| allow_notify_anyone | Unknown |  |
| announcement | Unknown |  |
| available_deadlines_found | Unknown |  |
| available_max_end_date | Unknown |  |
| available_min_start_date | Unknown |  |
| available_suggested_end_date | Unknown |  |
| available_suggested_start_date | Unknown |  |
| completed_at | Unknown |  |
| completed_by | Unknown |  |
| created_at | Unknown |  |
| custom_field_value | Json |  |
| default_privacy | Unknown |  |
| description | Unknown |  |
| direct_file_uploads_enabled | Unknown |  |
| end_date | Unknown |  |
| harvest_timers_enabled | Unknown |  |
| is_billable | Unknown |  |
| is_on_boarding_project | Unknown |  |
| is_sample_project | Unknown |  |
| latest_activity | Json |  |
| logo | Unknown |  |
| logo_color | Unknown |  |
| logo_icon | Unknown |  |
| name | Unknown |  |
| notify_comment_include_creator | Unknown |  |
| notify_everyone | Unknown |  |
| notify_task_assignee | Unknown |  |
| overview_start_page | Unknown |  |
| owner_id | Unknown |  |
| privacy_enabled | Unknown |  |
| reply_by_email_enabled | Unknown |  |
| show_announcement | Unknown |  |
| skip_weekends | Unknown |  |
| start_date | Unknown |  |
| start_page | Unknown |  |
| status | Unknown |  |
| sub_status | Unknown |  |
| tag_id | Unknown |  |
| tasks_start_page | Unknown |  |
| type | Unknown |  |
| update_id | Unknown |  |
| updated_at | Unknown |  |

### project_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_value_id | Unknown | PK |
| project_id | Unknown | PK |

### project_user

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK |
| user_id | Unknown | PK, FK |

### project_portfolio_card

| Column | Type | Keys |
| --- | --- | --- |
| portfolio_card_id | Unknown | PK |
| project_id | Unknown | PK |

### project_workflow

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK |
| workflow_id | Unknown | PK, FK |

### project_tag

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK |
| tag_id | Unknown | PK |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| for_user_id | Unknown | FK |
| item_id | Unknown | FK |
| project_id | Unknown | FK |
| user_id | Unknown | FK |
| activity_type | Unknown |  |
| datetime | Instant |  |
| description | Unknown |  |
| due_date | Unknown |  |
| extra_description | Unknown |  |
| from_username | Unknown |  |
| is_private | Unknown |  |
| latest_activity_type | Unknown |  |
| link | Unknown |  |
| type | Unknown |  |

### calendar_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| added_by | Unknown |  |
| all_day | Unknown |  |
| assigned_to | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| project | Unknown |  |
| start_date | Unknown |  |
| tags | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| project_id | Unknown | FK |
| category_name | Unknown |  |
| code | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| open_in_new_window | Unknown |  |
| provider | Unknown |  |

### project_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| count | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |

### company_tag

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| project_id | Unknown | FK |
| name | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounts | Unknown |  |
| address_one | Unknown |  |
| address_two | Unknown |  |
| can_see_private | Unknown |  |
| cid | Unknown |  |
| city | Unknown |  |
| clients | Unknown |  |
| collaborator | Unknown |  |
| contacts | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| created_on | Unknown |  |
| email_one | Unknown |  |
| email_three | Unknown |  |
| email_two | Unknown |  |
| fax | Unknown |  |
| industry | Unknown |  |
| industry_id | Unknown |  |
| is_owner | Unknown |  |
| last_changed_on | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| website | Unknown |  |
| zip | Unknown |  |

### tasklist_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| task_list_id | Unknown | PK, FK |
| project_id | Unknown | FK |
| name | Unknown |  |

### task_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_task_id | Unknown | FK |
| milestone_id | Unknown | FK |
| project_id | Unknown | FK |
| calculated_due_date | Unknown |  |
| calculated_start_date | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| display_order | Unknown |  |
| is_billable | Unknown |  |
| is_pinned | Unknown |  |
| is_private | Unknown |  |
| lockdown_id | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| tasklist_budget_id | Unknown |  |
| updated_at | Unknown |  |

### user_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| geo_ip_location | Unknown |  |
| is_clocked_in | Unknown |  |
| last_changed_on | Unknown |  |
| posted_on | Unknown |  |
| status | Unknown |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_user_id | Unknown | FK |
| deleted_by_user_id | Unknown | FK |
| project_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| deleted | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| entity | Unknown |  |
| formula | Unknown |  |
| group_id | Unknown |  |
| is_private | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |
| unit_id | Unknown |  |
| updated_at | Unknown |  |
| visibilities | Json |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| name | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| created_by_user_id | Unknown | FK |
| project_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| can_edit | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| deleted | Unknown |  |
| deleted_date | Unknown |  |
| description | Unknown |  |
| handle | Unknown |  |
| is_private | Unknown |  |
| name | Unknown |  |
| num_direct_children | Unknown |  |
| num_subteams | Unknown |  |
| parent_team_handle | Unknown |  |
| parent_team_id | Unknown |  |
| parent_team_name | Unknown |  |
| root_team_handle | Unknown |  |
| root_team_id | Unknown |  |
| root_team_name | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| milestone_id | Unknown | FK |
| project_id | Unknown | FK |
| body | Unknown |  |
| category_name | Unknown |  |
| content_type | Unknown |  |
| is_read | Unknown |  |
| last_changed_on | Unknown |  |
| last_comment_date | Unknown |  |
| posted_on | Unknown |  |
| private | Unknown |  |
| title | Unknown |  |
| user_display_posted_date | Unknown |  |
| user_display_posted_time | Unknown |  |

### milestone_tasklist

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| milestone_id | Unknown | PK, FK |

### milestone_change_follower

| Column | Type | Keys |
| --- | --- | --- |
| change_follower | Unknown | PK, FK |
| milestone_id | Unknown | PK, FK |

### milestone_comment_follower

| Column | Type | Keys |
| --- | --- | --- |
| comment_follower | Unknown | PK, FK |
| milestone_id | Unknown | PK, FK |

### milestone_responsible_party

| Column | Type | Keys |
| --- | --- | --- |
| milestone_id | Unknown | PK, FK |
| responsible_people | Unknown | PK, FK |

### milestone_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| milestone_id | Unknown | PK, FK |
| project_id | Unknown | FK |
| name | Unknown |  |

### milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| completer_id | Unknown | FK |
| creator_id | Unknown | FK |
| project_id | Unknown | FK |
| can_complete | Unknown |  |
| can_edit | Unknown |  |
| completed | Unknown |  |
| completed_on | Unknown |  |
| created_on | Unknown |  |
| deadline | Unknown |  |
| description | Unknown |  |
| due_date_offset | Unknown |  |
| is_private | Unknown |  |
| last_changed_on | Unknown |  |
| percentage_complete | Unknown |  |
| private | Unknown |  |
| reminder | Unknown |  |
| responsible_party_type | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| user_following_changes | Unknown |  |
| user_following_comments | Unknown |  |

### project_budget_notification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_budget_id | Unknown | PK, FK |
| type | Unknown |  |

### project_budget

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_user_id | Unknown | FK |
| project_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| announcement | Unknown |  |
| base_line_capacity | Unknown |  |
| capacity | Unknown |  |
| capacity_used | Unknown |  |
| carry_capacity | Unknown |  |
| carry_overspend | Unknown |  |
| carry_underspend | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| default_rate | Unknown |  |
| end_date_time | Unknown |  |
| expense_type | Unknown |  |
| is_repeating | Unknown |  |
| is_retainer | Unknown |  |
| notification | Unknown |  |
| notification_type | Unknown |  |
| originator_budget_id | Unknown |  |
| originator_budget_type | Unknown |  |
| originator_start_date_time | Unknown |  |
| repeat_period | Unknown |  |
| repeat_unit | Unknown |  |
| sequence_number | Unknown |  |
| start_date_time | Unknown |  |
| status | Unknown |  |
| timelog_type | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| company_id | Unknown | FK |
| project_id | Unknown | FK |
| author_id_deprecated | Unknown |  |
| body | Unknown |  |
| commentable_id | Unknown |  |
| commentable_type | Unknown |  |
| content_type | Unknown |  |
| datetime | Unknown |  |
| emailed_from | Unknown |  |
| is_read | Unknown |  |
| item_name | Unknown |  |
| last_changed_on | Unknown |  |
| link | Unknown |  |
| nr_notified_people | Unknown |  |
| number | Unknown |  |
| private | Unknown |  |
| type | Unknown |  |

### risk

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| created_by | Unknown | FK |
| last_changed_by | Unknown | FK |
| project_id | Unknown | FK |
| created_on | Unknown |  |
| impact | Unknown |  |
| impact_cost | Unknown |  |
| impact_performance | Unknown |  |
| impact_schedule | Unknown |  |
| impact_value | Unknown |  |
| last_changed_on | Unknown |  |
| mitigation_plan | Unknown |  |
| probability | Unknown |  |
| probability_value | Unknown |  |
| project_is_active | Unknown |  |
| result | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| created_by | Unknown | FK |
| exported_by | Unknown | FK |
| project_id | Unknown | FK |
| update_by | Unknown | FK |
| currency_code | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| display_date | Unknown |  |
| exported_date | Unknown |  |
| fixed_cost | Unknown |  |
| number | Unknown |  |
| po_number | Unknown |  |
| status | Unknown |  |

## Relationships

- time_tracking_assigned_team(assigned_team_id) → team(id)
- time_tracking_assigned_team(time_tracking_id) → time_tracking(id)
- time_tracking(logged_by_user_id) → users(id)
- time_tracking(user_id) → users(id)
- time_tracking(task_id) → task(id)
- time_tracking(project_billing_invoice_id) → invoice(number)
- time_tracking(project_id) → project(id)
- time_tracking(deleted_by_user_id) → users(id)
- time_tracking(edited_by_user_id) → users(id)
- utilization(user_id) → users(id)
- notebook(created_by) → users(id)
- notebook(project_id) → project(id)
- notebook(updated_by) → users(id)
- workflow_project(project_id) → project(id)
- workflow_project(workflow_id) → workflow(id)
- workflow_stage(workflow_id) → workflow(id)
- workflow_company(company_id) → company(id)
- workflow_company(workflow_id) → workflow(id)
- workflow(created_by) → users(id)
- workflow(updated_by) → users(id)
- expense(created_by) → users(id)
- expense(invoice_id) → invoice(id)
- expense(project_id) → project(id)
- expense(company_id) → company(id)
- users_team(team_id) → team(id)
- users_team(users_id) → users(id)
- users(company_id) → company(id)
- tags(project_id) → project(id)
- clock_in(user_id) → users(id)
- task_change_follower(change_follower) → users(id)
- task_change_follower(task_id) → task(id)
- task_comment_follower(comment_follower) → users(id)
- task_comment_follower(task_id) → task(id)
- task_complete_follower(complete_follower) → users(id)
- task_complete_follower(task_id) → task(id)
- assignee_user_task(assignee_user_id) → users(id)
- assignee_user_task(task_id) → task(id)
- assignee_team_task(assignee_team_id) → team(id)
- assignee_team_task(task_id) → task(id)
- task_crm_deal(crm_deal) → company(id)
- task_crm_deal(task_id) → task(id)
- task_sub_task(task_id) → task(id)
- task_tag(tag_id) → tags(id)
- task_tag(task_id) → task(id)
- task_dependency(task_id) → task(id)
- assignee_company_task(assignee_company_id) → company(id)
- assignee_company_task(task_id) → task(id)
- task_predecessor(task_id) → task(id)
- task_workflow_stage(stage_id) → workflow_stage(stage_id)
- task_workflow_stage(workflow_id) → workflow(id)
- task_workflow_stage(task_id) → task(id)
- task(tasklist_id) → task_list(id)
- task(updated_by) → users(id)
- task(parent_task_id) → task(id)
- project(category_id) → project_category(id)
- project(time_budget_id) → project_budget(id)
- project(created_by) → users(id)
- project(financial_budget_id) → project_budget(id)
- project(company_id) → company(id)
- project(updated_by) → users(id)
- project_user(user_id) → users(id)
- project_workflow(workflow_id) → workflow(id)
- activity(user_id) → users(id)
- activity(item_id) → task_list(id)
- activity(project_id) → project(id)
- activity(company_id) → company(id)
- activity(for_user_id) → users(id)
- link(created_by) → users(id)
- link(project_id) → project(id)
- company_tag(id) → tags(id)
- company_tag(project_id) → project(id)
- company_tag(company_id) → company(id)
- tasklist_tag(id) → tags(id)
- tasklist_tag(project_id) → project(id)
- tasklist_tag(task_list_id) → task_list(id)
- task_list(default_task_id) → task(id)
- task_list(milestone_id) → milestone(id)
- task_list(project_id) → project(id)
- user_status(user_id) → users(id)
- custom_field(updated_by_user_id) → users(id)
- custom_field(created_by_user_id) → users(id)
- custom_field(project_id) → project(id)
- custom_field(deleted_by_user_id) → users(id)
- team_member(id) → users(id)
- team_member(team_id) → team(id)
- team(updated_by_user_id) → users(id)
- team(created_by_user_id) → users(id)
- team(project_id) → project(id)
- team(company_id) → company(id)
- message(author_id) → users(id)
- message(milestone_id) → milestone(id)
- message(project_id) → project(id)
- milestone_tasklist(id) → task_list(id)
- milestone_tasklist(milestone_id) → milestone(id)
- milestone_change_follower(change_follower) → users(id)
- milestone_change_follower(milestone_id) → milestone(id)
- milestone_comment_follower(comment_follower) → users(id)
- milestone_comment_follower(milestone_id) → milestone(id)
- milestone_responsible_party(responsible_people) → users(id)
- milestone_responsible_party(milestone_id) → milestone(id)
- milestone_tag(id) → tags(id)
- milestone_tag(project_id) → project(id)
- milestone_tag(milestone_id) → milestone(id)
- milestone(completer_id) → users(id)
- milestone(project_id) → project(id)
- milestone(company_id) → company(id)
- milestone(creator_id) → users(id)
- project_budget_notification(project_budget_id) → project_budget(id)
- project_budget(updated_by_user_id) → users(id)
- project_budget(created_by_user_id) → users(id)
- project_budget(project_id) → project(id)
- comment(author_id) → users(id)
- comment(project_id) → project(id)
- comment(company_id) → company(id)
- risk(last_changed_by) → users(id)
- risk(created_by) → users(id)
- risk(project_id) → project(id)
- risk(company_id) → company(id)
- invoice(created_by) → users(id)
- invoice(update_by) → users(id)
- invoice(project_id) → project(id)
- invoice(company_id) → company(id)
- invoice(exported_by) → users(id)