ItemReviewers
Maintains a list of reviewers assigned to specific project items, ensuring tracking of review responsibilities.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- ItemId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [ItemReviewers]
SELECT * FROM [ItemReviewers] WHERE [ItemId] = 'Val1'
The 本製品 processes other filters client-side within the 本製品.
Columns
| Name | Type | References | OrderBySupport | Description |
| ItemId [KEY] | String | A unique identifier for the item (for example, a pull request or issue) associated with the reviewer. | ||
| NodeId [KEY] | String | A unique identifier for the object in the GitHub system. | ||
| UserId | String | A unique identifier for the user acting as a reviewer. | ||
| UserDatabaseId | Int | The primary key of the user in the database, used for internal reference. | ||
| UserLogin | String | The username associated with the user's GitHub account, used for authentication and identification. | ||
| UserName | String | The full name associated with the user's public GitHub profile. | ||
| UserEmail | String | The publicly visible email address of the user, if they have chosen to make it available. | ||
| UserTwitterUsername | String | The Twitter username provided on the user's GitHub profile. | ||
| UserPronouns | String | The pronouns listed by the user in their public GitHub profile. | ||
| UserBio | String | The user's public biography, offering a brief description about themselves. | ||
| UserBioHTML | String | The user's public biography formatted in HTML for rendering in web applications. | ||
| UserCompany | String | The organization or company associated with the user's public GitHub profile. | ||
| UserCompanyHTML | String | The organization or company formatted as HTML, suitable for rendering in web applications. | ||
| UserLocation | String | The geographic location provided in the user's public profile, such as city or country. | ||
| UserAnyPinnableItems | Bool | Indicates whether the user has any repositories, gists, or projects that can be pinned to their profile. | ||
| UserPinnedItemsRemaining | Int | The number of additional items the user can pin to their GitHub profile. | ||
| UserItemShowcaseHasPinnedItems | Bool | Indicates whether the user has pinned any repositories or gists to their profile showcase. | ||
| UserIsEmployee | Bool | Indicates whether the user is an employee of GitHub. | ||
| UserIsHireable | Bool | Indicates whether the user has marked themselves as available for hiring opportunities. | ||
| UserIsBountyHunter | Bool | Indicates whether the user participates in the GitHub Security Bug Bounty program. | ||
| UserIsCampusExpert | Bool | Indicates whether the user is a participant in the GitHub Campus Experts Program. | ||
| UserIsFollowingViewer | Bool | Indicates whether the user is following the authenticated viewer. This is the inverse of 'UserViewerIsFollowing.' | ||
| UserIsSiteAdmin | Bool | Indicates whether the user has site-wide administrative privileges on GitHub. | ||
| UserIsDeveloperProgramMember | Bool | Indicates whether the user is a member of the GitHub Developer Program. | ||
| UserIsGitHubStar | Bool | Indicates whether the user is recognized as a member of the GitHub Stars Program. | ||
| UserIsSponsoringViewer | Bool | Indicates whether the user is sponsoring the authenticated viewer through GitHub Sponsors. | ||
| UserIsViewer | Bool | Indicates whether the user is the currently authenticated viewer. | ||
| UserViewerCanFollow | Bool | Indicates whether the viewer can follow this user. | ||
| UserViewerCanSponsor | Bool | Indicates whether the viewer can sponsor this user or organization through GitHub Sponsors. | ||
| UserViewerIsFollowing | Bool | Indicates whether the viewer is currently following this user. | ||
| UserViewerIsSponsoring | Bool | Indicates whether the currently authenticated viewer is sponsoring this user or organization through GitHub Sponsors. | ||
| UserViewerCanCreateProjects | Bool | Indicates whether the authenticated viewer has permission to create new projects for this user or organization. | ||
| UserViewerCanChangePinnedItems | Bool | Indicates whether the viewer can pin repositories or gists to this user's profile. | ||
| UserStatusId | String | A unique identifier for the emoji used in the user's current status. | ||
| UserStatusEmoji | String | An emoji representing the user's current status, providing a visual summary. | ||
| UserStatusMessage | String | A brief text message describing the user's current activity or availability. | ||
| UserStatusIndicatesLimitedAvailability | Bool | Indicates whether the user's status signifies limited availability on GitHub. | ||
| UserStatusEmojiHTML | String | The user's status emoji formatted as HTML, suitable for display in web applications. | ||
| UserStatusCreatedAt | Datetime | The date and time when the user's status was initially set. | ||
| UserStatusExpiresAt | Datetime | The expiration date and time for the user's status, after which it is no longer displayed. | ||
| UserStatusUpdatedAt | Datetime | The date and time when the user's status was last updated. | ||
| UserStatusOrganizationId | String | The unique identifier of the organization associated with the user's status. | ||
| UserStatusOrganizationLogin | String | The login name of the organization associated with the user's status. | ||
| UserInteractionAbilityLimit | String | The type of interaction limit currently applied to this user's repositories or objects, such as restricting comments or contributions. | ||
| UserInteractionAbilityOrigin | String | The origin or reason for the currently active interaction limit, such as an organization policy. | ||
| UserInteractionAbilityExpiresAt | Datetime | The date and time when the current interaction limit expires. | ||
| UserHasSponsorsListing | Bool | Indicates whether the user or organization has a GitHub Sponsors listing to receive sponsorships. | ||
| UserMonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly income from GitHub Sponsors for this user or organization, in cents (USD). | ||
| UserEstimatedNextSponsorsPayoutInCents | Int | The estimated amount for the next GitHub Sponsors payout, in cents (USD). | ||
| UserSponsorsListingId | String | A unique identifier for the GitHub Sponsors listing associated with this user or organization. | ||
| UserSponsorsListingName | String | The full name of the GitHub Sponsors listing associated with this user or organization. | ||
| UserTotalSponsorshipAmountAsSponsorInCents | Int | The total amount in US cents that this user or organization has spent on sponsorships through GitHub. | ||
| UserResourcePath | String | The relative HTTP path for accessing this user's GitHub profile. | ||
| UserProjectsResourcePath | String | The relative HTTP path for viewing this user's GitHub projects. | ||
| UserUrl | String | The full HTTP URL for accessing this user's GitHub profile. | ||
| UserProjectsUrl | String | The full HTTP URL for viewing this user's GitHub projects. | ||
| UserWebsiteUrl | String | A URL pointing to the user's public website or blog, if provided. | ||
| UserAvatarUrl | String | A URL pointing to the user's public avatar image. The 'size' argument specifies the dimensions of the square image. | ||
| UserCopilotEndpointsApi | String | The API endpoint for GitHub Copilot integration specific to this user. | ||
| UserCopilotEndpointsOriginTracker | String | The endpoint for tracking the origin of requests made through GitHub Copilot for this user. | ||
| UserCopilotEndpointsProxy | String | The proxy endpoint for GitHub Copilot requests associated with this user. | ||
| UserCopilotEndpointsTelemetry | String | The telemetry endpoint for gathering data related to GitHub Copilot usage for this user. | ||
| UserCreatedAt | Datetime | The date and time when this user's GitHub account was created. | ||
| UserUpdatedAt | Datetime | The date and time when this user's profile or associated data was last updated. | ||
| UserRepositoryCount | Int | The total number of repositories owned by this user. | ||
| UserFollowerCount | Int | The total number of followers this user has on GitHub. | ||
| BotId | String | The unique identifier for this bot in the GitHub system. | ||
| BotDatabaseId | Int | The primary key of the bot in the database, used for internal reference. | ||
| BotLogin | String | The username or handle associated with this bot on GitHub. | ||
| BotUrl | String | The full HTTP URL for accessing this bot's profile or details. | ||
| BotResourcePath | String | The relative HTTP path for accessing this bot's profile or details. | ||
| BotCreatedAt | Datetime | The date and time when this bot account was created on GitHub. | ||
| BotUpdatedAt | Datetime | The date and time when this bot's profile or associated data was last updated. | ||
| MannequinId | String | The unique identifier for this mannequin user on GitHub. | ||
| MannequinDatabaseId | Int | The primary key of the mannequin user in the database, used for internal reference. | ||
| MannequinLogin | String | The username associated with this mannequin account, typically used for attribution. | ||
| MannequinEmail | String | The email address of the mannequin user from the source instance, if available. | ||
| MannequinUrl | String | The full HTTP URL to access this mannequin's profile or details. | ||
| MannequinResourcePath | String | The relative HTML path for accessing this mannequin's profile or details. | ||
| MannequinCreatedAt | Datetime | The date and time when this mannequin account was created on GitHub. | ||
| MannequinUpdatedAt | Datetime | The date and time when this mannequin's profile or associated data was last updated. | ||
| MannequinClaimantId | String | The unique identifier for the user or entity claiming ownership of this mannequin account. | ||
| MannequinClaimantLogin | String | The username of the user or entity that has claimed the mannequin account. | ||
| TeamId | String | A unique identifier for the team in the GitHub system. | ||
| TeamDatabaseId | Int | The primary key of the team in the database, used for internal reference. | ||
| TeamOrganizationId | String | A unique identifier for the organization to which the team belongs. | ||
| TeamOrganizationDatabaseId | Int | The primary key of the organization in the database, used for internal reference. | ||
| TeamParentTeamId | String | A unique identifier for the parent team of the current team, if applicable. | ||
| TeamParentTeamDatabaseId | Int | The primary key of the parent team in the database, used for internal reference. | ||
| TeamParentTeamName | String | The name of the parent team of the current team, if applicable. | ||
| TeamName | String | The name of the team, used for identification and display purposes. | ||
| TeamDescription | String | A brief description of the team's purpose or role within the organization. | ||
| TeamPrivacy | String | The privacy level of the team, such as 'PRIVATE' or 'SECRET'.
使用できる値は次のとおりです。SECRET, VISIBLE | ||
| TeamSlug | String | A URL-friendly identifier (slug) for the team. | ||
| TeamUrl | String | The full HTTP URL for accessing this team's details on GitHub. | ||
| TeamAvatarUrl | String | A URL pointing to the team's avatar or profile image. | ||
| TeamCombinedSlug | String | A URL-friendly identifier combining the organization and team slugs. | ||
| TeamDiscussionsUrl | String | The full HTTP URL for accessing discussions related to this team. | ||
| TeamMembersUrl | String | The full HTTP URL for accessing the list of this team's members. | ||
| TeamNotificationSetting | String | The notification preferences set for this team.
使用できる値は次のとおりです。NOTIFICATIONS_ENABLED, NOTIFICATIONS_DISABLED | ||
| TeamRepositoriesUrl | String | The full HTTP URL for accessing the repositories associated with this team. | ||
| TeamResourcePath | String | The relative HTTP path for accessing this team's details on GitHub. | ||
| TeamTeamsUrl | String | The full HTTP URL for accessing this team's child teams, if applicable. | ||
| TeamViewerSubscription | String | Indicates the viewer's subscription status for the team, such as 'WATCHING', 'NOT_WATCHING', or 'IGNORING'. | ||
| TeamDiscussionsResourcePath | String | The relative HTTP path for accessing team discussions. | ||
| TeamEditTeamUrl | String | The full HTTP URL for editing this team's details. | ||
| TeamMembersResourcePath | String | The relative HTTP path for accessing the list of this team's members. | ||
| TeamNewTeamUrl | String | The full HTTP URL for creating a new team under this organization. | ||
| TeamRepositoriesResourcePath | String | The relative HTTP path for accessing the repositories associated with this team. | ||
| TeamTeamsResourcePath | String | The relative HTTP path for accessing this team's child teams, if applicable. | ||
| TeamViewerCanAdminister | Bool | Indicates whether the viewer has administrative permissions for this team. | ||
| TeamViewerCanSubscribe | Bool | Indicates whether the viewer can change their subscription status for this team's repositories or discussions. | ||
| TeamEditTeamResourcePath | String | The relative HTTP path for editing this team's details. | ||
| TeamNewTeamResourcePath | String | The relative HTTP path for creating a new team within this organization. | ||
| TeamCreatedAt | Datetime | The date and time when the team was created in the GitHub system. | ||
| TeamUpdatedAt | Datetime | The date and time when the team's details were last updated. | ||
| TeamReviewRequestDelegationAlgorithm | String | The algorithm used by this team for assigning reviews, such as round-robin or load-balanced methods. | ||
| TeamReviewRequestDelegationEnabled | Bool | Indicates whether the review request delegation feature is enabled for this team. | ||
| TeamReviewRequestDelegationMemberCount | Int | The number of team members required to be assigned as reviewers when delegation is enabled. | ||
| TeamReviewRequestDelegationNotifyTeam | Bool | Indicates whether the entire team should be notified in addition to the delegated members when reviews are assigned. |