ClickUp
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
goal_member
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
id | Unknown | PKFK |
is_creator | Unknown |
goal_owner
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
id | Unknown | FK |
goal_members_in_goal_folder
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
id | Unknown | PKFK |
is_creator | Unknown | |
permission_level | Unknown |
goal_owners_in_goal_folder
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
description | Unknown | |
name | Unknown | |
name_plural | Unknown |
sub_task_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
sub_task_id | Unknown | PKFK |
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 | PKFK |
task_id | Unknown | PKFK |
task_dependency
| Column | Type | Keys |
|---|---|---|
depends_on | Unknown | PKFK |
task_id | Unknown | PKFK |
user_id | Unknown | FK |
date_created | Unknown | |
type | Unknown | |
workspace_id | Unknown |
task_watcher
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
task_id | Unknown | PKFK |
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 | PKFK |
task_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
color | Unknown | |
order_index | Unknown | |
status | Unknown | |
type | Unknown |
folder_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
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 | PKFK |
role_id | Unknown | PKFK |
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 | PKFK |
view_id | Unknown | PKFK |
group_member
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
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 |