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.