Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
EPIC ⇱
id 🔑
epic_state_id ▶ EPIC_WORKFLOW_STATE.id
group_id ▶ GROUP
milestone_id ▶ MILESTONE
requested_by_id ▶ WORKSPACE_MEMBER
app_url
archived
completed
completed_at
completed_at_override
created_at
deadline
entity_type
external_id
global_id
name
planned_start_date
position
productboard_id
productboard_name
productboard_plugin_id
productboard_url
started
started_at
started_at_override
state
stats_average_cycle_time
stats_average_lead_time
stats_last_story_update
stats_num_points
stats_num_points_backlog
stats_num_points_done
stats_num_points_started
stats_num_points_unstarted
stats_num_related_documents
stats_num_stories_backlog
stats_num_stories_done
stats_num_stories_started
stats_num_stories_total
stats_num_stories_unestimated
stats_num_stories_unstarted
stories_without_projects
updated_at
EPIC_ASSOCIATED_GROUP ⇱
epic_id 🔑 ▶ EPIC
group_id 🔑 ▶ GROUP
associated_stories_count
EPIC_PROJECT ⇱
epic_id 🔑 ▶ EPIC
id 🔑 ▶ PROJECT
EPIC_STORY ⇱
id 🔑
epic_id ▶ EPIC
group_id ▶ GROUP
iteration_id ▶ ITERATION
project_id ▶ PROJECT
requested_by_id ▶ WORKSPACE_MEMBER
story_template_id ▶ ENTITY_TEMPLATE
workflow_id ▶ WORKFLOW
workflow_state_id ▶ WORKFLOW_STATE.id
app_url
archived
blocked
blocker
completed
completed_at
completed_at_override
created_at
cycle_time
deadline
entity_type
estimate
external_id
external_links
global_id
lead_time
moved_at
name
num_tasks_completed
position
started
started_at
started_at_override
stats_num_related_documents
story_links
story_type
updated_at
custom_*
EPIC_STORY_TASK ⇱
id 🔑
epic_story_id 🔑 ▶ EPIC_STORY
EPIC_STORY_FILE ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ FILE
EPIC_STORY_PREVIOUS_ITERATION ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ ITERATION
EPIC_STORY_LABEL ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ LABEL
EPIC_STORY_FOLLOWER ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ WORKSPACE_MEMBER
EPIC_STORY_OWNER ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ WORKSPACE_MEMBER
EPIC_STORY_COMMENT ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ EPIC_COMMENT
EPIC_STORY_LINKED_FILE ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ LINKED_FILE
WORKSPACE_MEMBER ⇱
id 🔑
created_at
created_without_invite
disabled
entity_type
global_id
profile_deactivated
profile_display_icon_created_at
profile_display_icon_entity_type
profile_display_icon_id
profile_display_icon_updated_at
profile_display_icon_url
profile_email_address
profile_entity_type
profile_gravatar_hash
profile_id
profile_is_owner
profile_mention_name
profile_name
profile_two_factor_auth_activated
role
state
updated_at
WORKSPACE_MEMBER_GROUP ⇱
group_id 🔑 ▶ GROUP
workspace_member_id 🔑 ▶ WORKSPACE_MEMBER
AUTHENTICATED_MEMBER ⇱
id 🔑 ▶ WORKSPACE_MEMBER
mention_name
name
workspace_2_estimate_scale
workspace_2_url_slug
STORY ⇱
id 🔑
epic_id ▶ EPIC
iteration_id ▶ ITERATION
project_id ▶ PROJECT
requested_by_id ▶ WORKSPACE_MEMBER
story_template_id ▶ ENTITY_TEMPLATE
workflow_id ▶WORKFLOW
workflow_state_id ▶ WORKFLOW_STATE.id
app_url
archived
blocked
blocker
completed
completed_at
completed_at_override
created_at
cycle_time
deadline
description
entity_type
estimate
external_id
external_links
lead_time
moved_at
name
position
stats
started
started_at
started_at_override
story_type
synced_item_external_id
synced_item_url
updated_at
STORY_BRANCH ⇱
id 🔑
repository_id ▶ REPOSITORY
story_id ▶ STORY
created_at
deleted
entity_type
merged_branch_ids
name
persistent
updated_at
url
STORY_BRANCH_PR ⇱
id 🔑
repository_id ▶ REPOSITORY
story_branch_id ▶ STORY_BRANCH
branch_id
branch_name
closed
created_at
draft
entity_type
has_overlapping_stories
merged
num_added
num_commits
num_modified
num_removed
number
overlapping_stories
review_status
target_branch_id
target_branch_name
title
updated_at
url
STORY_BRANCH_PR_VCS_LABEL
id 🔑
story_branch_pr ▶ STORY_BRANCH_PR
color
description
entity_type
name
STORY_COMMIT ⇱
id 🔑
repository_id ▶ REPOSITORY
story_id ▶ STORY
author_id ▶ WORKSPACE_MEMBER
author_email
author_identity_entity_type
author_identity_name
author_identity_type
created_at
entity_type
hash
message
timestamp
updated_at
url
STORY_FILE ⇱
id 🔑 ▶ FILE
story_id 🔑 ▶ STORY
STORY_COMMENT ⇱
id 🔑
author_id ▶ WORKSPACE_MEMBER
parent_id ▶ STORY_COMMENT
story_id ▶ STORY
app_url
blocker
created_at
deleted
entity_type
external_id
position
text
unblocks_parent
updated_at
STORY_LINKED_FILE ⇱
id 🔑 ▶ LINKED_FILE
story_id 🔑 ▶ STORY
STORY_TASK ⇱
id 🔑
story_id ▶ STORY
complete
completed_at
created_at
description
entity_type
external_id
position
updated_at
STORY_TASK_OWNER ⇱
id 🔑 ▶ WORKSPACE_MEMBER
story_task_id 🔑 ▶ STORY_TASK
STORY_LABEL ⇱
id 🔑 ▶ LABEL
story_id 🔑 ▶ STORY
ENTITY_TEMPLATE ⇱
id 🔑
author_id ▶ WORKSPACE_MEMBER
epic_id ▶ EPIC
group_id ▶ GROUP
project_id ▶ PROJECT
workflow_state_id ▶ WORKFLOW_STATE.id
created_at
deadline
description
entity_type
estimate
external_links
last_used_at
name
story_type
updated_at
custom_*
ENTITY_TEMPLATE_LABEL ⇱
id 🔑 ▶ LABEL
entity_template_id 🔑 ▶ ENTITY_TEMPLATE
ENTITY_TEMPLATE_EXTERNAL ⇱
link 🔑
entity_template_id 🔑 ▶ ENTITY_TEMPLATE
ENTITY_TEMPLATE_FILE ⇱
id 🔑 ▶ FILE
entity_template_id 🔑 ▶ ENTITY_TEMPLATE
ENTITY_TEMPLATE_FOLLOWER ⇱
id 🔑 ▶ WORKSPACE_MEMBER
entity_template_id 🔑 ▶ ENTITY_TEMPLATE
ENTITY_TEMPLATE_TASK ⇱
_fivetran_id 🔑
entity_template_id ▶ ENTITY_TEMPLATE
complete
description
position
ENTITY_TEMPLATE_OWNER ⇱
id 🔑 ▶ WORKSPACE_MEMBER
entity_template_id 🔑 ▶ ENTITY_TEMPLATE
EXTERNAL_LINK_STORIES ⇱
id 🔑
template_external_link ▶ ENTITY_TEMPLATE_EXTERNAL.link
created_at
entity_type
external_id
full_name
name
type
updated_at
url
EXTERNAL_STORY_LINK ⇱
id 🔑
external_link_stories_id 🔑 ▶ EXTERNAL_LINK_STORIES
created_at
entity_type
object_id
subject_id
subject_workflow_state_id
type
updated_at
verb
WORKFLOW ⇱
id 🔑
default_state_id ▶ WORKFLOW_STATE.id
project_id ▶ PROJECT.id
team_id ▶ PROJECT.team_id
auto_assign_owner
created_at
description
entity_type
name
updated_at
CUSTOM_FIELD ⇱
id 🔑
canonical_name
created_at
description
enabled
entity_type
field_type
fixed_position
icon_set_identifier
name
position
updated_at
CUSTOM_FIELD_VALUE ⇱
id 🔑
custom_field_id 🔑 ▶ CUSTOM_FIELD
color_key
enabled
entity_type
position
value
PROJECT ⇱
id 🔑
team_id 🔑
workflow_id ▶ WORKFLOW
abbreviation
app_url
archived
color
created_at
days_to_thermometer
description
entity_type
external_id
iteration_length
name
show_thermometer
start_time
stats_num_points
stats_num_related_documents
stats_num_stories
updated_at
PROJECT_FOLLOWER ⇱
project_id 🔑 ▶ PROJECT
workspace_member_id 🔑 ▶ WORKSPACE_MEMBER
REPOSITORY ⇱
id 🔑
created_at
entity_type
external_id
full_name
name
type
updated_at
url
LINKED_FILE ⇱
id 🔑
uploader_id ▶ WORKSPACE_MEMBER
content_type
created_at
description
entity_type
name
size
thumbnail_url
type
updated_at
url
ITERATION ⇱
id 🔑
group_mention_id ▶ GROUP
app_url
created_at
end_date
entity_type
global_id
name
start_date
stats_num_epics
stats_num_epics_completed
stats_num_epics_in_progress
stats_num_epics_total
stats_num_epics_unstarted
stats_num_points_backlog
stats_num_points_completed
stats_num_points_in_progress
stats_num_points_total
stats_num_points_unstarted
stats_num_related_documents
stats_num_stories_backlog
stats_num_stories_completed
stats_num_stories_in_progress
stats_num_stories_total
stats_num_stories_unestimated
stats_num_stories_unstarted
status
updated_at
ITERATION_ASSOCIATED_GROUP ⇱
group_id 🔑▶ GROUP
iteration_id 🔑 ▶ ITERATION
associated_stories_count
ITERATION_LABEL ⇱
iteration_id 🔑 ▶ ITERATION
label_id 🔑 ▶ LABEL
ITERATION_FOLLOWER ⇱
iteration_id 🔑 ▶ ITERATION
workspace_member_id 🔑 ▶ WORKSPACE_MEMBER
ITERATION_GROUP ⇱
group_id 🔑 ▶ GROUP
iteration_id 🔑 ▶ ITERATION
LABEL ⇱
id 🔑
app_url
archived
color
created_at
description
entity_type
external_id
global_id
name
stats_num_epics
stats_num_epics_completed
stats_num_epics_in_progress
stats_num_epics_total
stats_num_epics_unstarted
stats_num_points_backlog
stats_num_points_completed
stats_num_points_in_progress
stats_num_points_total
stats_num_points_unstarted
stats_num_related_documents
stats_num_stories_backlog
stats_num_stories_completed
stats_num_stories_in_progress
stats_num_stories_total
stats_num_stories_unestimated
stats_num_stories_unstarted
updated_at
GROUP ⇱
id 🔑
app_url
archived
color
color_key
description
entity_type
global_id
mention_name
name
num_epics_started
num_stories
num_stories_backlog
num_stories_started
display_icon_*
GROUP_WORKSPACE_MEMBER ⇱
group_id 🔑 ▶ GROUP
id 🔑 ▶ WORKSPACE_MEMBER
GROUP_WORKFLOW ⇱
group_id 🔑 ▶ GROUP
id 🔑 ▶ WORKFLOW
EPIC_COMMENT ⇱
id 🔑
epic_id ▶ EPIC
app_url
author_id
created_at
deleted
entity_type
external_id
text
updated_at
STORY_TASK_MEMBER_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
story_task_id 🔑 ▶ STORY_TASK
STORY_TASK_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
story_task_id 🔑 ▶ STORY_TASK
STORY_TASK_GROUP_MENTION ⇱
id 🔑 ▶ GROUP
story_task_id 🔑 ▶ STORY_TASK
ITERATION_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
iteration_id 🔑 ▶ ITERATION
ITERATION_MEMBER_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
iteration_id 🔑 ▶ ITERATION
STORY_COMMENT_MEMBER_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
story_comment_id 🔑 ▶ STORY_COMMENT
STORY_COMMENT_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
story_comment_id 🔑 ▶ STORY_COMMENT
STORY_COMMENT_GROUP_MENTION ⇱
id 🔑 ▶ GROUP
story_comment_id 🔑 ▶ STORY_COMMENT
LINKED_FILE_MEMBER_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
linked_file_id 🔑 ▶ LINKED_FILE
LINKED_FILE_MENTION ⇱
id 🔑 ▶ WORKSPACE_MEMBER
linked_file_id 🔑 ▶ LINKED_FILE
LINKED_FILE_GROUP_MENTION ⇱
id 🔑 ▶ GROUP
linked_file_id 🔑 ▶ LINKED_FILE
EPIC_STORY_MEMBER_MENTION ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ EPIC_WORKFLOW
EPIC_STORY_MENTION ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ EPIC_WORKFLOW
EPIC_STORY_GROUP_MENTION ⇱
epic_story_id 🔑 ▶ EPIC_STORY
id 🔑 ▶ GROUP
MILESTONE ⇱
id 🔑
app_url
archived
completed
completed_at
completed_at_override
created_at
description
entity_type
global_id
name
position
started
started_at
started_at_override
state
stats_average_cycle_time
stats_average_lead_time
stats_num_related_documents
updated_at
ENTITY_TEMPLATE_LINKED_FILE ⇱
id 🔑 ▶ LINKED_FILE
entity_template_id 🔑 ▶ ENTITY_TEMPLATE
MILESTONE_CATEGORY ⇱
id 🔑 ▶ CATEGORY
milestone_id 🔑 ▶ MILESTONE
CATEGORY ⇱
id 🔑
archived
color
created_at
entity_type
external_id
name
type
updated_at
EPIC_WORKFLOW ⇱
id 🔑
default_epic_state_id ▶ EPIC_WORKFLOW_STATE.id
created_at
entity_type
updated_at
EPIC_WORKFLOW_STATE ⇱
id 🔑
epic_workflow_id 🔑 ▶ EPIC_WORKFLOW
created_at
description
entity_type
global_id
name
position
type
updated_at
FILE ⇱
id 🔑
uploader_id ▶ WORKSPACE_MEMBER
content_type
created_at
description
entity_type
external_id
filename
name
size
thumbnail_url
updated_at
url
FILE_MENTION ⇱
file_id 🔑 ▶ FILE
id 🔑 ▶ WORKSPACE_MEMBER
FILE_MEMBER_MENTION ⇱
file_id 🔑 ▶ FILE
id 🔑 ▶ WORKSPACE_MEMBER
FILE_GROUP_MENTION ⇱
file_id 🔑 ▶ FILE
id 🔑 ▶ GROUP
WORKFLOW_STATE ⇱
id 🔑
workflow_id 🔑 ▶ WORKFLOW
created_at
description
entity_type
global_id
name
num_stories
num_story_templates
position
type
updated_at
verb
EPIC_LABEL ⇱
epic_id 🔑 ▶ EPIC
id 🔑 ▶ LABEL
STORY_OWNER ⇱
id 🔑 ▶ WORKSPACE_MEMBER
story_id 🔑 ▶ STORY