ado_work_item_iteration_paths

Record of iteration paths applied to work items in Azure DevOps

id

Primary key
Unique identifier for the row.

project_id

Foreign key
ID of the project to which the work item belongs

iteration_path_id

Foreign key
ID of the iteration path applied to the work item

work_item_id

Foreign key
ID of the work item which the iteration path is applied

planned

boolean
Boolean indicating if the work item was planned for the iteration

planned_points

number
Number of story points planned for the work item in the iteration, if the work item was planned

deleted_at

date
Date at which the work item was removed from the iteration, if ever