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
iteration_path_id Foreign key: ID of the iteration 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
parent_source_id Foreign key: Source identifier of the parent work item, if any
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
severity string: Severity of the work item (e.g., "1 - Critical", "2 - High")
effort number: Effort value of the work item
priority number: Priority of the work item (1-4)
business_value number: Business value score of the work item
acceptance_criteria string: Acceptance criteria of the work item
remaining_work number: Remaining work in hours for the work item
deleted_at date: Date/time when the work item was deleted.
synced_at date: Timestamp of when the work item was last synced.