Information Data Model
In the Information Data Model, the driver models licensing information and high-level overviews of the organizations, projects, and repositories associated with the authenticated account as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your GitHub account are immediately reflected in the driver.
Tables
The following Tables are shipped with the driver:
| Name | Description |
| EnterpriseAdminInvitations | Lists users who have been invited to join as GitHub Enterprise account administrators. |
| EnterpriseAdmins | Catalogs the administrators responsible for managing and maintaining a GitHub Enterprise account. |
| EnterpriseMembers | Lists all users who are members of a specified GitHub Enterprise account. |
| EnterpriseUnaffiliatedMemberInvitations | Tracks invitations sent to unaffiliated users to join a GitHub Enterprise account, aiding recruitment efforts. |
| Organizations | Contains comprehensive information about organizations linked either to the authenticated user or to a specified organization. |
| OrganizationTeams | Maintains a list of all teams within the user's organizations, supporting team management and collaboration. |
| ProjectStatusUpdates | Records project status updates, including any changes to goals or scope. |
| Repositories | Provides comprehensive details about user-owned or managed repositories, including configuration and metadata. |
| RepositoryBranches | Lists information about branches in repositories. |
| RepositoryCommits | Lists information about commits in repositories. |
| RepositoryCustomPropertySchemas | Gets all custom properties schemas for repositories. |
| RepositoryCustomPropertyValues | Lists organization repositories with all of their custom property values. |
| RepositoryIssueComments | Lists information about issue comments in repositories. |
| RepositoryIssues | Lists information about issues in repositories. |
| RepositoryPullRequests | Lists information about pull requests in repositories. |
Views
The following Views are shipped with the driver:
| Name | Description |
| Enterprises | Stores information about GitHub enterprises associated with the user, including identifiers and descriptive details. |
| LicenseConditions | Lists conditions and obligations imposed by a specific software license applied to a GitHub repository. |
| LicenseLimitations | Details restrictions and limitations imposed by a specific license in the context of a GitHub repository. |
| LicensePermissions | Describes permissions granted by a specific repository license, helping users understand the scope of allowed actions. |
| Licenses | Compiles all supported open-source licenses recognized by GitHub, aiding in license selection and compliance. |
| OrganizationIssueTypes | The organization's issue types. |
| OrganizationMannequins | Lists mannequin accounts (placeholders) linked to an organization for use in managing legacy contributions. |
| OrganizationMembers | Details all members and collaborators associated with the user's organizations or a specific organization. |
| OrganizationTeamMembers | Tracks team memberships within organizations, detailing roles and associated permissions for each member. |
| OrganizationTeamProjects | Lists projects accessible to specific teams within a GitHub organization, including details on collaboration and access rights. |
| OrganizationTeamRepositories | Tracks repositories that teams in an organization have access to, along with permission levels for each repository. |
| Projects | Holds metadata and organization-related details for GitHub projects, enabling structured project tracking. |
| RepositoryCodeScanningAnalyses | Lists code scanning analyses. |
| RepositoryLabels | Lists information about labels in repositories. |
| RepositoryReleases | Lists information about releases in repositories. |
| SecurityAdvisories | Lists GitHub Security Advisories. |
| SecurityAdvisoryCommonWeaknessEnumerations | Lists Common Weakness Enumerations (CWEs) associated with GitHub Security Advisories. |
| SecurityVulnerabilities | Lists software vulnerabilities documented by GitHub Security Advisories. |
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.
The following procedures are shipped with the driver:
| Name | Description |
| AddCollaborator | Adds a user to a repository with a specified permission level, updating existing access if necessary. Enterprise Managed Users are added directly, while others receive an invitation. |
| CloneTemplateRepository | Duplicates the files and structure of a template repository to create a new repository, streamlining the setup process for consistent project creation. |
| CommitCompare | Compares two commits against one another. You can compare references (branches or tags) and commit SHAs in the same repository, or you can compare references and commit SHAs that exist in different repositories within the same repository network, including fork branches. |
| CreateCommitOnBranch | Appends a commit to the given branch of the procedure's repository as the authenticated user. |
| DeleteCodeScanningAnalysis | Deletes an analysis by Id, or deletes the matched set of analyses in reverse chronological order. Deleting the final remaining analysis in a set requires explicitly confirming the deletion because it removes all associated historical alert data. |
| DeleteRepository | Delete a repository from GitHub. |
| DownloadFile | Facilitates downloading specific files from a GitHub repository for offline access or local reference. |
| GetCurrentlyAuthenticatedUser | Fetches comprehensive details about the currently authenticated GitHub user, including username and account preferences. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to GitHub. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| MergePullRequest | Automates the merging of an open pull request into the target branch, integrating proposed changes into the main codebase. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access token to maintain continuous authenticated access to GitHub resources without requiring reauthorization from the user. |
| RemoveCollaborator | Removes a collaborator from a repository, revoking their access, unstarring repositories, canceling invitations, unassigning issues, denying pull requests, updating related permissions and may delete forks. |
| UpdatePullRequestBranch | Merge or Rebase HEAD from upstream branch into pull request branch. |
| UploadFile | Enables users to upload files directly to a specified GitHub repository for collaborative purposes. |