Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
issue_id 🔑 ➤ ISSUE
related_issue_id 🔑 ➤ ISSUE
relationship 🔑
ISSUE_LINK ⇱
id 🔑
name
parent_id ➤ FIELD_OPTION
FIELD_OPTION ⇱
id 🔑
epic_link ➤ EPIC
parent_id ➤ ISSUE
priority ➤ PRIORITY
resolution➤ RESOLUTION
security_level ➤ SECURITY_LEVEL
status ➤ STATUS
key�...custom fields
ISSUE ⇱
issue_id 🔑 ➤ ISSUE
[field_names]
ISSUE_[FIELD_NAME] ⇱
issue_id 🔑 ➤ ISSUE
[field_names]
ISSUE_[FIELD_NAME]_HISTORY ⇱
Each array type field of an issue is created as a separate table
History of each field is a separate table
id 🔑
name
description
PROJECT_CATEGORY ⇱
id 🔑
project_category_id ➤ PROJECT_CATEGORY
permission_scheme_id ➤ PERMISSION_SCHEME
lead_id ➤ USER
key
name
project_type_key
description
PROJECT ⇱
issue_id 🔑 ➤ ISSUE
component_id 🔑 ➤ COMPONENT
ISSUE_COMPONENTS ⇱
id 🔑
project_id 🔑 ➤ PROJECT
name
description
COMPONENT ⇱
group_name 🔑
user_id 🔑 ➤ USER
USER_GROUP ⇱
id 🔑
name
locale
time_zone
username
USER ⇱
id 🔑
author_id ➤ USER
issue_id ➤ ISSUE
update_author_id ➤ USER
created
is_public
updated
COMMENT ⇱
id 🔑
name
STATUS_CATEGORY ⇱
id 🔑
status_category_id ➤ STATUS_CATEGORY
name
description
STATUS ⇱
id 🔑
name
description
PRIORITY ⇱
id 🔑
name
description
RESOLUTION ⇱
id 🔑
name
description
subtask
ISSUE_TYPE ⇱
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_name�group_custom_field_name
type
PERMISSION_HOLDER ⇱
user_custom_field_name and group_custom_field_name are references to an ISSUE_[FIELD_NAME] table that contains user_id’s or group_name’s that have this permission.
id 🔑�project_id 🔑 ➤ PROJECT
project_role_id 🔑 ➤ PROJECT_ROLE
group_name ➤ USER_GROUP
user_id ➤ USER
PROJECT_ROLE_ACTOR ⇱
id 🔑
project_id ➤ PROJECT
archived
description
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 🔑
issue_id 🔑 ➤ ISSUE
sla_id 🔑 ➤ ISSUE
breached
elapsed_time
goal_duration
is_ongoing_cycle
paused
remaining_time
start_time
stop_time
within_calendar_hours
SLA ⇱
issue_id 🔑 ➤ ISSUE
board_id 🔑 ➤ BOARD
ISSUE_BOARD ⇱
id 🔑
name
ORGANIZATION ⇱
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 🔑
is_shared
is_visible
name
title
TEAM
id 🔑
done
name
key
summary
EPIC ⇱
id 🔑
board_id ➤ BOARD
complete_date
end_date
name
start_date
SPRINT ⇱
id 🔑
name
type
BOARD ⇱
JIRA Agile Add-On
board_id 🔑 ➤ BOARD
sprint_id 🔑 ➤ SPRINT
SPRINT_BOARD ⇱