# ClickUp schema ERD

Table and field reference for the Fivetran ClickUp connector.

## Table & Field Reference

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee | Unknown | FK |
| folder_id | Unknown | FK |
| space_id | Unknown | FK |
| archived | Unknown |  |
| content | Unknown |  |
| due_date | Unknown |  |
| folder_access | Unknown |  |
| folder_hidden | Unknown |  |
| name | Unknown |  |
| order_index | Unknown |  |
| override_statuses | Unknown |  |
| permission_level | Unknown |  |
| priority | Unknown |  |
| priority_color | Unknown |  |
| space_access | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| status_color | Unknown |  |
| status_hide_label | Unknown |  |
| task_count | Unknown |  |

### accessible_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| date_created | Unknown |  |
| hide_from_guests | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| type_config | Json |  |

### space_priority

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | FK |
| color | Unknown |  |
| order_index | Unknown |  |
| priority | Unknown |  |

### space_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | FK |
| color | Unknown |  |
| order_index | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | FK |
| admin_can_manage | Unknown |  |
| archived | Unknown |  |
| avatar | Unknown |  |
| check_unresolved_checklists | Unknown |  |
| check_unresolved_comments | Unknown |  |
| check_unresolved_enabled | Unknown |  |
| check_unresolved_subtasks | Unknown |  |
| checklists_enabled | Unknown |  |
| color | Unknown |  |
| custom_fields_enabled | Unknown |  |
| custom_items_enabled | Unknown |  |
| dependency_warning_enabled | Unknown |  |
| due_date_enabled | Unknown |  |
| due_date_start_date | Unknown |  |
| milestones_enabled | Unknown |  |
| multiple_assignees | Unknown |  |
| multiple_assignees_enabled | Unknown |  |
| name | Unknown |  |
| points_enabled | Unknown |  |
| portfolios_enabled | Unknown |  |
| priorities_enabled | Unknown |  |
| private | Unknown |  |
| ramp_dependencies_enabled | Unknown |  |
| remap_closed_due_date | Unknown |  |
| remap_due_date | Unknown |  |
| sprints_enabled | Unknown |  |
| tags_enabled | Unknown |  |
| time_estimates_enabled | Unknown |  |
| time_tracking_enabled | Unknown |  |
| time_tracking_harvest | Unknown |  |
| time_tracking_rollup | Unknown |  |
| zoom_enabled | Unknown |  |

### view_column_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| view_id | Unknown | PK, FK |
| display | Unknown |  |
| field | Unknown |  |
| hidden | Unknown |  |
| name | Unknown |  |
| width | Unknown |  |

### view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| team_id | Unknown | FK |
| date_created | Unknown |  |
| date_protected | Unknown |  |
| divide_by_subcategory | Unknown |  |
| divide_collapsed | Json |  |
| divide_dir | Unknown |  |
| divide_field | Unknown |  |
| filters_fields | Json |  |
| filters_op | Unknown |  |
| filters_search | Unknown |  |
| filters_search_custom_fields | Unknown |  |
| filters_search_description | Unknown |  |
| filters_search_name | Unknown |  |
| filters_show_closed | Unknown |  |
| grouping_collapsed | Unknown |  |
| grouping_dir | Unknown |  |
| grouping_field | Unknown |  |
| grouping_ignores | Unknown |  |
| name | Unknown |  |
| order_index | Unknown |  |
| parent_id | Unknown |  |
| parent_type | Unknown |  |
| protected | Unknown |  |
| protected_by | Unknown |  |
| protected_note | Unknown |  |
| settings_auto_wrap | Unknown |  |
| settings_collapse_empty_columns | Unknown |  |
| settings_me_checklists | Unknown |  |
| settings_me_comments | Unknown |  |
| settings_me_subtasks | Unknown |  |
| settings_show_assignees | Unknown |  |
| settings_show_closed_subtasks | Unknown |  |
| settings_show_empty_statuses | Unknown |  |
| settings_show_images | Unknown |  |
| settings_show_subtask_parent_names | Unknown |  |
| settings_show_subtasks | Unknown |  |
| settings_show_task_locations | Unknown |  |
| settings_show_timer | Unknown |  |
| settings_time_in_status_view | Unknown |  |
| sorting_fields | Json |  |
| team_sidebar_assigned_comments | Unknown |  |
| team_sidebar_assignees | Json |  |
| team_sidebar_group_assignees | Json |  |
| team_sidebar_unassigned_tasks | Unknown |  |
| type | Unknown |  |
| visibility | Unknown |  |
| custom_columns_** |  |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| display_profile | Unknown |  |
| top_tier_user | Unknown |  |
| type | Unknown |  |
| verified_ambassador | Unknown |  |
| verified_consultant | Unknown |  |
| viewed_top_tier_user | Unknown |  |
| viewed_verified_ambassador | Unknown |  |
| viewed_verified_consultant | Unknown |  |

### goal_group_member

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

### goal_member

| Column | Type | Keys |
| --- | --- | --- |
| goal_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| is_creator | Unknown |  |

### goal_owner

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

### goal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| folder_id | Unknown | FK |
| owner_id | Unknown | FK |
| team_id | Unknown | FK |
| archived | Unknown |  |
| color | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| editor_token | Unknown |  |
| key_result_count | Unknown |  |
| last_update | Unknown |  |
| multiple_owners | Unknown |  |
| name | Unknown |  |
| percent_completed | Unknown |  |
| pinned | Unknown |  |
| pretty_id | Unknown |  |
| private | Unknown |  |
| start_date | Unknown |  |
| ydoc | Unknown |  |

### goal_folder_member

| Column | Type | Keys |
| --- | --- | --- |
| goal_folder_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| added_by | Unknown | FK |
| date_added | Unknown |  |
| permission_level | Unknown |  |

### goal_group_member_in_goal_folder

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| goal_id | Unknown | PK, FK |
| id | Unknown | FK |

### goal_members_in_goal_folder

| Column | Type | Keys |
| --- | --- | --- |
| goal_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| is_creator | Unknown |  |
| permission_level | Unknown |  |

### goal_owners_in_goal_folder

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

### goals_in_goal_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| folder_id | Unknown | FK |
| owner_id | Unknown | FK |
| team_id | Unknown | FK |
| archived | Unknown |  |
| color | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| editor_token | Unknown |  |
| key_result_count | Unknown |  |
| last_update | Unknown |  |
| multiple_owners | Unknown |  |
| name | Unknown |  |
| percent_completed | Unknown |  |
| pinned | Unknown |  |
| pretty_id | Unknown |  |
| private | Unknown |  |
| start_date | Unknown |  |
| ydoc | Unknown |  |

### goal_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| team_id | Unknown | FK |
| date_created | Unknown |  |
| goal_count | Unknown |  |
| name | Unknown |  |
| private | Unknown |  |

### custom_item

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

### sub_task_assignee

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

### sub_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| custom_item_id | Unknown | FK |
| folder_id | Unknown | FK |
| list_id | Unknown | FK |
| parent | Unknown | FK |
| space_id | Unknown | FK |
| team_id | Unknown | FK |
| archived | Unknown |  |
| custom_fields | Json |  |
| custom_id | Unknown |  |
| date_closed | Unknown |  |
| date_created | Unknown |  |
| date_done | Unknown |  |
| date_updated | Unknown |  |
| dependency | Json |  |
| description | Unknown |  |
| due_date | Unknown |  |
| linked_task | Json |  |
| name | Unknown |  |
| order_index | Unknown |  |
| point | Unknown |  |
| priority | Unknown |  |
| priority_color | Unknown |  |
| priority_id | Unknown |  |
| priority_order_index | Unknown |  |
| project_id | Unknown |  |
| start_date | Unknown |  |
| status_color | Unknown |  |
| status_order_index | Unknown |  |
| status_status | Unknown |  |
| status_type | Unknown |  |
| tags | Json |  |
| text_content | Unknown |  |
| time_estimate | Unknown |  |
| time_spent | Unknown |  |
| url | Unknown |  |
| watcher | Json |  |

### task_assignee

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

### task_dependency

| Column | Type | Keys |
| --- | --- | --- |
| depends_on | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| date_created | Unknown |  |
| type | Unknown |  |
| workspace_id | Unknown |  |

### task_watcher

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

### linked_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_id | Unknown | PK |
| user_id | Unknown | FK |
| date_created | Unknown |  |
| workspace_id | Unknown |  |

### task_checklist_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_checklist_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| assignee_id | Unknown | FK |
| children | Json |  |
| date_created | Unknown |  |
| group_assignee | Unknown |  |
| name | Unknown |  |
| order_index | Unknown |  |
| parent | Unknown |  |
| resolved | Unknown |  |

### task_checklist

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_id | Unknown | PK, FK |
| creator | Unknown |  |
| date_created | Unknown |  |
| name | Unknown |  |
| order_index | Unknown |  |
| resolved | Unknown |  |
| unresolved | Unknown |  |

### task_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| task_id | Unknown | FK |
| creator | Unknown |  |
| name | Unknown |  |
| tag_bg | Unknown |  |
| tag_fg | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| custom_item_id | Unknown | FK |
| folder_id | Unknown | FK |
| list_id | Unknown | FK |
| space_id | Unknown | FK |
| team_id | Unknown | FK |
| archived | Unknown |  |
| custom_fields | Json |  |
| custom_id | Unknown |  |
| date_closed | Unknown |  |
| date_created | Unknown |  |
| date_done | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| name | Unknown |  |
| order_index | Unknown |  |
| point | Unknown |  |
| priority | Unknown |  |
| priority_color | Unknown |  |
| priority_id | Unknown |  |
| priority_order_index | Unknown |  |
| project_id | Unknown |  |
| start_date | Unknown |  |
| status_color | Unknown |  |
| status_order_index | Unknown |  |
| status_status | Unknown |  |
| status_type | Unknown |  |
| text_content | Unknown |  |
| time_estimate | Unknown |  |
| time_spent | Unknown |  |
| url | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| email | Unknown |  |
| global_font_support | Unknown |  |
| initials | Unknown |  |
| profile_picture | Unknown |  |
| timezone | Unknown |  |
| username | Unknown |  |
| week_start_day | Unknown |  |

### folder_list_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_list_id | Unknown | PK, FK |
| color | Unknown |  |
| order_index | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### folder_list

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

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | FK |
| archived | Unknown |  |
| hidden | Unknown |  |
| name | Unknown |  |
| order_index | Unknown |  |
| override_statuses | Unknown |  |
| permission_level | Unknown |  |
| space_access | Unknown |  |
| statuses | Json |  |
| task_count | Unknown |  |

### role_member

| Column | Type | Keys |
| --- | --- | --- |
| member_id | Unknown | PK, FK |
| role_id | Unknown | PK, FK |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | FK |
| date_created | Unknown |  |
| inherited_role | Unknown |  |
| name | Unknown |  |

### space_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| creator | Unknown | FK |
| space_id | Unknown | FK |
| name | Unknown |  |
| tag_bg | Unknown |  |
| tag_fg | Unknown |  |

### task_template

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

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_by_id | Unknown | FK |
| assignee_id | Unknown | FK |
| list_id | Unknown | FK |
| task_id | Unknown | FK |
| user_id | Unknown | FK |
| view_id | Unknown | FK |
| comment_text | Unknown |  |
| date | Unknown |  |
| reactions | Unknown |  |
| resolved | Unknown |  |
| type | Unknown |  |

### view_task

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

### group_member

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

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | FK |
| user_id | Unknown | FK |
| avatar_attachment_id | Unknown |  |
| avatar_color | Unknown |  |
| avatar_icon | Unknown |  |
| avatar_source | Unknown |  |
| date_created | Unknown |  |
| handle | Unknown |  |
| initials | Unknown |  |
| name | Unknown |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| team_id | Unknown | PK, FK |
| invited_by_id | Unknown | FK |
| color | Unknown |  |
| custom_role | Unknown |  |
| date_invited | Unknown |  |
| date_joined | Unknown |  |
| email | Unknown |  |
| initials | Unknown |  |
| last_active | Unknown |  |
| profile_picture | Unknown |  |
| role | Unknown |  |
| username | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar | Unknown |  |
| color | Unknown |  |
| name | Unknown |  |

### time_entry_task_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| creator | Unknown | FK |
| time_entry_id | Unknown | FK |
| name | Unknown |  |
| tag_bg | Unknown |  |
| tag_fg | Unknown |  |

### time_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_id | Unknown | FK |
| list_id | Unknown | FK |
| space_id | Unknown | FK |
| task_id | Unknown | FK |
| team_id | Unknown | FK |
| user_id | Unknown | FK |
| at_time | Unknown |  |
| billable | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| end_time | Unknown |  |
| source | Unknown |  |
| start_time | Unknown |  |
| tags | Json |  |
| task_custom_id | Unknown |  |
| task_custom_type | Unknown |  |
| task_name | Unknown |  |
| task_status | Unknown |  |
| task_status_color | Unknown |  |
| task_status_order_index | Unknown |  |
| task_status_type | Unknown |  |
| task_url | Unknown |  |
| w_id | Unknown |  |

## Relationships

- list(folder_id) → folder(id)
- list(space_id) → space(id)
- list(assignee) → team_member(user_id)
- accessible_custom_field(list_id) → list(id)
- space_priority(space_id) → space(id)
- space_status(space_id) → space(id)
- space(team_id) → team(id)
- view_column_field(view_id) → view(id)
- view(creator_id) → team_member(user_id)
- view(team_id) → team(id)
- member(id) → team_member(user_id)
- goal_group_member(id) → group_member(user_id)
- goal_group_member(goal_id) → goal(id)
- goal_member(id) → team_member(user_id)
- goal_member(goal_id) → goal(id)
- goal_owner(id) → team_member(user_id)
- goal_owner(goal_id) → goal(id)
- goal(folder_id) → folder(id)
- goal(team_id) → team(id)
- goal(owner_id) → team_member(user_id)
- goal(creator_id) → team_member(user_id)
- goal_folder_member(id) → team_member(user_id)
- goal_folder_member(added_by) → team_member(user_id)
- goal_folder_member(goal_folder_id) → goal_folder(id)
- goal_group_member_in_goal_folder(id) → group_member(user_id)
- goal_group_member_in_goal_folder(goal_id) → goals_in_goal_folder(id)
- goal_members_in_goal_folder(id) → team_member(user_id)
- goal_members_in_goal_folder(goal_id) → goals_in_goal_folder(id)
- goal_owners_in_goal_folder(id) → team_member(user_id)
- goal_owners_in_goal_folder(goal_id) → goals_in_goal_folder(id)
- goals_in_goal_folder(folder_id) → folder(id)
- goals_in_goal_folder(team_id) → team(id)
- goals_in_goal_folder(owner_id) → team_member(user_id)
- goals_in_goal_folder(creator_id) → team_member(user_id)
- goal_folder(team_id) → team(id)
- goal_folder(creator_id) → team_member(user_id)
- custom_item(team_id) → team(id)
- sub_task_assignee(id) → team_member(user_id)
- sub_task_assignee(sub_task_id) → sub_task(id)
- sub_task(custom_item_id) → custom_item(id)
- sub_task(folder_id) → folder(id)
- sub_task(list_id) → list(id)
- sub_task(team_id) → team(id)
- sub_task(parent) → sub_task(id)
- sub_task(space_id) → space(id)
- sub_task(creator_id) → team_member(user_id)
- task_assignee(id) → team_member(user_id)
- task_assignee(task_id) → task(id)
- task_dependency(depends_on) → task(id)
- task_dependency(task_id) → task(id)
- task_dependency(user_id) → team_member(user_id)
- task_watcher(id) → team_member(user_id)
- task_watcher(task_id) → task(id)
- linked_task(user_id) → team_member(user_id)
- task_checklist_item(assignee_id) → team_member(user_id)
- task_checklist_item(task_checklist_id) → task_checklist(id)
- task_checklist_item(task_id) → task_checklist(task_id)
- task_checklist(task_id) → task(id)
- task_tag(task_id) → task(id)
- task(custom_item_id) → custom_item(id)
- task(folder_id) → folder(id)
- task(list_id) → list(id)
- task(team_id) → team(id)
- task(space_id) → space(id)
- task(creator_id) → team_member(user_id)
- folder_list_status(folder_list_id) → folder_list(id)
- folder_list(id) → list(id)
- folder_list(folder_id) → folder(id)
- folder(space_id) → space(id)
- role_member(member_id) → team_member(user_id)
- role_member(role_id) → role(id)
- role(team_id) → team(id)
- space_tag(creator) → team_member(user_id)
- space_tag(space_id) → space(id)
- task_template(team_id) → team(id)
- comment(user_id) → team_member(user_id)
- comment(list_id) → list(id)
- comment(task_id) → task(id)
- comment(view_id) → view(id)
- comment(assignee_id) → team_member(user_id)
- comment(assigned_by_id) → team_member(user_id)
- view_task(task_id) → sub_task(id)
- view_task(view_id) → view(id)
- group_member(user_id) → team_member(user_id)
- group_member(group_id) → groups(id)
- groups(team_id) → team(id)
- groups(user_id) → team_member(user_id)
- team_member(invited_by_id) → team_member(user_id)
- team_member(team_id) → team(id)
- time_entry_task_tag(creator) → team_member(user_id)
- time_entry_task_tag(time_entry_id) → time_entry(id)
- time_entry(user_id) → team_member(user_id)
- time_entry(list_id) → list(id)
- time_entry(folder_id) → folder(id)
- time_entry(space_id) → space(id)
- time_entry(task_id) → task(id)
- time_entry(team_id) → team(id)