bitbucket_server_pulls

Details about Bitbucket pull requests

id

Primary key
Unique identifier for the row.

source_id

Foreign key
ID of the pull request

repository_id

Foreign key
ID of the repository to which the pull request belongs

user_id

Foreign key
ID of the author of the pull request

source_url

string
URL of the pull request

title

string
Title of the pull request

description

string
Description of the pull request

state

string
One of: 'OPEN', 'DECLINED' or 'MERGED'

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
Merge Commit SHA of the pull request

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
Creation date of the pull request

updated_at

date
Updated date of the pull request

closed_at

date
The date the pull request was closed via merge or by decline

synced_at

date
Timestamp of when the pull request was last synced.

open_to_merge

number
Difference (in seconds) between the merged_at and created_at

open_to_first_review

number
Difference (in seconds) between the first review's creation date and the created_at timestamp of the pull request

open_to_first_approval

number
Difference (in seconds) between the first approval's creation date and the created_at timestamp of the pull request

additions

number
Number of additions in the pull request

deletions

number
Number of deletions in the pull request