ado_work_items

Details about work items

id Primary key: Unique identifier for the row.
source_id Foreign key: The work item ID.
project_id Foreign key: ID of the project to which it belongs
area_path_id Foreign key: ID of the area path to which it belongs
work_item_type_id Foreign key: ID of the work item type to which it belongs
team_id Foreign key: ID of the team to which it belongs
work_item_type_state_id Foreign key: ID of the work item state to which it belongs
created_by_user_id Foreign key: ID of the user who created the work item
assigned_to_user_id Foreign key: ID of the user who is assigned the work item
closed_by_user_id Foreign key: ID of the user who is assigned the work item
source_url string: URL for the work item
title string: Title of the work item
story_points number: Number of points
due_date date: Dude date of the work item
created_at date: Creation date of the work item
started_at date: Activated date of the work item
completed_at date: Closed date of the work item
updated_at date: The changed date of the work item
cycle_time number: Difference between completed_at and started_at in seconds