Information データモデル
In the Information Data Model schema, the 本製品 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 本製品.
Tables
The テーブル section, which details standard SQL tables, and the ビュー section, which lists read-only SQL tables, contain samples of what you might have access to in your GitHub account.
The following tables and views are shipped with the 本製品:
| Table | 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. |
| Enterprises | Stores information about GitHub enterprises associated with the user, including identifiers and descriptive details. |
| EnterpriseUnaffiliatedMemberInvitations | Tracks invitations sent to unaffiliated users to join a GitHub Enterprise account, aiding recruitment efforts. |
| 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. |
| OrganizationMannequins | Contains comprehensive information about organizations linked either to the authenticated user or to a specified organization. |
| OrganizationMembers | Contains comprehensive information about organizations linked either to the authenticated user or to a specified 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. |
| 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. |
| Projects | Holds metadata and organization-related details for GitHub projects, enabling structured project tracking. |
| 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. |
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.