Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id🔑
name
ORGANIZATION ⇱
id🔑
workspace_id ➤ WORKSPACE
owner_id ➤ USER
team_id ➤ TEAM
name
notes
color
created_at
modified_at
due_date
archived
current_status
current_status_color
PROJECT ⇱
id🔑
target_id ➤ TASK
created_by_id ➤ USER
type
text
source
created_at
hearted
num_hearts
STORY ⇱
task_id🔑 ➤ TASK
user_id🔑 ➤ USER
TASK_FOLLOWER ⇱
id 🔑
created_at
name
color
notes
message
TAG ⇱
tag_id🔑 ➤ TAG
user_id🔑 ➤ USER
TAG_FOLLOWER ⇱
id🔑
name
USER ⇱
id🔑
assignee_id ➤ USER
created_by_id ➤ USER
completed_by_id ➤ USER
parent_id ➤ TASK
workspace_id ➤ WORKSPACE
name
notes
completed
created_at
completed_at
resource_subtype
start_on
due_on
due_at
assignee_status
modified_at
hearted
liked
num_hearts�custom_*
TASK ⇱
task_id🔑 ➤ TASK
tag_id🔑 ➤ TAG
TASK_TAG ⇱
id🔑
name
is_organization
WORKSPACE ⇱
task_id🔑 ➤ TASK
project_id🔑 ➤ PROJECT
PROJECT_TASK ⇱
id🔑
organization_id ➤ ORGANIZATION
name
TEAM ⇱
id🔑
parent_id ➤ TASK
host
name
view_url
created_at
download_url
ATTACHMENT ⇱
id🔑
project_id ➤ PROJECT
name
created_at
SECTION ⇱
task_id🔑 ➤ TASK
section_id🔑 ➤ SECTION
TASK_SECTION ⇱
id🔑
created_by_id ➤ USER
owner_id ➤ USER
workspace_id ➤ WORKSPACE
name
color
created_at
due_on
start_on
custom_*
PORTFOLIO ⇱
id 🔑 ➤ PORTFOLIO or PROJECT
portfolio_id 🔑 ➤ PORTFOLIO
resource_type
PORTFOLIO_ITEM ⇱
portfolio_id 🔑 ➤ PORTFOLIO
user_id 🔑 ➤ USER
PORTFOLIO_MEMBER ⇱
id🔑
project_id ➤ PROJECT
author_id ➤ USER
created_by_id ➤ USER
created_at
modified_at
color
text
title
PROJECT_STATUS ⇱
id🔑
team_id ➤ TEAM
owner_id ➤ USER
workspace_id ➤ WORKSPACE
name
notes
status
due_on
start_on
liked
num_likes
time_period
metric
GOAL ⇱
goal_id🔑 ➤ GOAL
user_id🔑 ➤ USER
GOAL_FOLLOWER ⇱
gid🔑
goal_id🔑 ➤ GOAL
supporting_resourse_gid ➤ GOAL/PROJECT/PORTFOLIO
resourse_subtype
contribution_weight
supporting_resourse_name
supporting_resourse_type
GOAL_RELATIONSHIP ⇱
id🔑
goal_id ➤ GOAL
created_by_id ➤ USER
created_at
modified_at
status_type
text
title
GOAL_STATUS ⇱