Shortcut
Explore the interactive ERD
Table & Field Reference
group_workspace_member
| Column | Type | Keys |
|---|---|---|
groups_id | Unknown | PKFK |
id | Unknown | PKFK |
group_workflow
| Column | Type | Keys |
|---|---|---|
groups_id | Unknown | PKFK |
id | Unknown | PKFK |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
app_url | Unknown | |
archived | Unknown | |
color | Unknown | |
color_key | Unknown | |
description | Unknown | |
display_icon_created_at | Unknown | |
display_icon_entity_type | Unknown | |
display_icon_id | Unknown | |
display_icon_updated_at | Unknown | |
display_icon_url | Unknown | |
entity_type | Unknown | |
global_id | Unknown | |
mention_name | Unknown | |
name | Unknown | |
num_epics_started | Unknown | |
num_stories | Unknown | |
num_stories_backlog | Unknown | |
num_stories_started | Unknown |
authenticated_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
mention_name | Unknown | |
name | Unknown | |
workspace_2_estimate_scale | Json | |
workspace_2_url_slug | Unknown |
custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_field_id | Unknown | PKFK |
color_key | Unknown | |
enabled | Unknown | |
entity_type | Unknown | |
position | Unknown | |
value | Unknown |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
canonical_name | Unknown | |
created_at | Unknown | |
description | Unknown | |
enabled | Unknown | |
entity_type | Unknown | |
field_type | Unknown | |
fixed_position | Unknown | |
icon_set_identifier | Unknown | |
name | Unknown | |
position | Unknown | |
updated_at | Unknown |
label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
app_url | Unknown | |
archived | Unknown | |
color | Unknown | |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
global_id | Unknown | |
name | Unknown | |
stats_num_epics | Unknown | |
stats_num_epics_completed | Unknown | |
stats_num_epics_in_progress | Unknown | |
stats_num_epics_total | Unknown | |
stats_num_epics_unstarted | Unknown | |
stats_num_points_backlog | Unknown | |
stats_num_points_completed | Unknown | |
stats_num_points_in_progress | Unknown | |
stats_num_points_total | Unknown | |
stats_num_points_unstarted | Unknown | |
stats_num_related_documents | Unknown | |
stats_num_stories_backlog | Unknown | |
stats_num_stories_completed | Unknown | |
stats_num_stories_in_progress | Unknown | |
stats_num_stories_total | Unknown | |
stats_num_stories_unestimated | Unknown | |
stats_num_stories_unstarted | Unknown | |
updated_at | Unknown |
iteration_associated_group
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
iteration_id | Unknown | PKFK |
associated_stories_count | Unknown |
iteration_label
| Column | Type | Keys |
|---|---|---|
iteration_id | Unknown | PKFK |
label_id | Unknown | PKFK |
iteration_follower
| Column | Type | Keys |
|---|---|---|
iteration_id | Unknown | PKFK |
workspace_member_id | Unknown | PKFK |
iteration_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
iteration_id | Unknown | PKFK |
iteration_member_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
iteration_id | Unknown | PKFK |
iteration_group
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
iteration_id | Unknown | PKFK |
iteration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
group_mention_ids | Json | FK |
app_url | Unknown | |
created_at | Unknown | |
end_date | Unknown | |
entity_type | Unknown | |
global_id | Unknown | |
name | Unknown | |
start_date | Unknown | |
stats_num_epics | Unknown | |
stats_num_epics_completed | Unknown | |
stats_num_epics_in_progress | Unknown | |
stats_num_epics_total | Unknown | |
stats_num_epics_unstarted | Unknown | |
stats_num_points_backlog | Unknown | |
stats_num_points_completed | Unknown | |
stats_num_points_in_progress | Unknown | |
stats_num_points_total | Unknown | |
stats_num_points_unstarted | Unknown | |
stats_num_related_documents | Unknown | |
stats_num_stories_backlog | Unknown | |
stats_num_stories_completed | Unknown | |
stats_num_stories_in_progress | Unknown | |
stats_num_stories_total | Unknown | |
stats_num_stories_unestimated | Unknown | |
stats_num_stories_unstarted | Unknown | |
status | Unknown | |
updated_at | Unknown |
project_follower
| Column | Type | Keys |
|---|---|---|
project_id | Unknown | PKFK |
workspace_member_id | Unknown | PKFK |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PK |
workflow_id | Unknown | FK |
abbreviation | Unknown | |
app_url | Unknown | |
archived | Unknown | |
color | Unknown | |
created_at | Unknown | |
days_to_thermometer | Unknown | |
description | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
iteration_length | Unknown | |
name | Unknown | |
show_thermometer | Unknown | |
start_time | Unknown | |
stats_num_points | Unknown | |
stats_num_related_documents | Unknown | |
stats_num_stories | Unknown | |
updated_at | Unknown |
epic_associated_group
| Column | Type | Keys |
|---|---|---|
epic_id | Unknown | PKFK |
group_id | Unknown | PKFK |
associated_stories_count | Unknown |
epic_objective
| Column | Type | Keys |
|---|---|---|
objective_id | Unknown | PK |
epic_id | Unknown | PKFK |
id | Unknown | FK |
epic_label
| Column | Type | Keys |
|---|---|---|
epic_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_project
| Column | Type | Keys |
|---|---|---|
epic_id | Unknown | PKFK |
id | Unknown | PKFK |
epic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_state_id | Unknown | FK |
group_id | Unknown | FK |
requested_by_id | Unknown | FK |
app_url | Unknown | |
archived | Unknown | |
completed | Unknown | |
completed_at | Unknown | |
completed_at_override | Unknown | |
created_at | Unknown | |
deadline | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
global_id | Unknown | |
milestone_id | Unknown | |
name | Unknown | |
planned_start_date | Unknown | |
position | Unknown | |
productboard_id | Unknown | |
productboard_name | Unknown | |
productboard_plugin_id | Unknown | |
productboard_url | Unknown | |
started | Unknown | |
started_at | Unknown | |
started_at_override | Unknown | |
state | Unknown | |
stats_average_cycle_time | Unknown | |
stats_average_lead_time | Unknown | |
stats_last_story_update | Unknown | |
stats_num_points | Unknown | |
stats_num_points_backlog | Unknown | |
stats_num_points_done | Unknown | |
stats_num_points_started | Unknown | |
stats_num_points_unstarted | Unknown | |
stats_num_related_documents | Unknown | |
stats_num_stories_backlog | Unknown | |
stats_num_stories_done | Unknown | |
stats_num_stories_started | Unknown | |
stats_num_stories_total | Unknown | |
stats_num_stories_unestimated | Unknown | |
stats_num_stories_unstarted | Unknown | |
stories_without_projects | Unknown | |
updated_at | Unknown |
epic_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_id | Unknown | FK |
app_url | Unknown | |
author_id | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
group_mention_ids | Json | |
member_mention_ids | Json | |
mention_ids | Json | |
text | Unknown | |
updated_at | Unknown |
epic_workflow_state
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_workflow_id | Unknown | PKFK |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
global_id | Unknown | |
name | Unknown | |
position | Unknown | |
type | Unknown | |
updated_at | Unknown |
epic_workflow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_epic_state_id | Unknown | FK |
created_at | Unknown | |
entity_type | Unknown | |
updated_at | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
archived | Unknown | |
color | Unknown | |
created_at | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown |
objective_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
objective_id | Unknown | PKFK |
objective
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
app_url | Unknown | |
archived | Unknown | |
completed | Unknown | |
completed_at | Unknown | |
completed_at_override | Unknown | |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
global_id | Unknown | |
key_result_id | Json | |
name | Unknown | |
position | Unknown | |
started | Unknown | |
started_at | Unknown | |
started_at_override | Unknown | |
state | Unknown | |
stats_average_cycle_time | Unknown | |
stats_average_lead_time | Unknown | |
stats_num_related_documents | Unknown | |
updated_at | Unknown |
file_mention
| Column | Type | Keys |
|---|---|---|
file_id | Unknown | PKFK |
id | Unknown | PKFK |
file_member_mention
| Column | Type | Keys |
|---|---|---|
file_id | Unknown | PKFK |
id | Unknown | PKFK |
file_group_mention
| Column | Type | Keys |
|---|---|---|
file_id | Unknown | PKFK |
id | Unknown | PKFK |
file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
uploader_id | Unknown | FK |
content_type | Unknown | |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
filename | Unknown | |
name | Unknown | |
size | Unknown | |
thumbnail_url | Unknown | |
updated_at | Unknown | |
url | Unknown |
entity_template_label
| Column | Type | Keys |
|---|---|---|
entity_template_id | Unknown | PKFK |
id | Unknown | PKFK |
entity_template_follower
| Column | Type | Keys |
|---|---|---|
entity_template_id | Unknown | PKFK |
id | Unknown | PKFK |
entity_template_owner
| Column | Type | Keys |
|---|---|---|
entity_template_id | Unknown | PKFK |
id | Unknown | PKFK |
entity_template_task
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
entity_template_id | Unknown | FK |
complete | Unknown | |
description | Unknown | |
position | Unknown |
entity_template_file
| Column | Type | Keys |
|---|---|---|
entity_template_id | Unknown | PKFK |
id | Unknown | PKFK |
entity_template_linked_file
| Column | Type | Keys |
|---|---|---|
entity_template_id | Unknown | PKFK |
id | Unknown | PKFK |
entity_template_external
| Column | Type | Keys |
|---|---|---|
link | Unknown | PK |
entity_template_id | Unknown | PKFK |
entity_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
epic_id | Unknown | FK |
group_id | Unknown | FK |
project_id | Unknown | FK |
workflow_state_id | Unknown | FK |
created_at | Unknown | |
deadline | Unknown | |
description | Unknown | |
entity_type | Unknown | |
estimate | Unknown | |
external_links | Unknown | |
last_used_at | Unknown | |
linked_files | Json | |
name | Unknown | |
story_type | Unknown | |
updated_at | Unknown | |
custom_** |
epic_story_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
story_id | Unknown | PKFK |
value_id | Unknown | PKFK |
epic_story_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_story_id | Unknown | PKFK |
epic_story_file
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_previous_iteration
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_label
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_follower
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_owner
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_comment
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_linked_file
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_mention
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_member_mention
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story_group_mention
| Column | Type | Keys |
|---|---|---|
epic_story_id | Unknown | PKFK |
id | Unknown | PKFK |
epic_story
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_id | Unknown | FK |
group_id | Unknown | FK |
iteration_id | Unknown | FK |
project_id | Unknown | FK |
requested_by_id | Unknown | FK |
workflow_id | Unknown | FK |
workflow_state_id | Unknown | FK |
app_url | Unknown | |
archived | Unknown | |
blocked | Unknown | |
blocker | Unknown | |
completed | Unknown | |
completed_at | Unknown | |
completed_at_override | Unknown | |
created_at | Unknown | |
cycle_time | Unknown | |
deadline | Unknown | |
entity_type | Unknown | |
estimate | Unknown | |
external_id | Unknown | |
external_links | Json | |
global_id | Unknown | |
lead_time | Unknown | |
moved_at | Unknown | |
name | Unknown | |
num_tasks_completed | Unknown | |
position | Unknown | |
started | Unknown | |
started_at | Unknown | |
started_at_override | Unknown | |
stats_num_related_documents | Unknown | |
story_links | Unknown | |
story_template_id | Unknown | |
story_type | Unknown | |
updated_at | Unknown |
external_story_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_link_stories_id | Unknown | PKFK |
created_at | Unknown | |
entity_type | Unknown | |
object_id | Unknown | |
subject_id | Unknown | |
subject_workflow_state_id | Unknown | |
type | Unknown | |
updated_at | Unknown | |
verb | Unknown |
external_link_stories
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
entity_template_external_link | Unknown | FK |
created_at | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
full_name | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown | |
url | Unknown |
story_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
story_id | Unknown | PKFK |
value_id | Unknown | PKFK |
story_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_id | Unknown | PKFK |
story_comment_member_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_comment_id | Unknown | PKFK |
story_comment_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_comment_id | Unknown | PKFK |
story_comment_group_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_comment_id | Unknown | PKFK |
story_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
parent_id | Unknown | FK |
story_id | Unknown | FK |
app_url | Unknown | |
blocker | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
position | Unknown | |
text | Unknown | |
unblocks_parent | Unknown | |
updated_at | Unknown |
story_commit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
repository_id | Unknown | FK |
story_id | Unknown | FK |
author_email | Unknown | |
author_identity_entity_type | Unknown | |
author_identity_name | Unknown | |
author_identity_type | Unknown | |
created_at | Unknown | |
entity_type | Unknown | |
hash | Unknown | |
message | Unknown | |
timestamps | Unknown | |
updated_at | Unknown | |
url | Unknown |
story_task_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_task_id | Unknown | PKFK |
story_task_member_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_task_id | Unknown | PKFK |
story_task_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_task_id | Unknown | PKFK |
story_task_group_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_task_id | Unknown | PKFK |
story_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
story_id | Unknown | FK |
complete | Unknown | |
completed_at | Unknown | |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
position | Unknown | |
updated_at | Unknown |
story_branch_pr_vcs_label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
story_branch_pr_id | Unknown | FK |
color | Unknown | |
description | Unknown | |
entity_type | Unknown | |
name | Unknown |
story_branch_pr
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
repository_id | Unknown | FK |
story_branch_id | Unknown | FK |
branch_id | Unknown | |
branch_name | Unknown | |
closed | Unknown | |
created_at | Unknown | |
draft | Unknown | |
entity_type | Unknown | |
has_overlapping_stories | Unknown | |
merged | Unknown | |
num_added | Unknown | |
num_commits | Unknown | |
num_modified | Unknown | |
num_removed | Unknown | |
number | Unknown | |
overlapping_stories | Unknown | |
review_status | Unknown | |
target_branch_id | Unknown | |
target_branch_name | Unknown | |
title | Unknown | |
updated_at | Unknown | |
url | Unknown |
story_branch
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
repository_id | Unknown | FK |
story_id | Unknown | FK |
created_at | Unknown | |
deleted | Unknown | |
entity_type | Unknown | |
merged_branch_ids | Unknown | |
name | Unknown | |
persistent | Unknown | |
updated_at | Unknown | |
url | Unknown |
story_linked_file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_id | Unknown | FK |
story_file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_id | Unknown | FK |
story_label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
story_id | Unknown | PKFK |
story
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_id | Unknown | FK |
group_id | Unknown | FK |
iteration_id | Unknown | FK |
project_id | Unknown | FK |
requested_by_id | Unknown | FK |
story_template_id | Unknown | FK |
workflow_id | Unknown | FK |
workflow_state_id | Unknown | FK |
app_url | Unknown | |
archived | Unknown | |
blocked | Unknown | |
blocker | Unknown | |
completed | Unknown | |
completed_at | Unknown | |
completed_at_override | Unknown | |
created_at | Unknown | |
cycle_time | Unknown | |
deadline | Unknown | |
description | Unknown | |
entity_type | Unknown | |
estimate | Unknown | |
external_id | Unknown | |
external_links | Unknown | |
lead_time | Unknown | |
moved_at | Unknown | |
name | Unknown | |
position | Unknown | |
started | Unknown | |
started_at | Unknown | |
started_at_override | Unknown | |
stats | Unknown | |
story_type | Unknown | |
synced_item_external_id | Unknown | |
synced_item_url | Unknown | |
updated_at | Unknown |
workspace_member_group
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
workspace_member_id | Unknown | PKFK |
workspace_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
created_without_invite | Unknown | |
disabled | Unknown | |
entity_type | Unknown | |
global_id | Unknown | |
profile_deactivated | Unknown | |
profile_display_icon_created_at | Unknown | |
profile_display_icon_entity_type | Unknown | |
profile_display_icon_id | Unknown | |
profile_display_icon_updated_at | Unknown | |
profile_display_icon_url | Unknown | |
profile_email_address | Unknown | |
profile_entity_type | Unknown | |
profile_gravatar_hash | Unknown | |
profile_id | Unknown | |
profile_is_owner | Unknown | |
profile_mention_name | Unknown | |
profile_name | Unknown | |
profile_two_factor_auth_activated | Unknown | |
role | Unknown | |
state | Unknown | |
updated_at | Unknown |
linked_file_group_mention
| Column | Type | Keys |
|---|---|---|
group_mention_id | Unknown | PKFK |
linked_file_id | Unknown | PKFK |
linked_file_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
linked_file_id | Unknown | PKFK |
linked_file_member_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
linked_file_id | Unknown | PKFK |
linked_file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
uploader_id | Unknown | FK |
content_type | Unknown | |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
name | Unknown | |
size | Unknown | |
thumbnail_url | Unknown | |
type | Unknown | |
updated_at | Unknown | |
url | Unknown |
repository
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
entity_type | Unknown | |
external_id | Unknown | |
full_name | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown | |
url | Unknown |
workflow_state
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workflow_id | Unknown | PKFK |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
global_id | Unknown | |
name | Unknown | |
num_stories | Unknown | |
num_story_templates | Unknown | |
position | Unknown | |
type | Unknown | |
updated_at | Unknown | |
verb | Unknown |
workflow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_state_id | Unknown | FK |
project_id | Json | FK |
team_id | Unknown | FK |
auto_assign_owner | Unknown | |
created_at | Unknown | |
description | Unknown | |
entity_type | Unknown | |
name | Unknown | |
updated_at | Unknown |