ado_work_item_state_changes

Details about when a work item changes state. Changes to a work item not involving state are not stored

id

Primary key

Unique identifier for the row.

work_item_id

Foreign key

ID of the work item

from_state_id

Foreign key

ID of the work item type state it began with

revision

number

The revision number of the state change

to_state_id

Foreign key

ID of the work item type state it ended with

status_change_date

date

Date of the change of state