github_pulls

Detailed information and metrics about GitHub pull requests.

id Primary key: Unique identifier for the row.
source_id Foreign key: GitHub ID of the repository.
repository_id Foreign key: ID of the GitHub repository which this pull request was created for.
user_id Foreign key: ID of the user who created the pull request.
merged_by_user_id Foreign key: ID of the user who merged the pull request
closed_by_user_id Foreign key: ID of the user who closed the pull request.
number number: The pull request number for the repository.
title string: Title of the pull request.
head_ref string: Reference to the branch where the pull request changes are implemented. Typically a branch name.
base_ref string: Reference to the branch where changes would be pulled into. Typically a branch name.
created date: Date at which the pull request was created.
updated date: Most recent date at which the pull request was updated.
closed date: Date at which the pull request was closed. Present only if it is closed.
merged date: Date at which the pull request was merged. Present only if it was merged.
first_commit_at date: Timestamp of the first commit in the pull request.
ready_for_review date: Date at which the pull request was marked as ready-for-review (i.e., converted from draft state).
draft boolean: Boolean indicating whether or not the pull request is marked as a "draft" request.
merge_commit_sha string: Git commit SHA of the merge commit used to merge into the base branch.
rebased_commit_originals jsonb: Maps each pull request commit that was rebased by a force push while the pull request was open (for example by a merge queue or "Update branch") 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_event_id Foreign key: GraphQL node ID of the latest head_ref_force_pushed event checked for rebased commits, so the pull request is only checked again after another force push. Null when it has not been checked.
rebased_commits_retry_since date: When the check for rebased commits first failed temporarily (for example a GitHub server error). A scheduled job retries it for 30 days from then, even if the pull request is not synced again. Null when no retry is pending.
open_to_merge number: Time difference in seconds between a pull request being merged and being created.
open_to_first_review number: Time difference in seconds between the first review being submitted and the pull request being created. When "ready-for-review" is used, the calculation is instead the difference between the first review being submitted and the pull request being marked as "ready-for-review".
open_to_first_approval number: Time difference in seconds between a pull request being approved and being created.
additions number: Count of lines added in the pull request.
deletions number: Count of lines deleted in the pull request.
changed_files number: Count of files changed in the pull request.
commits number: Count of commits in the pull request.
timespent number: Estimated time spent working on the pull request in hours, calculated from commit history.
source_url string: URL directly to the pull request within GitHub.
description string: Description of the pull request.
synced_at date: Timestamp of when the pull request was last synced.
commits_synced_at date: Timestamp of when the commits for this pull request were last synced.