ado_pulls

Details about pull requests in Azure DevOps

id Primary key: Unique identifier for the row.
source_id Foreign key: Identifier of the pull request in Azure DevOps
repository_id Foreign key: ID of the repository to which the pull request belongs
project_id Foreign key: ID of the project to which the pull request belongs
user_id Foreign key: ID of the user who created the pull request
title string: Name of the pull request
status string: Status of the pull request. One of: 'abandoned', 'active', 'completed', 'notSet'
head_ref string: The name of the source branch of the pull request.
base_ref string: The name of the target branch of the pull request.
created_at date: The date when the pull request was created.
closed_at date: The date when the pull request was closed (completed, abandoned, or merged externally).
merged_at date: The most recent date at which the pull request entered the queue to be completed.
draft boolean: Draft / WIP pull request.
merge_commit_sha string: The commit of the most recent pull request merge.
open_to_merge number: The difference (in seconds) between when the pull request was merged and created
open_to_first_review number: The difference (in seconds) between the first submitted review and the pull request created_at
open_to_first_approval number: Difference (in seconds) between first approval and created_at of pull request
ready_for_review date: Date at which the pull request was marked as ready-for-review (i.e., converted from draft state).
changed_files number: Number of files changed in the pull request
commits number: Number of commits in the pull request
source_url string: URL of the pull request