Repository Data Model
In the Repository Data Model schema, the add-in models each repository associated with the authenticated account as a schema. Live connectivity to these objects means that any changes to your GitHub account are immediately reflected in the add-in.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your GitHub account.
Common tables include:
| Table | Description |
| Issues | Stores comprehensive details about issues in a repository, including labels, assignees, priorities, and statuses. |
| PullRequests | Contains metadata about pull requests in a repository, such as their titles, descriptions, current statuses, and authors, to manage proposed changes effectively. |
| Commits | Contains metadata for commits in a repository, including author information, timestamps, and commit messages for version tracking. |
| Branches | Contains detailed information about branches in a repository, including branch names, active statuses, and their relationships with other branches for version control. |
| Collaborators | Lists collaborators in a repository, including their roles, permissions, and contributions to the project. |
| Forks | Provides metadata about forks created from a repository, including fork ownership and purpose, to support collaboration and innovation. |
| Labels | Maintains a catalog of labels available in a repository, enabling effective categorization and filtering of issues and pull requests. |
| Milestones | Details milestones in a repository, including their goals, deadlines, and associated issues or pull requests for project tracking. |
| Releases | Tracks versioned releases in a repository, detailing associated tags, descriptions, and links to attached assets. |
| Stargazers | Lists users who have starred a repository, indicating their interest in or support for the project. |
| Watchers | Tracks users watching a repository, providing visibility into who is monitoring updates, changes, and activity. |
| IssueComments | Logs comments added to issues, capturing discussions, updates, and resolutions for tracking purposes. |
| PullRequestComments | Records comments on pull requests, documenting feedback and discussions during the code review process. |
| PullRequestReviews | Stores details of reviews conducted on pull requests, including reviewer actions (approved, requested changes, commented) and timestamps. |
| PullRequestReviewComments | Logs comments made during pull request reviews, capturing feedback, suggestions, and discussions for improving the code. |
| PullRequestCommits | Provides a list of commits included in pull requests, detailing the changes introduced and the commits' authors. |
| PullRequestFiles | Tracks files modified within pull requests, listing filenames, change types, and details for thorough review. |
| AssignableUsers | Identifies users who are eligible to be assigned to repository issues, based on their roles and permissions. |
| MentionableUsers | Identifies users who can be mentioned in repository discussions, including issues, pull requests, and comments, based on permissions. |
| Environments | Lists deployment environments configured for a repository, including environment names, statuses, and related configuration data. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including getting the currently authenticated user or retrieving and refreshing OAuth access tokens.