ERD for ClickUp | Weld

13 tables

Loading diagram…

task

task

id

string

team_id

string

list_id

string

folder_id

string

custom_id

string

name

string

text_content

string

description

string

status_status

string

status_color

string

status_type

string

status_orderindex

double

orderindex

double

date_created

double

date_updated

double

date_closed

double

date_done

double

archived

boolean

creator_id

double

creator_username

string

creator_color

string

creator_email

string

creator_profilePicture

string

watchers

string

parent

string

priority

string

due_date

double

start_date

string

points

double

time_estimate

double

url

string

sharing_public

boolean

sharing_public_share_expires_on

string

sharing_public_fields

string

sharing_token

string

sharing_seo_optimized

boolean

permission_level

string

list_name

string

list_access

boolean

project_id

string

project_name

string

project_hidden

boolean

project_access

boolean

folder_name

string

folder_hidden

boolean

folder_access

boolean

space_id

string

priority_color

string

priority_id

string

priority_orderindex

double

priority_priority

string

time_spent

double

task_assignees

id

double

task_id

string

username

string

color

string

initials

string

email

string

profilePicture

string

task_checklists

id

string

task_id

string

name

string

date_created

double

orderindex

double

creator

double

resolved

double

unresolved

double

items

string

task_custom_fields

id

string

task_id

string

name

string

type

string

type_config

string

date_created

double

hide_from_guests

boolean

required

boolean

value

string

task_clickup_task_tags

task_id

string

name

string

tag_fg

string

tag_bg

string

creator

double

task_dependencies

task_id

string

depends_on

string

type

double

date_created

double

userid

string

workspace_id

string

task_linked_tasks

task_id

string

link_id

string

date_created

double

userid

string

workspace_id

string

time

time

id

string

task_id

string

user_id

double

task_name

string

task_status_status

string

task_status_color

string

task_status_type

string

task_status_orderindex

double

task_custom_type

double

wid

string

user_username

string

user_email

string

user_color

string

user_initials

string

billable

boolean

start

double

end

double

duration

double

description

string

tags

string

source

string

at

double

task_location_list_id

string

task_location_folder_id

string

task_location_space_id

string

task_location_list_name

string

task_location_folder_name

string

task_location_space_name

string

task_url

string

time_tags

time_id

string

name

string

tag_bg

string

tag_fg

string

creator

double

folder

id

string

name

string

orderindex

double

override_statuses

boolean

hidden

boolean

space_id

string

space_name

string

task_count

double

archived

boolean

statuses

string

permission_level

string

user

id

double

username

string

email

string

color

string

initials

string

role

double

custom_role

string

last_active

double

date_joined

double

date_invited

double

list

id

string

folder_id

string

name

string

orderindex

double

status_status

string

status_color

string

status_hide_label

boolean

priority

string

assignee_color

string

assignee_username

string

assignee_initials

string

task_count

double

due_date

double

start_date

string

folder_name

string

folder_hidden

boolean

folder_access

boolean

space_id

string

space_name

string

space_access

boolean

archived

boolean

override_statuses

boolean

permission_level

string

content

string

priority_priority

string

priority_color

string

team

id

string

name

string

color

string

Table

Sub table