jira_issues

Details of the issues within Jira.

id Primary key: Unique identifier for the row.
connection_id Foreign key: ID of the Data Cloud connection importing the issue.
source_id Foreign key: Jira ID of the issue
issue_type_id Foreign key: ID of the issue type of this issue.
project_id Foreign key: ID of the project for which this issue belongs.
resolution_id Foreign key: ID of the resolution for this issue, if any.
status_id Foreign key: ID of the status for this issue.
priority_id Foreign key: ID of the priority for this issue.
user_id Foreign key: ID of the user who is assigned to this issue.
creator_id Foreign key: ID of the user who created this issue.
source_url string: URL directly to the issue within Jira.
summary string: Issue title
key string: Identifier key from Jira of the issue.
parent_key string: Identifier key from Jira of the issue's parent issue.
story_points number: Number of story points assigned to the issue in Jira.
resolution_date date: Date at which the issue was resolved in Jira.
due_date date: Date which the issue is Due.
created_at date: Date which the issue was created.
updated_at date: Date which the issue was last updated.
cycle_time number: Time difference between when the issue was started (started_at) and the issue was resolved (resolved_at).
last_synced_at date: Date/time when the issue was last synced.
synced_at date: Date/time when the issue was synced.
started_at date: Earliest date at which the issue changed to a `indeterminate` status category. See `jira_statuses` table for status categories.
completed_at date: Latest date at which the issue changed to a `done` status category. See `jira_statuses` table for status categories.
deleted_at date: Date/time when the issue was deleted.
api_error_changelog_sync boolean: Whether there was an API error during changelog sync.