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.
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.
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.