1 of 1

Legend

πŸ”‘ = primary key

➀ = foreign key relation

⇱ = external link

issue_id πŸ”‘ ➀ ISSUE

related_issue_id πŸ”‘ ➀ ISSUE

relationship πŸ”‘

ISSUE_LINK ⇱

id πŸ”‘

done

name

key

summary

EPIC ⇱

​

​

id πŸ”‘

name

description

​

​

PROJECT_CATEGORY ⇱

id πŸ”‘

parent_id ➀ ISSUE

priority ➀ PRIORITY

resolution➀ RESOLUTION

security_level ➀ SECURITY_LEVEL

status ➀ STATUS

key

...other non-array system fields

ISSUE ⇱

id πŸ”‘

project_category_id ➀ PROJECT_CATEGORY

permission_scheme_id ➀ PERMISSION_SCHEME

lead_id ➀ USER

key

name

project_type_key

description

simplified

PROJECT ⇱

id πŸ”‘

project_id πŸ”‘ ➀ PROJECT

name

description

COMPONENT ⇱

id πŸ”‘

board_id ➀ BOARD

complete_date

end_date

goal

name

start_date

state

SPRINT ⇱

group_name πŸ”‘

user_id πŸ”‘ ➀ USER

USER_GROUP ⇱

id πŸ”‘

name

email

locale

time_zone

username

USER ⇱

id πŸ”‘

author_id ➀ USER

issue_id ➀ ISSUE

update_author_id ➀ USER

created

is_public

updated

COMMENT ⇱

​

id πŸ”‘

name

description

​

PERMISSION_SCHEME ⇱

id πŸ”‘

name

type

description

PERMISSION ⇱

id πŸ”‘

name

description

PROJECT_ROLE ⇱

_fivetran_id πŸ”‘

permission_scheme_id ➀ PERMISSION_SCHEME

permission_id ➀ PERMISSION

user_id ➀ USER

group_name ➀ USER_GROUP

project_role_id ➀ PROJECT_ROLE

user_custom_field ➀ FIELD�group_custom_field ➀ FIELD

type

PERMISSION_HOLDER ⇱

​

​

id πŸ”‘οΏ½project_id πŸ”‘ ➀ PROJECT

project_role_id πŸ”‘ ➀ PROJECT_ROLE

group_name ➀ USER_GROUP

user_id ➀ USER

​

​

PROJECT_ROLE_ACTOR ⇱

Jira Agile Add-On

id πŸ”‘

project_id ➀ PROJECT

archived

description

driver

name

overdue

released

release_date

start_date

VERSION ⇱

board_id πŸ”‘ ➀ BOARD

project_id πŸ”‘ ➀ PROJECT

PROJECT_BOARD ⇱

id πŸ”‘

Issue_id πŸ”‘ ➀ ISSUE

author_id ➀ USER

update_author_id ➀ USER

comment

started

updated

time_spend_seconds

WORKLOG ⇱

​

​

​

​

id πŸ”‘

name

type

​

​

​

​

BOARD ⇱

​

​

​

issue_id πŸ”‘ ➀ ISSUE

board_id πŸ”‘ ➀ BOARD

​

​

​

ISSUE_BOARD ⇱

​

​

id πŸ”‘

name

description

​

​

PRIORITY ⇱

​

​

id πŸ”‘

name

description

​

​

RESOLUTION ⇱

​

​

id πŸ”‘

name

​

​

STATUS_CATEGORY ⇱

​

​

id πŸ”‘

status_category_id ➀ STATUS_CATEGORY

name

description

​

​

STATUS ⇱

​

​

id πŸ”‘

name

description

subtask

​

​

ISSUE_TYPE ⇱

id πŸ”‘

default_level_id ➀ SECURITY_LEVEL

description

name

SECURITY_SCHEME ⇱

id πŸ”‘

description

name

SECURITY_LEVEL ⇱

level_id πŸ”‘ ➀ SECURITY_LEVEL

scheme_id πŸ”‘βž€ SECURITY_SCHEME

SECURITY_SCHEME_LEVEL ⇱

id πŸ”‘

description

is_array

is_custom

name

FIELD ⇱

field_id πŸ”‘ ➀ FIELD

issue_id πŸ”‘ ➀ ISSUE

time πŸ”‘

author_id ➀ USER

is_active

value

ISSUE_FIELD_HISTORY ⇱

_fivetran_id πŸ”‘

time πŸ”‘

field_id πŸ”‘ ➀ FIELD

issue_id πŸ”‘ ➀ ISSUE

author_id ➀ USER

is_active

value

ISSUE_MULTISELECT_HISTORY ⇱

id πŸ”‘

name

parent_id ➀ FIELD_OPTION

FIELD_OPTION ⇱

id πŸ”‘

is_shared

is_visible

name

title

TEAM

issue_id πŸ”‘ ➀ ISSUE

user_id πŸ”‘ ➀ USER

ISSUE_WATCHER ⇱

​

​

​

board_id πŸ”‘ ➀ BOARD

sprint_id πŸ”‘ ➀ SPRINT

​

​

​

SPRINT_BOARD ⇱

issue_id πŸ”‘ ➀ ISSUE

id πŸ”‘

application _name

application_type

global_id

object_status_resolved

object_summary

object_title

object_url

relationship

ISSUE_REMOTE_LINK ⇱

Jira Service Management

id πŸ”‘

name

ORGANIZATION ⇱

approval_id πŸ”‘ ➀ APPROVAL

approver_id πŸ”‘ ➀ USER

decision

APPROVER ⇱

id πŸ”‘

can_answer_approval

completed_date

created_date

final_decision

name

APPROVAL ⇱

id πŸ”‘

issue_type_id ➀ ISSUE_TYPE

project_id ➀ PROJECT

description

help_text

name

service_desk_id

REQUEST_TYPE ⇱

issue_id πŸ”‘ ➀ ISSUE

request_type_id πŸ”‘ ➀ REQUEST_TYPE

link

service_desk_id

REQUEST ⇱

_fivetran_id πŸ”‘

issue_id πŸ”‘ ➀ ISSUE

sla_id πŸ”‘

breached

elapsed_time

goal_duration

is_ongoing_cycle

paused

remaining_time

start_time

stop_time

within_calendar_hours

SLA ⇱

id πŸ”‘

name

SERVICE

idπŸ”‘

workspace_id πŸ”‘

schema_id ➀ ASSET_OBJECT_SCHEMA

color

description

name

removable

url16

ASSET_REFERENCE_TYPE ⇱

idπŸ”‘

workspace_id πŸ”‘

schema_id ➀ ASSET_OBJECT_SCHEMA

category

description

name

ASSET_SCHEMA_STATUS ⇱

idπŸ”‘

workspace_id πŸ”‘

can_manage

created

description

key

name

status

updated

ASSET_OBJECT_SCHEMA ⇱

idπŸ”‘

workspace_id πŸ”‘

schema_id ➀ ASSET_OBJECT_SCHEMA

abstract_object_type

created

description

inherited

name

parent_id

parent_object_type_inherited

position

type

updated

ASSET_OBJECT_TYPE ⇱

idπŸ”‘

workspace_id πŸ”‘

object_type_id ➀ ASSET_OBJECT_TYPE

reference_object_type_id ➀ ASSET_OBJECT_TYPE

reference_type_id ➀ ASSET_REFERENCE_TYPE

additional_value

default_type_id

default_type_name

description

editable

hidden

include_child_object_types

indexed

is_system

label

max_cardinality

min_cardinality

name

object_attribute_exists

options

position

ql_query

regex_validation

removable

sortable

suffix

summable

type

type_value

type_value_multi

unique_attribute

ASSET_OBJECT_TYPE_ATTRIBUTE ⇱

value_indexπŸ”‘

workspace_id πŸ”‘

object_id πŸ”‘βž€ ASSET_OBJECT

object_type_attribute_id πŸ”‘βž€ ASSET_OBJECT_TYPE_ATTRIBUTE

display_value

referenced_type

search_value

value

ASSET_OBJECT_TYPE_ATTRIBUTE_OBJECT ⇱

idπŸ”‘

workspace_id πŸ”‘

object_type_id ➀ ASSET_OBJECT_TYPE

created

key

label

link

name

timestamps

updated

ASSET_OBJECT ⇱

workspace_id πŸ”‘

issue_id πŸ”‘βž€ ISSUE

object_id πŸ”‘βž€ ASSET_OBJECT

ASSET_OBJECT_ISSUE ⇱

issue_id πŸ”‘ ➀ ISSUE

user_id πŸ”‘ ➀ USER

ISSUE_USER_VOTE ⇱

field_id πŸ”‘ ➀ FIELD

project_id πŸ”‘ ➀ PROJECT

FIELDS_PROJECT ⇱