Github: Pull Requests

Description

• Basic information about pull_requests as well as additional fields about reviews and time between actions

Supported Data Sources

• GitHub

Columns

Type	Name	Description
INTEGER	issue_id	The unique ID of an issue.
STRING	body	the text body of the description of the pull request
DATETIME	closed_at	Timestamp of when the pull request was closed. NULL for pull requests that are still open
DATETIME	created_at	Timestamp of when the pull request was created
BOOLEAN	is_locked	Boolean indicating whether the issue is locked.
INTEGER	milestone_id	Foreign key that references the milestone.
INTEGER	issue_number	The number of the pull request. Unique within a repository, but not accross.
BOOLEAN	is_pull_request	Boolean indiciating whether the issue is a pull request.
INTEGER	repository_id	Foreign key that references the repository table
STRING	state	Whether the pull request is open or closed.
STRING	title	The title of the pull request
DATETIME	updated_at	Timestamp of when the issue was last updated
INTEGER	user_id	Foreign key that references the user table.
STRING	url_link	A link to the pull request on github.com
DECIMAL	days_issue_open	The number of days an issue has been open
INTEGER	number_of_times_reopened	Total number of times the issue was reopened
STRING	labels	The labels currently applied to the pull request
INTEGER	number_of_comments	The total number of comments included in the issue
STRING	repository	The repository that the pull request applies to
STRING	repository_team_names	An aggreate of the teams associated with the repository
STRING	assignees	Users who have been assigned to the pull request
STRING	creator_login_name	User that created the issue login name
STRING	creator_name	User that created the issue name.
STRING	creator_company	User that created the issue company name.
DECIMAL	hours_request_review_to_first_review	Number of hours between the first request for review and a review
DECIMAL	hours_request_review_to_first_action	Number of hours between the first request for review and any action besides dismissing the request
DECIMAL	hours_request_review_to_merge	Number of hours between the first request for review and the pull request being merged
DATETIME	merged_at	Timestamp of when the pull request was merged
STRING	reviewers	List of Users who reviewed the pull request
STRING	requested_reviewers	List of Users who were requested to review the pull request
INTEGER	number_of_reviews	Number of times a pull request was reviewed