# Shortcut schema ERD

Table and field reference for the Fivetran Shortcut connector.

## Table & Field Reference

### group_workspace_member

| Column | Type | Keys |
| --- | --- | --- |
| groups_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### group_workflow

| Column | Type | Keys |
| --- | --- | --- |
| groups_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| iteration_id | Unknown | PK, FK |
| associated_stories_count | Unknown |  |

### iteration_label

| Column | Type | Keys |
| --- | --- | --- |
| iteration_id | Unknown | PK, FK |
| label_id | Unknown | PK, FK |

### iteration_follower

| Column | Type | Keys |
| --- | --- | --- |
| iteration_id | Unknown | PK, FK |
| workspace_member_id | Unknown | PK, FK |

### iteration_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| iteration_id | Unknown | PK, FK |

### iteration_member_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| iteration_id | Unknown | PK, FK |

### iteration_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| iteration_id | Unknown | PK, FK |

### 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 | PK, FK |
| workspace_member_id | Unknown | PK, FK |

### 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 | PK, FK |
| group_id | Unknown | PK, FK |
| associated_stories_count | Unknown |  |

### epic_objective

| Column | Type | Keys |
| --- | --- | --- |
| objective_id | Unknown | PK |
| epic_id | Unknown | PK, FK |
| id | Unknown | FK |

### epic_label

| Column | Type | Keys |
| --- | --- | --- |
| epic_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_project

| Column | Type | Keys |
| --- | --- | --- |
| epic_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| objective_id | Unknown | PK, FK |

### 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 | PK, FK |
| id | Unknown | PK, FK |

### file_member_mention

| Column | Type | Keys |
| --- | --- | --- |
| file_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### file_group_mention

| Column | Type | Keys |
| --- | --- | --- |
| file_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### 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 | PK, FK |
| id | Unknown | PK, FK |

### entity_template_follower

| Column | Type | Keys |
| --- | --- | --- |
| entity_template_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### entity_template_owner

| Column | Type | Keys |
| --- | --- | --- |
| entity_template_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### 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 | PK, FK |
| id | Unknown | PK, FK |

### entity_template_linked_file

| Column | Type | Keys |
| --- | --- | --- |
| entity_template_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### entity_template_external

| Column | Type | Keys |
| --- | --- | --- |
| link | Unknown | PK |
| entity_template_id | Unknown | PK, FK |

### 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 | PK, FK |
| value_id | Unknown | PK, FK |

### epic_story_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| epic_story_id | Unknown | PK, FK |

### epic_story_file

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_previous_iteration

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_label

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_follower

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_owner

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_comment

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_linked_file

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_mention

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_member_mention

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### epic_story_group_mention

| Column | Type | Keys |
| --- | --- | --- |
| epic_story_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| value_id | Unknown | PK, FK |

### story_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_id | Unknown | PK, FK |

### story_comment_member_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_comment_id | Unknown | PK, FK |

### story_comment_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_comment_id | Unknown | PK, FK |

### story_comment_group_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_comment_id | Unknown | PK, FK |

### 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 | PK, FK |
| story_task_id | Unknown | PK, FK |

### story_task_member_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_task_id | Unknown | PK, FK |

### story_task_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_task_id | Unknown | PK, FK |

### story_task_group_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_task_id | Unknown | PK, FK |

### 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 | PK, FK |
| story_id | Unknown | FK |

### story_file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_id | Unknown | FK |

### story_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| story_id | Unknown | PK, FK |

### 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 | PK, FK |
| workspace_member_id | Unknown | PK, FK |

### 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 | PK, FK |
| linked_file_id | Unknown | PK, FK |

### linked_file_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| linked_file_id | Unknown | PK, FK |

### linked_file_member_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| linked_file_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 |  |

## Relationships

- group_workspace_member(id) → workspace_member(id)
- group_workspace_member(groups_id) → groups(id)
- group_workflow(id) → workflow(id)
- group_workflow(groups_id) → groups(id)
- authenticated_member(id) → workspace_member(id)
- custom_field_value(custom_field_id) → custom_field(id)
- iteration_associated_group(group_id) → groups(id)
- iteration_associated_group(iteration_id) → iteration(id)
- iteration_label(label_id) → label(id)
- iteration_label(iteration_id) → iteration(id)
- iteration_follower(workspace_member_id) → workspace_member(id)
- iteration_follower(iteration_id) → iteration(id)
- iteration_mention(id) → workspace_member(id)
- iteration_mention(iteration_id) → iteration(id)
- iteration_member_mention(id) → workspace_member(id)
- iteration_member_mention(iteration_id) → iteration(id)
- iteration_group(group_id) → groups(id)
- iteration_group(iteration_id) → iteration(id)
- iteration(group_mention_ids) → groups(id)
- project_follower(workspace_member_id) → workspace_member(id)
- project_follower(project_id) → project(id)
- project(workflow_id) → workflow(id)
- epic_associated_group(group_id) → groups(id)
- epic_associated_group(epic_id) → epic(id)
- epic_objective(epic_id) → epic(id)
- epic_objective(id) → objective(id)
- epic_label(id) → label(id)
- epic_label(epic_id) → epic(id)
- epic_project(id) → project(id)
- epic_project(epic_id) → epic(id)
- epic(requested_by_id) → workspace_member(id)
- epic(group_id) → groups(id)
- epic(epic_state_id) → epic_workflow_state(id)
- epic_comment(epic_id) → epic(id)
- epic_workflow_state(epic_workflow_id) → epic_workflow(id)
- epic_workflow(default_epic_state_id) → epic_workflow_state(id)
- objective_category(id) → category(id)
- objective_category(objective_id) → objective(id)
- file_mention(id) → workspace_member(id)
- file_mention(file_id) → file(id)
- file_member_mention(id) → workspace_member(id)
- file_member_mention(file_id) → file(id)
- file_group_mention(id) → groups(id)
- file_group_mention(file_id) → file(id)
- file(uploader_id) → workspace_member(id)
- entity_template_label(id) → label(id)
- entity_template_label(entity_template_id) → entity_template(id)
- entity_template_follower(id) → workspace_member(id)
- entity_template_follower(entity_template_id) → entity_template(id)
- entity_template_owner(id) → workspace_member(id)
- entity_template_owner(entity_template_id) → entity_template(id)
- entity_template_task(entity_template_id) → entity_template(id)
- entity_template_file(id) → file(id)
- entity_template_file(entity_template_id) → entity_template(id)
- entity_template_linked_file(id) → linked_file(id)
- entity_template_linked_file(entity_template_id) → entity_template(id)
- entity_template_external(entity_template_id) → entity_template(id)
- entity_template(author_id) → workspace_member(id)
- entity_template(group_id) → groups(id)
- entity_template(epic_id) → epic(id)
- entity_template(project_id) → project(id)
- entity_template(workflow_state_id) → workflow_state(id)
- epic_story_custom_field(value_id) → custom_field_value(id)
- epic_story_custom_field(story_id) → epic_story(id)
- epic_story_task(epic_story_id) → epic_story(id)
- epic_story_file(id) → file(id)
- epic_story_file(epic_story_id) → epic_story(id)
- epic_story_previous_iteration(id) → iteration(id)
- epic_story_previous_iteration(epic_story_id) → epic_story(id)
- epic_story_label(id) → label(id)
- epic_story_label(epic_story_id) → epic_story(id)
- epic_story_follower(id) → workspace_member(id)
- epic_story_follower(epic_story_id) → epic_story(id)
- epic_story_owner(id) → workspace_member(id)
- epic_story_owner(epic_story_id) → epic_story(id)
- epic_story_comment(id) → epic_comment(id)
- epic_story_comment(epic_story_id) → epic_story(id)
- epic_story_linked_file(id) → linked_file(id)
- epic_story_linked_file(epic_story_id) → epic_story(id)
- epic_story_mention(id) → epic_workflow(id)
- epic_story_mention(epic_story_id) → epic_story(id)
- epic_story_member_mention(id) → epic_workflow(id)
- epic_story_member_mention(epic_story_id) → epic_story(id)
- epic_story_group_mention(id) → epic_workflow(id)
- epic_story_group_mention(epic_story_id) → epic_story(id)
- epic_story(requested_by_id) → workspace_member(id)
- epic_story(group_id) → groups(id)
- epic_story(iteration_id) → iteration(id)
- epic_story(project_id) → project(id)
- epic_story(workflow_state_id) → workflow_state(id)
- epic_story(workflow_id) → workflow(id)
- epic_story(epic_id) → epic(id)
- external_story_link(external_link_stories_id) → external_link_stories(id)
- external_link_stories(entity_template_external_link) → entity_template_external(link)
- story_custom_field(value_id) → custom_field_value(id)
- story_custom_field(story_id) → story(id)
- story_owner(id) → workspace_member(id)
- story_owner(story_id) → story(id)
- story_comment_member_mention(id) → workspace_member(id)
- story_comment_member_mention(story_comment_id) → story_comment(id)
- story_comment_mention(id) → workspace_member(id)
- story_comment_mention(story_comment_id) → story_comment(id)
- story_comment_group_mention(id) → groups(id)
- story_comment_group_mention(story_comment_id) → story_comment(id)
- story_comment(author_id) → workspace_member(id)
- story_comment(parent_id) → story_comment(id)
- story_comment(story_id) → story(id)
- story_commit(author_id) → workspace_member(id)
- story_commit(repository_id) → repository(id)
- story_commit(story_id) → story(id)
- story_task_owner(id) → workspace_member(id)
- story_task_owner(story_task_id) → story_task(id)
- story_task_member_mention(id) → workspace_member(id)
- story_task_member_mention(story_task_id) → story_task(id)
- story_task_mention(id) → workspace_member(id)
- story_task_mention(story_task_id) → story_task(id)
- story_task_group_mention(id) → groups(id)
- story_task_group_mention(story_task_id) → story_task(id)
- story_task(story_id) → story(id)
- story_branch_pr_vcs_label(story_branch_pr_id) → story_branch_pr(id)
- story_branch_pr(repository_id) → repository(id)
- story_branch_pr(story_branch_id) → story_branch(id)
- story_branch(repository_id) → repository(id)
- story_branch(story_id) → story(id)
- story_linked_file(id) → linked_file(id)
- story_linked_file(story_id) → story(id)
- story_file(id) → file(id)
- story_file(story_id) → story(id)
- story_label(id) → label(id)
- story_label(story_id) → story(id)
- story(requested_by_id) → workspace_member(id)
- story(group_id) → groups(id)
- story(iteration_id) → iteration(id)
- story(epic_id) → epic(id)
- story(story_template_id) → entity_template(id)
- story(project_id) → project(id)
- story(workflow_state_id) → workflow_state(id)
- story(workflow_id) → workflow(id)
- workspace_member_group(group_id) → groups(id)
- workspace_member_group(workspace_member_id) → workspace_member(id)
- linked_file_group_mention(group_mention_id) → groups(id)
- linked_file_group_mention(linked_file_id) → linked_file(id)
- linked_file_mention(id) → workspace_member(id)
- linked_file_mention(linked_file_id) → linked_file(id)
- linked_file_member_mention(id) → workspace_member(id)
- linked_file_member_mention(linked_file_id) → linked_file(id)
- linked_file(uploader_id) → workspace_member(id)
- workflow_state(workflow_id) → workflow(id)
- workflow(default_state_id) → workflow_state(id)
- workflow(team_id) → project(team_id)
- workflow(project_id) → project(id)