GitHub Tables

Tables

GitHubArtifacts

Build artifacts produced by GitHub Actions workflow runs, including their size, download URL, and expiration.

Name	Type	Description
ConfigID	integer	Custom configuration ID used to associate the artifact with its integration setup
ID	bigint	Unique identifier for the artifact within GitHub
NodeID	string	Global GraphQL node identifier for the artifact
SizeInBytes	bigint	The size of the artifact file in bytes
Url	string	API URL used to retrieve metadata about the artifact
ArchiveDownloadUrl	string	Direct URL to download the artifact archive (usually a `.zip` file)
Expired	boolean	Boolean flag indicating whether the artifact has expired
CreatedAt	datetime	Timestamp when the artifact was first created
ExpiresAt	datetime	Timestamp when the artifact is scheduled to expire and be deleted
UpdatedAt	datetime	Timestamp when the artifact was last modified
Digest	string	A hash or checksum used to validate the artifact’s contents
WorkflowRunID	bigint	ID of the workflow run that generated the artifact

GitHubAssets

Binary assets attached to GitHub releases, including their file type, size, and download counts.

Name	Type	Description
ConfigID	integer	Custom configuration ID linking the asset to its integration setup
ID	integer	Unique identifier for the asset within GitHub
Url	string	API URL to retrieve metadata about the asset
BrowserDownloadUrl	string	Direct URL for users to download the asset via browser
NodeID	string	Global GraphQL node identifier for the asset
Label	string	Optional user-defined label for the asset
State	string	Current state of the asset (usually `uploaded`)
ContentType	string	MIME type of the asset (e.g., `application/zip`, `text/plain`)
Size	integer	File size of the asset in bytes
Digest	string	Hash or checksum used to verify the asset’s content
DownloadCount	integer	Number of times the asset has been downloaded
CreatedAt	datetime	Timestamp when the asset was created

GitHubAuditLogs

Organization audit log events recording actions taken by actors against organizations, repositories, teams, and users.

Name	Type	Description
Action	string	The specific event that occurred, typically formatted as category.operation (e.g., `repo.create`).
Actor	string	The username of the individual or system that initiated the action.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry
CreatedAt	datetime	Timestamp indicating when the action occurred (UTC epoch milliseconds).
DocumentID	string	A unique identifier for the audit log entry.
GitHubOrganizationConfigID	integer	The GitHub org configuration ID.
GitHubOrganizationID	integer	The GitHub org ID.
GitHubRepositoryConfigID	integer	The GitHub repository configuration ID.
GitHubRepositoryID	integer	The GitHub repository ID.
GitHubTeamConfigID	integer	The GitHub team configuration ID.
GitHubTeamID	integer	The GitHub team ID.

GitHubCodeScanningAlerts

Code scanning alerts from static analysis tools (e.g. CodeQL) identifying potential code vulnerabilities, including the triggering rule, severity, and location in code.

Name	Type	Description
ConfigID	integer	Compyl GitHub integration configuration this row belongs to.
AlertNumber	integer	GitHub code scanning alert number, unique per repository.
GitHubRepositoryID	integer	GitHub repository ID the alert was reported against.
GitHubRepositoryConfigID	integer	Companion ConfigID for the repository FK; null when the repo is not in `GitHubRepositories`.
RuleId	string	Code scanning rule identifier that fired.
RuleSeverity	string	Rule severity from the scanning tool (`error`, `warning`, `note`).
SecuritySeverityLevel	string	GitHub security severity (`critical`, `high`, `medium`, `low`).
MostRecentInstancePath	string	File path of the most recent finding instance.
StartLine	integer	Starting line of the most recent finding instance.
EndLine	integer	Ending line of the most recent finding instance.
State	string	Alert state (`open`, `dismissed`, `fixed`).
ToolName	string	Code scanning tool that produced the alert (e.g. `CodeQL`).

GitHubCollaborators

Users granted direct collaborator access to a repository, including their assigned role.

Name	Type	Description
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
CollaboratorID	integer	The ID of the collaborator.
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
GitHubRepositoryID	integer	The GitHub repository ID.
GitHubUserConfigID	integer	The GitHub user configuration ID.
GitHubUserID	integer	The GitHub user ID.
Name	string	The full name of the user (if available in their GitHub profile).
RoleName	string	Role assigned to the collaborator (e.g., `admin`, `maintain`, `write`, `triage`, or `read`).
SiteAdmin	boolean	Boolean value indicating if the user is a GitHub site administrator.
Type	string	Type of the user account, typically `User` or `Organization`.
UserViewType	string	Not standard. Possibly refers to how the user is viewed in your system (e.g., `internal`, `external`, `restricted`).

GitHubContributors

Users who have contributed commits to a repository, including their contribution count.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
ContributorID	integer	The ID of the contributor.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
Contributions	integer	The number of commits made by the contributor to the repository. This is the primary metric provided by GitHub’s contributors API.
SiteAdmin	boolean	A boolean indicating whether the user is a GitHub site administrator. Typically `false` for standard users.
Type	string	The type of GitHub account, usually `User` or `Organization`.
UserViewType	string	Not a standard field. Possibly a custom field indicating how the user is categorized/viewed in your system (e.g., `internal`, `external`).
Name	string	The full display name of the contributor, if available from their GitHub profile. This is not guaranteed to be present.
UserID	integer	The unique numeric ID assigned to the user by GitHub (not to be confused with their username/login).
GitHubRepositoryID	integer	The GitHub repository ID.
GitHubUserConfigID	integer	The GitHub user configuration ID.
GitHubUserID	integer	The GitHub user ID.

GitHubDependabotAlerts

Dependabot alerts identifying vulnerable dependencies detected in repositories, including the affected package, advisory severity, and alert lifecycle timestamps.

Name	Type	Description
ConfigID	integer	Compyl GitHub integration configuration this row belongs to.
AlertNumber	integer	GitHub Dependabot alert number, unique per repository.
GitHubRepositoryID	integer	GitHub repository ID the alert was reported against.
GitHubRepositoryConfigID	integer	Companion ConfigID for the repository FK; null when the repo is not in `GitHubRepositories`.
State	string	Alert state (`open`, `dismissed`, `fixed`).
PackageName	string	Vulnerable package name.
PackageEcosystem	string	Package ecosystem (`npm`, `pip`, `maven`, `nuget`, etc.).
AdvisorySeverity	string	GitHub Security Advisory severity.
VulnerabilitySeverity	string	Dependabot-assessed vulnerability severity.
RepositoryName	string	Repository short name, denormalized from the alert payload.
RepositoryFullName	string	Repository owner/name, denormalized from the alert payload.
DismissedReason	string	Reason the alert was dismissed, when dismissed.

GitHubIntegrations

Integration configuration records used to collect GitHub data into this dataset.

Name	Type	Description
ID	integer	A unique identifier for the integration instance.
IntegrationsID	integer	A secondary or external system identifier linking this integration to another system, or a specific installation ID (e.g., `installation_id`).
Name	string	The name of the GitHub App or integration.
OrgName	string	The GitHub organization or user account where the integration is installed or created.
IsEnabled	boolean	Boolean flag indicating whether the integration is currently active or installed.
UserAgent	string	The user agent string used by the integration when making API requests.
CreatedBy	varchar	The GitHub username or ID of the user who created the integration or initiated its installation.
CreatedDate	datetime	Timestamp of when the integration was created or installed.
ModifiedBy	varchar	The user who last modified the integration settings, if available.
ModifiedDate	datetime	Timestamp of the last update or modification to the integration (e.g., changing webhook URL or scopes).

GitHubOrganizationMembers

Users who are members of a GitHub organization.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
UserID	integer	The unique numeric ID assigned to the GitHub user. This differs from the username (login).
GitHubOrganizationID	integer	The unique numeric ID of the GitHub organization the member belongs to.
Type	string	The type of GitHub account, usually `User` for individuals or "`Bot/Organization` in rare cases.
SiteAdmin	boolean	A boolean indicating whether the user is a GitHub site administrator (typically `false` for most users).
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
GitHubUserID	integer	The unique numeric ID assigned to the GitHub user. This differs from the username (`login`).

GitHubOrganizationRoles

Custom organization roles defined in a GitHub organization, including the base role they extend and their source.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
RoleID	integer	A unique identifier for the role within the organization.
GitHubOrganizationID	integer	The unique numeric ID of the GitHub organization to which the role belongs.
Name	string	The name of the role, such as `Owner`, `Billing Manager`, or custom enterprise role names.
Description	string	A textual explanation of what the role is responsible for or what permissions it includes.
CreatedAt	datetime	The timestamp when the role was created (ISO 8601 or Unix epoch format).
UpdatedAt	datetime	The timestamp when the role was last modified.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
BaseRole	string	The underlying GitHub role on which this custom role is based, such as member, admin, or owner.
Source	string	Indicates where the role originated from, (e.g., `GitHub`, `SSO`, or an internal identity provider).

GitHubOrganizations

GitHub organization accounts, including their profile details, repository/gist counts, and member permission settings.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
OrganizationID	integer	The unique identifier (`ID`) of the GitHub organization.
Url	string	The URL of the organization's GitHub page.
Description	string	A brief description of the organization.
TwoFactorRequirementEnabled	boolean	Indicates whether two-factor authentication is required for all members of the organization.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
AdvancedSecurityEnabledForNewRepositories	boolean	Indicates whether GitHub Advanced Security is enabled by default for new repositories in the organization.
BillingEmail	string	The billing email address for the organization.
Blog	string	The blog URL associated with the organization.
Collaborators	integer	The number of outside collaborators on the organization's repositories.
Company	string	The company name associated with the organization.
CreatedAt	datetime	The date and time when the organization was created.

GitHubOutsideCollaborators

Users granted access to an organization's repositories without being members of the organization.

Name	Type	Description
ConfigID	integer	Compyl GitHub integration configuration this row belongs to.
UserID	integer	GitHub user ID of the outside collaborator.
GitHubOrganizationID	integer	GitHub organization ID the collaborator has access to.
GitHubUserConfigID	integer	Companion ConfigID for the user FK; null when the user is not in GitHubUsers.
Login	string	GitHub username.
Name	string	Display name, when GitHub returns one.
Type	string	Account type (`User`, `Bot`).
SiteAdmin	boolean	Whether the account is a GitHub site admin.
HtmlUrl	string	GitHub HTML profile URL.
AvatarUrl	string	Avatar image URL.
BatchDate	datetime	ETL batch timestamp for this load.

GitHubPermissions

Individual permission entries available for assignment within GitHub custom roles.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
PermissionID	integer	The ID of the permission.
Name	string	The name of the permission level, such as `admin`, `maintain`, `write`, `triage`, or `read`.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded

GitHubProjectPermissions

Access level (admin, read, write) granted to a team on a GitHub project.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
ID	integer	A unique identifier for the project or the permission set associated with a user or team.
Admin	boolean	Boolean value (`true`, `false`) indicating whether the user or team has administrative permissions on the project. Admins can manage settings, users, and content.
Read	boolean	Boolean value indicating read-only access to the project. Allows viewing content but no changes.
Write	boolean	Boolean value indicating write access to the project. Allows editing or managing project content.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
GitHubTeamID	integer	The GitHub team ID.
GitHubProjectID	integer	The GitHub project ID.

GitHubReleases

Repository releases, including their tag, assets, publication state, and author.

Name	Type	Description
ConfigID	integer	Custom configuration ID linking the release to its integration setup
ID	integer	Unique identifier for the release within GitHub
Url	string	API URL to retrieve metadata about the release
HtmlUrl	string	Web URL for viewing the release in the GitHub UI
AssetsUrl	string	URL endpoint to list all assets associated with the release
UploadUrl	string	URL used to upload assets to the release
TarballUrl	string	URL to download the release source as a `.tar.gz` archive
ZipballUrl	string	URL to download the release source as a `.zip` archive
NodeID	string	Global GraphQL node identifier for the release
TagName	string	Git tag name associated with the release
TargetCommitish	string	Commit SHA or branch/tag name the release is based on
Body	string	Full release notes or description (in markdown)

GitHubRepositories

GitHub repositories, including their visibility, feature flags, merge settings, and ownership.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
ID	integer	The unique identifier of the repository.
NodeID	string	The GraphQL global identifier for the repository.
FullName	string	The full name of the repository, formatted as owner/name.
OwnerID	integer	The unique identifier of the user or organization that owns the repository. (Note: This field is not directly provided in the standard API response; typically, the owner object contains login and id fields.)
Private	boolean	A boolean indicating whether the repository is private.
HtmlUrl	string	The URL to view the repository on GitHub's website.
Description	string	A brief description of the repository.
Fork	boolean	A boolean indicating whether the repository is a fork of another repository.
Url	string	The API URL for the repository.
CreatedAt	datetime	The timestamp when the repository was created.
UpdatedAt	datetime	The timestamp when the repository was last updated.

GitHubRepositoryPermissions

Access level (admin, maintain, push, triage, pull) granted to a collaborator or team on a repository.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
ID	integer	A unique identifier for the permission record or user/team associated with the repository. (May be internal or derived from the user/team ID.)
Admin	boolean	Boolean. Grants full control over the repository, including managing settings, teams, collaborators, and sensitive operations like deleting the repository.
Maintain	boolean	Boolean. Grants access to perform project management tasks (e.g., managing issues and pull requests) without full admin rights. Ideal for non-code contributors.
Push	boolean	Boolean. Grants write access to the repository. Allows pushing commits, creating branches, and managing pull requests.
Triage	boolean	Boolean. Grants limited access to manage issues and pull requests (e.g., applying labels, assigning issues) without write or push permissions.
Pull	boolean	Boolean. Grants read-only access to the repository. Allows cloning, downloading, and viewing issues or pull requests.
GitHubCollaboratorID	integer	The ID of the GitHub collaborator.
GitHubTeamID	integer	The ID of the GitHub team.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
GitHubRepositoryID	integer	The ID of the GitHub repository.
GitHubCollaboratorConfigID	integer	The ID of the GitHub collaborator configuration.
GitHubCollaboratorRepositoryID	integer	The ID of the GitHub collaborator repository.
GitHubTeamConfigID	integer	The ID of the GitHub team configuration.
GitHubTeamRepositoryID	integer	The ID of the GitHub team repository.

GitHubRulesets

Repository and organization rulesets defining branch/tag protection rules, their enforcement status, bypass actors, and the conditions and targets they apply to.

Name	Type	Description
ConfigID	integer	Compyl GitHub integration configuration this row belongs to.
RulesetID	biginteger	GitHub ruleset ID.
Target	string	What the ruleset targets (`branch`, `tag`, `push`, `repository`).
SourceType	string	Whether the ruleset is defined on an Organization or Repository.
Source	string	Owner that defined the ruleset (`org login or owner/repo`).
Enforcement	string	Enforcement level (`disabled`, `evaluate`, `active`).
CurrentUserCanBypass	string	Whether the authenticated app/user can bypass (`always`, `pull_requests`, `never`).
NodeId	string	GitHub GraphQL node ID.
RulesJson	string	Serialized rules from the ruleset `GET-by-id` payload.
BypassActorsJson	string	Serialized bypass actors from the ruleset `GET-by-id` payload.
ConditionsJson	string	Serialized targeting conditions (`ref names`, `repository names`, etc.).
GitHubOrganizationID	integer	Owning GitHub organization ID for org-level rulesets.

GitHubSecretScanningAlerts

Secret scanning alerts flagging exposed secrets (e.g. API keys, tokens) detected in repository content, including secret type, state, and resolution.

Name	Type	Description
ConfigID	integer	Compyl GitHub integration configuration this row belongs to.
AlertNumber	integer	GitHub secret scanning alert number, unique per repository.
GitHubRepositoryID	integer	GitHub repository ID the alert was reported against.
GitHubRepositoryConfigID	integer	Companion ConfigID for the repository FK; null when the repo is not in `GitHubRepositories`.
SecretType	string	Detected secret type token (e.g. `github_personal_access_token`). Secret values are not stored.
SecretTypeDisplayName	string	Human-readable secret type name.
State	string	Alert state (`open`, `resolved`).
Resolution	string	Resolution applied when the alert was closed (`false_positive`, `wont_fix, revoked`, `used_in_tests`).
Validity	string	Whether GitHub considers the secret still valid (`active`, `inactive`, `unknown`).
HtmlUrl	string	GitHub HTML URL for the alert.
RepositoryName	string	Repository short name, denormalized from the alert payload.
RepositoryFullName	string	Repository owner/name, denormalized from the alert payload.

GitHubTeamMembers

Users who are members of a GitHub team.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
TeamMemberID	integer	A unique identifier for the team membership record. (Likely internal/custom, not a standard GitHub field.)
TeamID	integer	The unique identifier for the GitHub team.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
SiteAdmin	boolean	Boolean indicating whether the user is a GitHub site administrator. Applies only to GitHub.com, not GitHub Enterprise.
Type	string	The type of the user account, typically `User` or `Bot`.
UserViewType	string	A custom/internal classification of how the user is displayed or grouped (e.g., `External`, `Internal`, `Contractor`).

GitHubTeamProjects

Projects a GitHub team has been granted access to, including its permission level.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
ProjectID	integer	A unique identifier for the project associated with the team.
GitHubTeamID	integer	The unique identifier of the GitHub team that has access to the project.
Name	string	The name of the project.
OrganizationPermission	string	The level of access granted to the team for this project within the organization (e.g., `read`, `write`, `admin`).
CreatedAt	datetime	The timestamp when the project was created.
UpdatedAt	datetime	The timestamp when the project was last updated.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded

GitHubTeamRepositories

Repositories a GitHub team has been granted access to.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded.
TeamID	integer	The unique identifier of the GitHub team that has access to the repository.
RepositoryID	integer	The unique identifier of the GitHub repository the team has access to.
RepositoryConfigID	integer	The unique identifier of the GitHub repository configuration the team has access to.

GitHubTeams

GitHub teams defined within an organization, including their privacy level and default permission.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
TeamID	integer	The unique identifier for the GitHub team.
Name	string	The name of the team as it appears in the GitHub UI.
Url	string	The API URL or web URL to access the team.
Slug	string	The URL-friendly version of the team name (e.g., lowercase with hyphens instead of spaces). Used in API endpoints.
Description	string	A short description of the team's purpose or responsibilities.
Privacy	string	The visibility of the team within the organization. Can be secret (only visible to members) or closed (visible to all org members).
Permission	string	The default permission level granted to team members for repositories (e.g., `pull`, `push`, `admin`, `maintain`, or `triage`).
GitHubOrganizationID	integer	The unique identifier of the GitHub organization to which the team belongs.
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded

GitHubUsers

GitHub user accounts referenced by the integration, including their profile and account metadata.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.
UserID	integer	A unique identifier for the GitHub user.
Login	string	The GitHub username/login handle.
AvatarUrl	string	The URL of the user’s avatar image.
Url	string	The API URL to fetch the user’s profile data.
Type	string	The type of GitHub account, typically User or Organization.
SiteAdmin	boolean	Boolean indicating whether the user is a GitHub site administrator (applies only on GitHub.com).
BatchDate	datetime	The date and time when the activity logs were batch-processed or recorded
Blog	string	The URL of the user's blog or website as specified in their GitHub profile.
CreatedAt	datetime	Timestamp of when the user account was created.
Followers	integer	Number of users following this user.
Following	integer	Number of users this user is following.
Name	string	The display name of the user as set in their GitHub profile.
PublicGists	integer	The number of public gists (code snippets) the user has created.
PublicRepos	integer	The number of public repositories owned by the user.
UpdatedAt	datetime	Timestamp of the last update to the user’s profile data.

Bridge Tables

GitHubOrganizationRoles_GitHubPermissions

Name	Type	Description
PermissionID	integer	A unique identifier for the permission record or user/team associated with the repository.
RoleID	integer	A unique identifier for the role.
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.

GitHubOrganizationRoles_GitHubTeams

Name	Type	Description
TeamID	integer	A unique identifier for team.
RoleID	integer	A unique identifier for the role relating to the team.
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.

GitHubOrganizationRoles_GitHubUsers

Name	Type	Description
UserID	integer	A unique identifier for the user.
RoleID	integer	A unique identifier for the role.
ConfigID	integer	A unique identifier for the configuration associated with the activity log entry.