Watchers
Tracks users watching a repository, providing visibility into who is monitoring updates, changes, and activity.
View-Specific Information
Select
The 本製品 processes all filters client-side within the 本製品. The following query is the only one processed server-side:
SELECT * FROM [Watchers]
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier of the user. | ||
| DatabaseId | Int | The primary key for the user in the database, used for internal reference. | ||
| Login | String | The username that the user uses to log in to GitHub. | ||
| Name | String | The publicly visible name displayed on the user's profile. | ||
| String | The publicly visible email address listed on the user's profile. | |||
| TwitterUsername | String | The username of the user's Twitter account, if the account is linked. | ||
| Pronouns | String | The pronouns the user has listed on their profile. | ||
| Bio | String | The text description provided by the user in their public-profile biography. | ||
| BioHTML | String | The user's public-profile biography formatted as HTML. | ||
| Company | String | The name of the company the user has associated with their profile. | ||
| CompanyHTML | String | The company name listed on the user's profile, formatted as HTML. | ||
| Location | String | The geographic location listed on the user's public profile. | ||
| AnyPinnableItems | Bool | Indicates whether the user has any items, such as repositories or gists, that can be pinned to their profile. | ||
| PinnedItemsRemaining | Int | The number of additional items the user can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether the user has pinned any repositories or gists to their profile. | ||
| IsEmployee | Bool | Indicates whether the user is an employee of GitHub. | ||
| IsHireable | Bool | Indicates whether the user has marked themselves as available for hire. | ||
| IsBountyHunter | Bool | Indicates whether the user is a participant in the GitHub Security Bug Bounty program. | ||
| IsCampusExpert | Bool | Indicates whether the user is a member of the GitHub Campus Experts program. | ||
| IsFollowingViewer | Bool | Indicates whether the user is following the viewer. This is the inverse of ViewerIsFollowing. | ||
| IsSiteAdmin | Bool | Indicates whether the user is a GitHub site administrator. | ||
| IsDeveloperProgramMember | Bool | Indicates whether the user is a member of the GitHub Developer Program. | ||
| IsGitHubStar | Bool | Indicates whether the user is a member of the GitHub Stars Program. | ||
| IsSponsoringViewer | Bool | Indicates whether the user or organization is sponsoring the viewer. | ||
| IsViewer | Bool | Indicates whether this user is the same as the viewing user. | ||
| ViewerCanFollow | Bool | Indicates whether the viewer has the ability to follow this user. | ||
| ViewerCanSponsor | Bool | Indicates whether the viewer has the ability to sponsor this user or organization. | ||
| ViewerIsFollowing | Bool | Indicates whether the viewer is currently following this user. | ||
| ViewerIsSponsoring | Bool | Indicates whether the viewer is currently sponsoring this user or organization. | ||
| ViewerCanCreateProjects | Bool | Can the current viewer create new projects on this owner? | ||
| ViewerCanChangePinnedItems | Bool | Can the viewer pin repositories and gists to the profile? | ||
| StatusId | String | The emoji's ID. | ||
| StatusEmoji | String | An emoji summarizing the user's status. | ||
| StatusMessage | String | A brief message describing what the user is doing. | ||
| StatusIndicatesLimitedAvailability | Bool | Specifies whether this status indicates that the user is not fully available on GitHub. | ||
| StatusEmojiHTML | String | The status emoji as HTML. | ||
| StatusCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| StatusExpiresAt | Datetime | If set, the status is not shown after this date. | ||
| StatusUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| StatusOrganizationId | String | The organization's ID. | ||
| StatusOrganizationLogin | String | The organization's login name. | ||
| InteractionAbilityLimit | String | The current limit that is enabled on this object. | ||
| InteractionAbilityOrigin | String | The origin of the currently active interaction limit. | ||
| InteractionAbilityExpiresAt | Datetime | The time the currently active limit expires. | ||
| HasSponsorsListing | Bool | True if this user/organization has a GitHub Sponsors listing. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly GitHub Sponsors income for this user/organization in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated next GitHub Sponsors payout for this user/organization in cents (USD). | ||
| SponsorsListingId | String | The listing's ID. | ||
| SponsorsListingName | String | The listing's full name. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization. | ||
| ResourcePath | String | The HTTP path for this user. | ||
| ProjectsResourcePath | String | The HTTP path listing user's projects. | ||
| Url | String | The HTTP URL for this user. | ||
| ProjectsUrl | String | The HTTP URL listing user's projects. | ||
| WebsiteUrl | String | A URL pointing to the user's public website/blog. | ||
| AvatarUrl | String | A URL pointing to the user's public avatar. | ||
| CopilotEndpointsApi | String | Copilot API endpoint. | ||
| CopilotEndpointsOriginTracker | String | Copilot origin tracker endpoint. | ||
| CopilotEndpointsProxy | String | Copilot proxy endpoint. | ||
| CopilotEndpointsTelemetry | String | Copilot telemetry endpoint. | ||
| CreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| RepositoryCount | Int | The number of repositories that a user owns. | ||
| FollowerCount | Int | The number of followers that a user has. |