pull_requests

id

Primary key
Unique ID for the row.

additions

number
The number of lines added in the pull request.

base_ref

string
The name of the branch that the changes are being merged into.

bot_authored

boolean
Boolean indicating if the user is a bot. Also known as "Machine User".

closed

date
The date that the pull request was closed in the source system.

created

date
The date that the pull request was created in the source system.

deletions

number
The number of lines deleted in the pull request.

dx_versioned_team_member_id

Foreign key
The dx_versioned_team_members ID of the owner's team membership when the PR was created.

dx_user_id

Foreign key
The dx_users ID of the user that owns the pull request.

external_url

string
The URL to the pull request details in the source system.

external_id

Foreign key
The ID used by the source system.

head_ref

string
The name of the branch that the changes are coming from.

merge_commit_sha

string
Merge Commit SHA from the source system

merged

date
The date that the pull request was merged in the source system.

open_to_first_approval

number
The time difference in seconds between a pull request being approved and being created.

open_to_first_review

number
The time difference in seconds between the first review being submitted and the pull request being created.

open_to_merge

number
The time difference in seconds between the pull request being merged and being created.

ready_for_review_at

number
The date that a pull request was marked ready for review (put in open state).

weight

number
Weight of the pull request.

classification

string
Classification of the pull request.

draft

boolean
Boolean indicating if the pull request is a draft.

reverted

boolean
Boolean indicating if the pull request was reverted.

ai_attributes_set_by

string
User that set AI attributes.

ai_attributes_set_at

date
Date/time when AI attributes were set.

repo_id

Foreign key
The unique ID for the repo that owns the pull request

source

string
The name of the system that the pull request originated from.

source_table_id

Foreign key
The unique ID for the row in the source table that this pull request originated from.

source_table_repo_id

Foreign key
The unique ID for the row in the source specific repository/project table that this pull request relates to.

title

string
The title or summary of the pull request

updated

date
The date that the pull request was last updated in the source system.