Schema for Jira family of products

assignee_type

No

String

PROJECT_LEAD , UNASSIGNED

The default issue assignee setting for the project

category_id

No

String

TBD

An identifier of a project category, links to a record in the jira_project_category table

description

Yes

String

This is a sample project for demo purposes

Project description

key

Yes

String

TEST

Unique key for this project

lead_account_id

No

String

<accountId>

An identifier of a user who is defined as the project lead

name

Yes

String

Sample Test Project

Project name

project_id

No

String

<workspace_id>::<project_ref>

Unique project identifier. This is the Primary Key for project data.

project_ref

No

String

10010

The project identifier within a Jira site. It can be used to associate this record with the project identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

project_status

No

String

active

Status of the project

project_type

Yes

String

business, software, service_desk

Type of the project

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

style

No

String

classic, next-gen

• classic = company-managed project

• next-gen = team-managed project

url

No

String

https://example.atlassian.net/browse/TEST

A URL pointing to the project

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

category_id

No

String

TBD

Identifier of a project category. This is the Primary Key for category data.

category_ref

No

String

10002

The category identifier within a Jira site. It can be used to associate this record with the category identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

description

Yes

String

This is a sample project category for demonstration purposes

The project category description

name

Yes

String

Sample Project Category

The project category name

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

assignee_type

String

PROJECT_DEFAULT, UNASSIGNED

component_id

No

String

<workspace_id>::<component_ref>

Identifier of a project component. This is the Primary Key for component data.

component_ref

No

String

10002

The component identifier within a Jira site. It can be used to associate this record with the component identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

description

Yes

String

This is a sample component for demonstration purposes

The current status of this project component

lead_account_id

No

String

<accountId>

The user identifier of the component lead

name

Yes

String

Sample component name

The name of the project component

project_id

No

String

<workspace_id>::<project_ref>

Unique project identifier. Links to a record in the jira_project table.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

workspace_id

No

String

e72e07cb-8532-4e43-b4b1-68f9fc38ec7b

Unique site identifier

description

Yes

String

Sample description

Project version description

name

Yes

String

Version 2.0

The name of the project version

project_id

No

String

<workspace_id>::<project_ref>

Unique project identifier. Links to a record in the jira_project table.

release_date

No

Date

2020-12-31

The version’s release date

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

sort_order

No

Number

2

The sequence order of versions, matching their order of appearance in the user interface

start_date

No

Date

2020-12-06

The version’s start date

status

Yes

String

unreleased, released,archived

The current status of this project version

version_id

No

String

<workspace_id>::<version_ref>

Identifier of a project version. This is the Primary Key for version data.

version_ref

No

String

10002

The version identifier within a Jira site. It can be used to associate this record with the version identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

field_id

No

String

<workspace_id>::<field_ref>

The identifier of a Jira field. This is the Primary Key for Jira field data.

field_ref

No

String

assignee, customfield_12345

The field identifier within a Jira site. It can be used to associate this record with the field identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

key

Yes

String

assignee, customfield_12345

The key of a Jira field. The key can hold a different value to the ID when it is defined by plugins.

name

Yes

String

Assignee, Change type

The name of the field

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

type

Yes

String

assignee, com.atlassian.jira.plugin.system.customfieldtypes:textfield

The data type stored in the field

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

field_id

No

String

<workspace_id>::<customfield_id>

The identifier of a Jira field that the field option pertains to. Links to a record in the jira_field_metadata table.

field_ref

No

String

customfield_12345

The field identifier within a Jira site. It can be used to associate this record with the field identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

option_id

No

String

<workspace_id>::<field_id>::<field_option_ref>

A globally unique identifier of a Jira field option

option_ref

No

String

10004

The field option identifier within a Jira site. For custom fields that use field options, the value field in the jira_issue_field table will have an option_ref value. When working across multiple Jira sites, use it together with workspace_id to ensure uniqueness.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

value

Yes

String

Normal

The content of the field option

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

assignee_account_id

No

String

<accountId>

Unique identifier of the assignee

created_at

No

Datetime

2019-05-08 06:41:40.707000000

Issue creation time (UTC time zone)

creator_account_id

No

String

<accountId>

The identifier of the user who created the issue

description

Yes

String

This is a sample issue for demo purposes.

Description of the issue

due_date

Yes

Datetime

2019-05-24 00:00:00.000000000

The issue due date (UTC time zone)

environment

Yes

String

linux

A short description of the environment in which the issue occurred

issue_id

No

String

<workspace_id>::<issue_ref>

Unique identifier of this issue. This is the Primary Key for issue data.

issue_number

No

Number

12

The issue’s number within the project

issue_ref

No

String

10012

The issue identifier within a Jira site. It can be used to associate this record with the issue identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

issue_type_id

No

String

<workspace_id>::<issue_type_ref>

The identifier of the issue type. Links to a record in the jira_issue_type table.

labels

Yes

Array

[test-label, test2-label]

Array of label names

original_time_estimate_secs

No

Number

2000

Original estimate (in seconds) that was set (requires time-tracking enabled)

priority_id

No

String

<workspace_id>::<priority_ref>

Identifier of the current issue priority. Links to a record in the jira_issue_priority table.

project_id

No

String

<workspace_id>::<project_ref>

The identifier of the project. Links to a record in the jira_project table.

reporter_account_id

No

String

<accountId>

Unique identifier of the issue reporter

resolution_at

No

Datetime

2019-05-23 23:31:18.913000000

Issue resolution time (UTC time zone)

resolution_id

No

String

<workspace_id>::<resolution_ref>

Identifier of the issue resolution. Links to a record in the jira_issue_resolution table.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

status_id

No

String

<workspace_id>::<status_ref>

Identifier of the current issue status. Links to a record in the jira_issue_status table.

summary

Yes

String

This is a sample issue for demonstration purposes

Summary for the issue

time_estimate_secs

No

Number

5000

Estimate time (in seconds) remaining from original estimate (requires time-tracking enabled)

time_spent_secs

No

Number

2000

Amount of logged work (in seconds). Field is NULL if there is no time spent. (requires time-tracking enabled)

updated_at

No

Datetime

2019-05-23 23:31:18.940000000

Last issue update time (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

issue_id

No

String

TBD

Unique identifier of an issue. Links to a record in the jira_issue table.

row_refreshed_at

No

TIMESTAMP

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

version_id

No

String

TBD

Unique identifier of a project version affected by the issue. Links to a record in the jira_project_version table.

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

component_id

No

String

TBD

Unique identifier of a project component. Links to a record in the jira_project_component table.

issue_id

No

String

TBD

Unique identifier of an issue. Links to a record in the jira_issue table.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

field_id

No

String

<workspace_id>::<field_ref>

The identifier of a Jira field. Use it together with the issue_id as Primary Key for issue field data. Links to a record in the jira_field_metadata table.

issue_id

No

String

<workspace_id>::<issue_ref>

Unique identifier of this issue. Use it together with the field_id as Primary Key for issue field data.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

value

Yes

String

example field value

The contents of the field for this issue. The type of data represented by this string will depend on the field.

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

issue_id

No

String

<workspace_id>::<issue_ref>

Unique identifier of an issue. Links to a record in the jira_issue table.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

version_id

No

String

<workspace_id>::<version_ref>

Unique identifier of a project version which is the fix version of the issue. Links to a record in the jira_project_version table.

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

author_account_id

No

String

<accountId>

The identifier of the user who applied the changes

changelog_id

No

String

<workspace_id>::<issue_ref>::<>

An identifier for a group of issue updates

created_at

No

Datetime

2020-03-30 19:54:40.059000000

The time of the issue changes (UTC time zone)

field

Yes

String

Sprint

The name of the field that was updated

field_id

No

String

<workspace_id>::<field>

The identifier of the field that was updated

field_type

String

jira, custom

Indicates whether it is a default Jira field or a custom field

from

Yes

String

74

The value of the field before the change

from_string

Yes

String

Sprint 1

A string representing the value of the field before the change

issue_id

No

String

<workspace_id>::<issue_ref>

The identifier of the issue that was updated. Links to a record in the jira_issue table.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

to

Yes

String

76

The value of the field after the change

to_string

Yes

String

Sprint1, Sprint2

A string representing the value of the field after the change

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

name

Yes

String

Minor

The name of this priority

priority_id

No

String

<workspace_id>::<priority_ref>

Unique identifier of this priority. This is the Primary Key for priority data.

priority_ref

No

String

10001

The priority identifier within a Jira site. It can be used to associate this record with the priority identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

sort_order

No

Number

2

The sequence order of priorities, matching their order of appearance in the user interface

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

description

Yes

String

The problem is a duplicate of an existing issue.

A description of the resolution status

name

Yes

String

Duplicate

The resolution display name

resolution_id

No

String

<workspace_id>::<resolution_ref>

Unique identifier of this resolution. This is the Primary Key for issue resolution data.

resolution_ref

No

String

10002

The resolution identifier within a Jira site. It can be used to associate this record with the resolution identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

sort_order

No

Number

2

The sequence order of resolutions, matching their order of appearance in the user interface

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

name

Yes

String

To Do

The name of the status

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

sort_order

No

Number

2

The sequence order of statuses, matching their order of appearance in the user interface

status_category_id

No

String

2

The category of this status. Links to a record in the jira_issue_status_category table

status_id

No

String

<workspace_id>::<status_ref>

Unique identifier of this status. This is the Primary Key for status data.

status_ref

No

String

10002

The status identifier within a Jira site. It can be used to associate this record with the status identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

color_name

Yes

String

yellow

The color associated with this status category

key

Yes

String

indeterminate

The key associated with status category

name

Yes

String

In progress

The status category name

sort_order

No

Number

3

The sequence order of status categories. To do comes before In progress, which comes before Done.

status_category_id

No

String

2

Unique identifier of this status category. This is the Primary Key for status category data.

description

Yes

String

Subtasks track small pieces of work that are part of a larger task.

A description of the issue type

issue_type_id

No

String

<workspace_id>::<issue_type_ref>

Unique identifier of this issue type. This is the Primary Key for issue type data.

issue_type_ref

No

String

10094

The issue type identifier within a Jira site. It can be used to associate this record with the issue type identifier in Jira’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

name

Yes

String

Subtask

The name of the issue type

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

created_at

No

Datetime

2021-02-14 23:50:39.984000000

Service creation time (UTC time zone)

description

Yes

String

This is a service.

Service description

name

Yes

String

Email service

Service name

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

service_id

No

String

tbd

Unique identifier of this service. This is the Primary Key for service data.

tier

String

Tier 1

Tier indicating service criticality

type

String

Business, Technical

Service type

updated_at

No

Datetime

2021-02-14 23:50:39.984000000

Service last updated time (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

service_id

No

String

tbd

Unique identifier of a service. Links to a record in the atlassian_service table.

issue_id

No

String

<workspace_id>::<issue_ref>

Unique identifier of an issue. Links to a record in the jira_issue table.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

issue_id

No

String

<workspace_id>::<issue_ref>

The identifier of the issue that the CSAT response refers to. Links to a record in the jira_issue table.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

satisfaction_rating

Number

2

Rating given as part of a JSM Issue Satisfaction survey

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

issue_id

No

String

<workspace_id>::<issue_ref>

Unique identifier of an issue representing an incident. Links to a record in the jira_issue table.

responder_id

No

String

ari:cloud:identity::user/<userId>

or

ari:cloud:opsgenie:<siteId>:team/<opsgenieTeamId>

Unique identifier of the incident responder

type

No

String

User, Team

Type of responder

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

description

Yes

String

Get IT Help

A description of the request type 

issue_type_id

No

String

<workspace_id>::<issue_type_ref>

Associated issue type. Links to a record in the jira_issue_type table.

name

Yes

String

Get IT Help

The name of the request type

request_type_id

No

String

<workspace_id>::<request_type_ref>

Unique identifier of this request type. This is the Primary Key for request type data.

request_type_ref

No

String

25

The request type identifier within a Jira site. It can be used to associate this record with the request type identifier in JSM’s REST APIs and URLs, but does not guarantee uniqueness across multiple workspaces.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier

breached

No

String

true, false, null

Indicates whether the SLA was breached. For ongoing cycles, this value may change over time, along with remaining_time_msecs.

cycle_type

String

Ongoing, Completed

Indicates whether the current SLA cycle is ongoing or completed

elapsed_time_msecs

No

Number

14400000

Represents the time (in milliseconds) that has passed since the SLA cycle started

goal_duration_msecs

No

Number

14400000

Represents time (in milliseconds) taken to complete the current cycle. Only available for Completed cycles.

issue_id

No

String

<workspace_id>::<issue_ref>

Unique identifier of an issue. Links to a record in the jira_issue table. Use it together with the sla_id as Primary Key for issue SLA data.

paused

No

String

true, false, null

Indicates whether the SLA cycle is paused or not. Only available for Completed cycles.

remaining_time_msecs

No

Number

14400000

Represents the time (in milliseconds) remaining before the expected SLA limit is breached.

Remaining times are calculated and updated every 30 minutes. Therefore, the provided value may not represent the actual current remaining time.

row_refreshed_at

No

Datetime

2021-02-14 23:50:39.984000000

Last refresh time for this record (UTC time zone)

sla_id

No

String

15364

Unique identifier of a Service Level Agreement setting. Use it together with the issue_id as Primary Key for issue SLA data.

sla_name

Yes

String

Time to resolution

Name of the SLA that the SLA cycle belongs to

started_at

No

Datetime

2021-02-14 23:50:39.984000000

Start time of the SLA cycle (UTC time zone)

stopped_at

No

Datetime

2021-02-14 23:50:39.984000000

Time when the SLA cycle transitioned from Ongoing to Completed (UTC time zone). Only available for Completed cycles.

workspace_id

No

String

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

36-character unique site identifier