bitbucket_pulls

Details about Bitbucket pull requests

id Primary key: Unique identifier for the row.
source_id Foreign key: ID of the pull request in Bitbucket
repository_id Foreign key: ID of the repository to which the pull request belongs
user_id Foreign key: ID of the user who authored the pull request
merged_by_user_id Foreign key: ID of the user who merged the pull request
title string: Title of the pull request
state string: One of: OPEN, MERGED, DECLINED, SUPERSEDED
merged_at date: Timestamp of when the pull request is merged
source_branch string: Name of the branch with the pull request changes
target_branch string: Name of the branch the pull request is being merged in to
merge_commit_sha string: Commit SHA of the merge
source_commit_sha string: Commit SHA of the source branch head, as recorded on the pull request. Once merged, this is the final source commit. Bitbucket Cloud abbreviates it to 12 characters.
destination_commit_sha string: Commit SHA of the destination branch head, as recorded on the pull request. Once merged, this is the destination commit just before the merge. Bitbucket Cloud abbreviates it to 12 characters.
squashed_commit_shas array: Full SHAs of the original source branch commits that a squash merge replaced. Used only for AI code metrics; pull request commits, commit counts, and cycle time metrics use the squash commit. Null when the pull request has not been checked yet; empty when it was checked and there are no original commits to add, because it was not squash merged or its original commits could not be recovered.
rebased_commit_originals jsonb: Maps each commit on a merged pull request that was rebased while the pull request was open (for example by a merge queue or branch sync) to the commit it replaced, paired by patch ID. Same structure as pull_requests.rebased_commit_originals, which it is copied to. Used only for AI code metrics. Null when no rebased commits were found, or when the pull request has not been checked.
rebased_commits_checked_at date: When the merged pull request was checked for rebased commits. Null when it has not been checked yet.
draft boolean: Boolean indicating whether or not the pull request is marked as a "draft" request.
ready_for_review date: Date at which the pull request was marked as ready-for-review (i.e., converted from draft state).
created_at date: Timestamp of when the pull request creation
updated_at date: Timestamp of when the pull request was last updated
closed_at date: Timestamp of when the pull request was closed
open_to_merge number: Difference (in seconds) between merged_at and created_at
open_to_first_review number: Difference (in seconds) between first review creation and created_at of pull request
open_to_first_approval number: Difference (in seconds) between first approval and created_at of pull request
source_url string: URL of Bitbucket pull request
additions number: Number of additions in the pull request
deletions number: Number of deletions in the pull request
commits_synced_at date: Timestamp of when DX last synced commits for this pull request.
first_commit_at date: Timestamp of the earliest commit in this pull request.
timespent number: Estimated hours spent working on this pull request, calculated from commit timestamps.