ClickUp schema

14 tables · 8 joins

About the connector Start free

14 tables

Loading diagram…

task

time

comment

27

id

string

task_id

string

user_id

double

parent_comment_id

string

comment_text

string

comment

string

date

double

reply_count

double

reactions

string

user_username

string

user_email

string

folder

12

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

_weld_synced

date

list

27

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

task

53

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

task_assignees

8

id

double

task_id

string

username

string

color

string

initials

string

email

string

profilePicture

string

_weld_synced

date

task_checklists

10

id

string

task_id

string

name

string

date_created

double

orderindex

double

creator

double

resolved

double

unresolved

double

items

string

_weld_synced

date

task_custom_fields

10

id

string

task_id

string

name

string

type

string

type_config

string

date_created

double

hide_from_guests

boolean

required

boolean

value

string

_weld_synced

date

task_clickup_task_tags

6

task_id

string

name

string

tag_fg

string

tag_bg

string

creator

double

_weld_synced

date

task_dependencies

7

task_id

string

depends_on

string

type

double

date_created

double

userid

string

workspace_id

string

_weld_synced

date

task_linked_tasks

6

task_id

string

link_id

string

date_created

double

userid

string

workspace_id

string

_weld_synced

date

team

4

id

string

name

string

color

string

_weld_synced

date

time

30

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

time_tags

6

time_id

string

name

string

tag_bg

string

tag_fg

string

creator

double

_weld_synced

date

user

11

id

double

username

string

email

string

color

string

initials

string

role

double

custom_role

string

last_active

double

date_joined

double

date_invited

double

_weld_synced

date