github_review_requests

Detailed information and metrics about GitHub review requests.

id

Primary key
Unique identifier for the row.

source_id

Foreign key
GitHub ID of the review request.

pull_id

Foreign key
ID of the GitHub pull request which the review was requested.

requester_id

Foreign key
ID of the GitHub user who requested the review.

requested_reviewer_id

Foreign key
ID of the GitHub user who was requested to perform the review.

requested_team_id

Foreign key
ID of the GitHub team who was requested to review the pull request.

review_id

Foreign key
ID of the GitHub review which was submitted.

time_to_review

number
Time difference between when the review was requested and submitted in seconds.

time_to_review_business_hours

number
Time difference between when the review was requested and submitted in seconds during business hours. Business hours are considered 8 AM to 6 PM. The timezone of the reviewer is used for calculating business hours. If the timezone of the reviewer is not available, then the requester's timezone is used. If neither are available, then it will be the same value as time_to_review.

source_url

string
GitHub API url for the pull request event.

created

date
Date at which the review request was created.