# Jira schema ERD

Table and field reference for the Fivetran Jira connector.

## Table & Field Reference

### request

| Column | Type | Keys |
| --- | --- | --- |
| issue_id | Int | PK, FK |
| request_type_id | Int | FK |
| link | String |  |
| service_desk_id | Int |  |

### schedule_rotation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| schedule_id | String | FK |
| end_date | Instant |  |
| length | Int |  |
| name | String |  |
| start_date | Instant |  |
| time_restriction_restriction_end_day | String |  |
| time_restriction_restriction_end_hour | Int |  |
| time_restriction_restriction_end_min | Int |  |
| time_restriction_restriction_start_day | String |  |
| time_restriction_restriction_start_hour | Int |  |
| time_restriction_restriction_start_min | Int |  |
| time_restriction_type | String |  |
| type | String |  |

### status

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| status_category_id | Int | FK |
| description | String |  |
| name | String |  |

### issue_watcher

| Column | Type | Keys |
| --- | --- | --- |
| issue_id | Int | PK, FK |
| user_id | String | PK, FK |

### platform_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | String | PK |
| team_name | String |  |

### project_role_actor

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| group_id | String | FK |
| project_id | Int | FK |
| project_role_id | Int | FK |
| user_id | String | FK |
| group_name | String |  |

### issue_form

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| issue_id | Int | PK, FK |
| form_template_id | String |  |
| internal | Boolean |  |
| lock | Boolean |  |
| name | String |  |
| state_answers | String |  |
| state_status | String |  |
| state_visibility | String |  |
| submitted | Boolean |  |
| updated | Instant |  |
| design_** |  |  |

### worklog

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| issue_id | Int | PK, FK |
| author_id | String | FK |
| update_author_id | String | FK |
| comment | String |  |
| started | Instant |  |
| time_spent_seconds | Long |  |
| updated | Instant |  |

### epic

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| done | Boolean |  |
| key | String |  |
| name | String |  |
| summary | String |  |

### issue_field_history

| Column | Type | Keys |
| --- | --- | --- |
| time | Instant | PK |
| field_id | String | PK, FK |
| issue_id | Int | PK, FK |
| author_id | String | FK |
| is_active | Boolean |  |
| value | String |  |

### attachment_metadata

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK |
| index | Int | PK |
| author_id | String |  |
| content_url | String |  |
| created | String |  |
| file_size | Long |  |
| filename | String |  |
| label | String |  |
| media_type | String |  |
| mime_type | String |  |
| path | String |  |
| size | String |  |
| thumbnail_url | String |  |

### schedule_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| schedule_id | String | FK |
| type | String |  |

### component

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| project_id | Int | FK |
| description | String |  |
| name | String |  |

### project_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| description | String |  |
| name | String |  |

### request_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| service_desk_id | Int | PK |
| issue_type_id | Int | FK |
| project_id | Int | FK |
| description | String |  |
| help_text | String |  |
| name | String |  |

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| enabled | Boolean |  |
| name | String |  |
| team_id | String |  |
| timezone | String |  |

### resolution

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| description | String |  |
| name | String |  |

### field

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| dimension_table | String |  |
| is_array | Boolean |  |
| is_custom | Boolean |  |
| name | String |  |

### issue_link

| Column | Type | Keys |
| --- | --- | --- |
| relationship | String | PK |
| issue_id | Int | PK, FK |
| related_issue_id | Int | PK, FK |

### approver

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | Long | PK |
| approver_id | String | PK |
| decision | String |  |

### sprint

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| board_id | Int | FK |
| activated_date | Instant |  |
| complete_date | Instant |  |
| end_date | Instant |  |
| goal | String |  |
| name | String |  |
| start_date | Instant |  |
| state | String |  |

### project_board

| Column | Type | Keys |
| --- | --- | --- |
| board_id | Int | PK, FK |
| project_id | Int | PK, FK |

### asset_object_issue

| Column | Type | Keys |
| --- | --- | --- |
| workspace_id | String | PK |
| issue_id | Int | PK, FK |
| object_id | Int | PK, FK |

### issue_property

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| issue_id | Int | PK, FK |
| self | String |  |
| value | String |  |

### status_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String |  |

### user

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| email | String |  |
| is_active | Boolean |  |
| locale | String |  |
| name | String |  |
| time_zone | String |  |
| username | String |  |

### approval

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| can_answer_approval | Boolean |  |
| completed_date | Instant |  |
| created_date | Instant |  |
| final_decision | String |  |
| name | String |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| is_shared | Boolean |  |
| is_visible | Boolean |  |
| name | String |  |
| title | String |  |

### security_scheme

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| default_level_id | Int | FK |
| description | String |  |
| name | String |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK |
| user_id | String | PK, FK |
| group_name | String |  |

### issue_user_vote

| Column | Type | Keys |
| --- | --- | --- |
| issue_id | Int | PK, FK |
| user_id | String | PK, FK |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| archived_by_id | String | FK |
| lead_id | String | FK |
| permission_scheme_id | Int | FK |
| project_category_id | Int | FK |
| archived | Boolean |  |
| archived_date | Instant |  |
| description | String |  |
| key | String |  |
| name | String |  |
| project_type_key | String |  |
| simplified | Boolean |  |

### issue_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| description | String |  |
| hierarchy_level | Int |  |
| name | String |  |
| subtask | Boolean |  |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| parent_id | Int | FK |
| priority | Int | FK |
| resolution | Int | FK |
| security_level | Int | FK |
| status | Int | FK |
| key | Int |  |
| system_fields_** |  |  |

### issue_remote_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| issue_id | Int | PK, FK |
| application_name | String |  |
| application_type | String |  |
| global_id | String |  |
| relationship | String |  |
| object_** |  |  |

### alert_action

| Column | Type | Keys |
| --- | --- | --- |
| action | String | PK |
| alert_id | String | PK, FK |

### alert

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| acknowledged | Boolean |  |
| alias | String |  |
| count | Int |  |
| created_at | Instant |  |
| description | String |  |
| entity | String |  |
| integration_name | String |  |
| integration_type | String |  |
| last_occurred_at | Instant |  |
| message | String |  |
| owner | String |  |
| priority | String |  |
| seen | Boolean |  |
| snoozed | Boolean |  |
| snoozed_until | Instant |  |
| source | String |  |
| status | String |  |
| tiny_id | String |  |
| updated_at | Instant |  |

### field_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| parent_id | Int | FK |
| name | String |  |

### alert_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | String | PK |
| alert_id | String | PK, FK |

### escalation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| team_id | String | FK |
| description | String |  |
| enabled | Boolean |  |
| name | String |  |
| repeat_** |  |  |

### asset_object_type_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| workspace_id | String | PK |
| object_type_id | Int | FK |
| reference_object_type_id | Int | FK |
| reference_type_id | String | FK |
| additional_value | String |  |
| default_type_id | Int |  |
| default_type_name | String |  |
| description | String |  |
| editable | Boolean |  |
| hidden | Boolean |  |
| include_child_object_types | Boolean |  |
| indexed | Boolean |  |
| is_system | Boolean |  |
| label | Boolean |  |
| max_cardinality | Int |  |
| min_cardinality | Int |  |
| name | String |  |
| object_attribute_exists | Boolean |  |
| options | String |  |
| position | Int |  |
| ql_query | String |  |
| regex_validation | String |  |
| removable | Boolean |  |
| sortable | Boolean |  |
| suffix | String |  |
| summable | Boolean |  |
| type | Int |  |
| type_value | String |  |
| type_value_multi | String |  |
| unique_attribute | Boolean |  |

### version

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| project_id | Int | FK |
| archived | Boolean |  |
| description | String |  |
| driver | String |  |
| name | String |  |
| overdue | Boolean |  |
| release_date | LocalDate |  |
| released | Boolean |  |
| start_date | LocalDate |  |

### board

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String |  |
| type | String |  |

### sla

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| issue_id | Long | PK |
| sla_id | Long | PK |
| breached | Boolean |  |
| elapsed_time | Long |  |
| goal_duration | Long |  |
| is_ongoing_cycle | Boolean |  |
| paused | Boolean |  |
| remaining_time | Long |  |
| start_time | Instant |  |
| stop_time | Instant |  |
| within_calendar_hours | Boolean |  |

### incident_responder

| Column | Type | Keys |
| --- | --- | --- |
| responder_ari | String | PK |
| issue_id | Int | PK, FK |

### service

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |

### field_project

| Column | Type | Keys |
| --- | --- | --- |
| field_id | String | PK, FK |
| project_id | String | PK, FK |

### worklog_property

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| worklog_id | Int | PK, FK |
| self | String |  |
| value | String |  |

### issue_board

| Column | Type | Keys |
| --- | --- | --- |
| board_id | Int | PK, FK |
| issue_id | Int | PK, FK |

### asset_object

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| workspace_id | String | PK |
| object_type_id | Int | FK |
| created | Instant |  |
| key | String |  |
| label | String |  |
| link | String |  |
| name | String |  |
| timestamps | Long |  |
| updated | Instant |  |

### incident

| Column | Type | Keys |
| --- | --- | --- |
| issue_id | Int | PK, FK |
| priority_id | String | FK |
| status_id | String | FK |
| reporter_account_id | String |  |
| reporter_account_type | String |  |
| reporter_display_name | String |  |
| summary | String |  |

### request_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| request_id | Int | PK, FK |
| author_id | String | FK |
| body | String |  |
| created | Instant |  |
| public | Boolean |  |

### sprint_board

| Column | Type | Keys |
| --- | --- | --- |
| board_id | Int | PK, FK |
| sprint_id | Int | PK, FK |

### priority

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| description | String |  |
| name | String |  |

### asset_object_schema

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| workspace_id | String | PK |
| can_manage | Boolean |  |
| created | Instant |  |
| description | String |  |
| key | String |  |
| name | String |  |
| status | String |  |
| updated | Instant |  |

### asset_schema_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| workspace_id | String | PK |
| schema_id | Int | FK |
| category | Int |  |
| description | String |  |
| name | String |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| author_id | String | FK |
| issue_id | Int | FK |
| update_author_id | String | FK |
| body | String |  |
| created | Instant |  |
| is_public | Boolean |  |
| updated | Instant |  |
| visibility_identifier | String |  |
| visibility_type | String |  |
| visibility_value | String |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String |  |

### security_scheme_level

| Column | Type | Keys |
| --- | --- | --- |
| level_id | Int | PK, FK |
| scheme_id | Int | PK, FK |

### issue_multiselect_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| time | Instant | PK |
| field_id | String | PK, FK |
| issue_id | Int | PK, FK |
| author_id | String | FK |
| is_active | Boolean |  |
| value | String |  |

### permission_scheme

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| description | String |  |
| name | String |  |

### project_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| description | String |  |
| name | String |  |

### issue_field_rendered

| Column | Type | Keys |
| --- | --- | --- |
| field_id | String | PK, FK |
| issue_id | Int | PK, FK |
| value | String |  |

### asset_object_type_attribute_object

| Column | Type | Keys |
| --- | --- | --- |
| value_index | Int | PK |
| workspace_id | String | PK |
| object_id | Int | PK, FK |
| object_type_attribute_id | Int | PK, FK |
| display_value | String |  |
| referenced_type | Boolean |  |
| search_value | String |  |
| value | String |  |

### asset_object_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| workspace_id | String | PK |
| schema_id | Int | FK |
| abstract_object_type | Boolean |  |
| created | Instant |  |
| description | String |  |
| inherited | Boolean |  |
| name | String |  |
| parent_id | Int |  |
| parent_object_type_inherited | Boolean |  |
| position | Int |  |
| type | Int |  |
| updated | Instant |  |

### permission_holder

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| group_name | String | FK |
| permission_id | String | FK |
| permission_scheme_id | Int | FK |
| project_role_id | Int | FK |
| user_id | String | FK |
| type | String |  |

### escalation_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| escalation_id | String | PK, FK |
| condition | String |  |
| delay | Int |  |
| notify_type | String |  |
| recipient_id | String |  |
| recipient_type | String |  |

### security_level

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| description | String |  |
| name | String |  |

### alert_responder

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| alert_id | String | PK, FK |
| type | String |  |

### permission

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| name | String |  |
| type | String |  |

### asset_reference_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | String | PK |
| schema_id | Int | FK |
| color | String |  |
| description | String |  |
| name | String |  |
| removable | Boolean |  |
| url_16 | String |  |

## Relationships

- request(issue_id) → issue(id)
- request(request_type_id) → request_type(id)
- schedule_rotation(schedule_id) → schedule(id)
- status(status_category_id) → status_category(id)
- issue_watcher(issue_id) → issue(id)
- issue_watcher(user_id) → user(id)
- project_role_actor(project_id) → project(id)
- project_role_actor(project_role_id) → project_role(id)
- project_role_actor(user_id) → user(id)
- project_role_actor(group_id) → user_group(user_id)
- issue_form(issue_id) → issue(id)
- worklog(issue_id) → issue(id)
- worklog(update_author_id) → user(id)
- worklog(author_id) → user(id)
- issue_field_history(issue_id) → issue(id)
- issue_field_history(field_id) → field(id)
- issue_field_history(author_id) → user(id)
- schedule_participant(schedule_id) → schedule(id)
- component(project_id) → project(id)
- request_type(issue_type_id) → issue_type(id)
- request_type(project_id) → project(id)
- issue_link(issue_id) → issue(id)
- issue_link(related_issue_id) → issue(id)
- sprint(board_id) → board(id)
- project_board(board_id) → board(id)
- project_board(project_id) → project(id)
- asset_object_issue(issue_id) → issue(id)
- asset_object_issue(object_id) → asset_object(id)
- issue_property(issue_id) → issue(id)
- security_scheme(default_level_id) → security_level(id)
- user_group(user_id) → user(id)
- issue_user_vote(issue_id) → issue(id)
- issue_user_vote(user_id) → user(id)
- project(archived_by_id) → user(id)
- project(project_category_id) → project_category(id)
- project(lead_id) → user(id)
- project(permission_scheme_id) → permission_scheme(id)
- issue(parent_id) → issue(id)
- issue(priority) → priority(id)
- issue(resolution) → resolution(id)
- issue(security_level) → security_level(id)
- issue(status) → status(id)
- issue_remote_link(issue_id) → issue(id)
- alert_action(alert_id) → alert(id)
- field_option(parent_id) → field_option(id)
- alert_tag(alert_id) → alert(id)
- escalation(team_id) → platform_team(team_id)
- asset_object_type_attribute(object_type_id) → asset_object_type(id)
- asset_object_type_attribute(reference_object_type_id) → asset_object_type(id)
- asset_object_type_attribute(reference_type_id) → asset_object_type(id)
- version(project_id) → project(id)
- incident_responder(issue_id) → incident(issue_id)
- field_project(field_id) → field(id)
- field_project(project_id) → project(id)
- worklog_property(worklog_id) → worklog(id)
- issue_board(issue_id) → issue(id)
- issue_board(board_id) → board(id)
- asset_object(object_type_id) → asset_object_type(id)
- incident(issue_id) → issue(id)
- incident(priority_id) → priority(id)
- incident(status_id) → status(id)
- request_comment(request_id) → request(issue_id)
- request_comment(author_id) → user(id)
- sprint_board(board_id) → board(id)
- sprint_board(sprint_id) → sprint(id)
- asset_schema_status(schema_id) → asset_object_schema(id)
- comment(issue_id) → issue(id)
- comment(author_id) → user(id)
- comment(update_author_id) → user(id)
- security_scheme_level(scheme_id) → security_scheme(id)
- security_scheme_level(level_id) → security_level(id)
- issue_multiselect_history(issue_id) → issue(id)
- issue_multiselect_history(field_id) → field(id)
- issue_multiselect_history(author_id) → user(id)
- issue_field_rendered(issue_id) → issue(id)
- issue_field_rendered(field_id) → field(id)
- asset_object_type_attribute_object(object_id) → asset_object(id)
- asset_object_type_attribute_object(object_type_attribute_id) → asset_object_type_attribute(id)
- asset_object_type(schema_id) → asset_object_schema(id)
- permission_holder(permission_scheme_id) → permission_scheme(id)
- permission_holder(permission_id) → permission(id)
- permission_holder(user_id) → user(id)
- permission_holder(group_name) → user_group(user_id)
- permission_holder(project_role_id) → project_role(id)
- escalation_rule(escalation_id) → escalation(id)
- alert_responder(alert_id) → alert(id)
- asset_reference_type(schema_id) → asset_object_schema(id)