issues

A unified table of your issue data from various sources.

id

Primary key
Unique identifier for the row.

source

string
Source system where the issue was created.

source_id

Foreign key
ID of the issue in the source system.

state

string
State of the issue (e.g. 'backlog', 'in progress', 'completed').

source_url

string
Direct URL to the issue in the source system.

dx_user_id

Foreign key
DX ID of the user associated with the issue.

title

string
Title of the issue.

created

date
Date the issue was created.

started

date
Date the issue was started.

updated

date
Date the issue was last updated.

completed

date
Date the issue was completed.

cycle_time

number
Cycle time of the issue in seconds.

row_created_at

date
Timestamp when the row was created.

row_updated_at

date
Timestamp when the row was last updated.

source_table_id

Foreign key
ID of the source table.

external_id

Foreign key
External ID of the issue.

external_url

string
External URL of the issue.

cancelled

boolean
Boolean indicating if the issue was cancelled.

deleted

boolean
Boolean indicating if the issue was deleted.