# Github: Pull Requests

## Description

* Basic information about pull\_requests as well as additional fields about reviews and time between actions

## Supported Data Sources

* <img src="https://fivetran.com/integrations/github/resources/github.svg" alt="" data-size="line"> 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                                                        |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/github-pull-requests.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.