Teamwork
Explore the interactive ERD
Table & Field Reference
time_tracking_assigned_team
| Column | Type | Keys |
|---|---|---|
assigned_team_id | Unknown | PKFK |
time_tracking_id | Unknown | PKFK |
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 | PKFK |
workflow_id | Unknown | PKFK |
workflow_stage
| Column | Type | Keys |
|---|---|---|
stage_id | Unknown | PK |
workflow_id | Unknown | PKFK |
workflow_company
| Column | Type | Keys |
|---|---|---|
company_id | Unknown | PKFK |
workflow_id | Unknown | PKFK |
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 | PKFK |
users_id | Unknown | PKFK |
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 | PKFK |
task_id | Unknown | PKFK |
task_comment_follower
| Column | Type | Keys |
|---|---|---|
comment_follower | Unknown | PKFK |
task_id | Unknown | PKFK |
task_complete_follower
| Column | Type | Keys |
|---|---|---|
complete_follower | Unknown | PKFK |
task_id | Unknown | PKFK |
assignee_user_task
| Column | Type | Keys |
|---|---|---|
assignee_user_id | Unknown | PKFK |
task_id | Unknown | PKFK |
assignee_team_task
| Column | Type | Keys |
|---|---|---|
assignee_team_id | Unknown | PKFK |
task_id | Unknown | PKFK |
task_crm_deal
| Column | Type | Keys |
|---|---|---|
crm_deal | Unknown | PKFK |
task_id | Unknown | PKFK |
task_sub_task
| Column | Type | Keys |
|---|---|---|
sub_task_id | Unknown | PK |
task_id | Unknown | PKFK |
task_tag
| Column | Type | Keys |
|---|---|---|
tag_id | Unknown | PKFK |
task_id | Unknown | PKFK |
task_dependency
| Column | Type | Keys |
|---|---|---|
dependency_id | Unknown | PK |
task_id | Unknown | PKFK |
assignee_company_task
| Column | Type | Keys |
|---|---|---|
assignee_company_id | Unknown | PKFK |
task_id | Unknown | PKFK |
task_predecessor
| Column | Type | Keys |
|---|---|---|
predecessor_id | Unknown | PK |
task_id | Unknown | PKFK |
task_workflow_stage
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
task_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
task_list_id | Unknown | PKFK |
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 | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
milestone_id | Unknown | PKFK |
milestone_change_follower
| Column | Type | Keys |
|---|---|---|
change_follower | Unknown | PKFK |
milestone_id | Unknown | PKFK |
milestone_comment_follower
| Column | Type | Keys |
|---|---|---|
comment_follower | Unknown | PKFK |
milestone_id | Unknown | PKFK |
milestone_responsible_party
| Column | Type | Keys |
|---|---|---|
milestone_id | Unknown | PKFK |
responsible_people | Unknown | PKFK |
milestone_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
milestone_id | Unknown | PKFK |
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 | PKFK |
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 |