Enterprises
Stores information about GitHub enterprises associated with the user, including identifiers and descriptive details.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- Slug supports the '=,IN' comparison operators.
- MembershipType supports the '=,IN' comparison operators.
- Login supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [Enterprises]
SELECT * FROM [Enterprises] WHERE [Slug] = 'Val1'
SELECT * FROM [Enterprises] WHERE [MembershipType] = 'ALL'
SELECT * FROM [Enterprises] WHERE [Login] = 'Val1'
The 本製品 processes other filters client-side within the 本製品.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier (node ID) of the Enterprise object. | ||
| UserId | String | The unique identifier (node ID) of the User associated with the enterprise. | ||
| Location | String | The physical or geographical location of the enterprise, as specified in its profile. | ||
| Name | String | The name of the enterprise, as displayed in its profile. | ||
| DatabaseId | Int | The primary key identifier for the enterprise in the database. | ||
| Announcement | String | The text of the current enterprise-wide announcement. | ||
| AnnouncementCreatedAt | Datetime | The date and time when the announcement was created, in ISO 8601 format. | ||
| AnnouncementExpiresAt | Datetime | The expiration date and time of the announcement, if specified. | ||
| AnnouncementUserDismissible | Bool | Indicates whether users can dismiss the announcement from their view. | ||
| BillingEmail | String | The billing email address associated with the enterprise. | ||
| BillingInfoAllLicensableUsersCount | Int | The total number of licensable users or email addresses within the enterprise. | ||
| BillingInfoAssetPacks | Int | The number of data packs used by all organizations owned by the enterprise. | ||
| BillingInfoBandwidthQuota | Double | The total bandwidth quota (in GB) allocated to all organizations owned by the enterprise. | ||
| BillingInfoBandwidthUsage | Double | The total bandwidth usage (in GB) by all organizations owned by the enterprise. | ||
| BillingInfoBandwidthUsagePercentage | Int | The percentage of the bandwidth quota currently used by the enterprise. | ||
| BillingInfoStorageQuota | Double | The total storage quota (in GB) allocated to all organizations owned by the enterprise. | ||
| BillingInfoStorageUsage | Double | The total storage usage (in GB) by all organizations owned by the enterprise. | ||
| BillingInfoStorageUsagePercentage | Int | The percentage of the storage quota currently used by the enterprise. | ||
| BillingInfoTotalAvailableLicenses | Int | The number of licenses available across all owned organizations, based on unique billable users. | ||
| BillingInfoTotalLicenses | Int | The total number of licenses allocated to the enterprise. | ||
| CreatedAt | Datetime | The date and time when the enterprise object was created, in ISO 8601 format. | ||
| Description | String | A brief text description of the enterprise, provided in its profile. | ||
| DescriptionHTML | String | The HTML-formatted description of the enterprise, suitable for display purposes. | ||
| OwnerInfoOidcProviderId | String | The unique identifier (node ID) of the OIDCProvider object associated with the enterprise. | ||
| OwnerInfoOidcProviderTenantId | String | The unique identifier of the tenant to which the OIDC provider is attached. | ||
| OwnerInfoSamlIdentityProviderId | String | The unique identifier (node ID) of the SAML identity provider object for the enterprise. | ||
| ResourcePath | String | The relative HTTP path to the enterprise’s profile on GitHub. | ||
| Slug | String | The URL-friendly identifier (slug) for the enterprise, used in APIs and URLs. | ||
| Url | String | The absolute HTTP URL for the enterprise’s profile on GitHub. | ||
| ViewerIsAdmin | Bool | Indicates whether the current viewer has administrative privileges for this enterprise. | ||
| WebsiteUrl | String | The URL of the enterprise's official website or homepage. | ||
| Readme | String | The raw, plain-text content of the enterprise's README file, if available. | ||
| ReadmeHTML | String | The content of the enterprise's README file formatted as HTML for display purposes. | ||
| MembershipType | String | Filters enterprises based on the user's membership type (for example, 'owner', 'member').
使用できる値は次のとおりです。ALL, ADMIN, BILLING_MANAGER, ORG_MEMBERSHIP | ||
| Login | String | The login or username associated with the enterprise or user account. |