jira_issue_time_entries

Record of time spent on Jira issues (worklogs). This is a conditional schema that must be enabled.

id

Primary key
Unique identifier for the row.

source_id

Foreign key
Jira worklog ID.

issue_id

Foreign key
ID of the issue that the time entry is logged against.

user_id

Foreign key
ID of the Jira user who logged the time.

time_spent_seconds

number
Time spent on the issue in seconds.

started_at

date
When the work was started.