Information Data Model
In the Information Data Model, the server 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 server.
Tables
The following Tables are shipped with the server:
| 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. |
Views
The following Views are shipped with the server:
| 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. |
| RepositoryPullRequests | Lists information about pull requests in repositories. |
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 server:
| Name | Description |
| CloneTemplateRepository | Duplicates the files and structure of a template repository to create a new repository, streamlining the setup process for consistent project creation. |
| 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. |
| UploadFile | Enables users to upload files directly to a specified GitHub repository for collaborative purposes. |