commit_sha 🔑 ➤ COMMIT
issue_id 🔑 ➤ ISSUE
merged_at 🔑
actor_id ➤ USER
ISSUE_MERGED ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
bio
blog
company
created_at
hireable
login
name
type
update_at
site_admin
location
USER ⇱
email 🔑
user_id ➤ USER
name
USER_EMAIL⇱
commit_sha 🔑 ➤ COMMIT
filename 🔑
additions
changes
deletions
status
COMMIT_FILE ⇱
commit_sha 🔑 ➤ COMMIT
parent_sha 🔑 ➤ COMMIT
COMMIT_PARENT ⇱
id 🔑
creator_id ➤ USER
repository_id ➤ REPOSITORY
closed_at
created_at
description
due_on
number
state
title
updated_at
is_deleted
MILESTONE ⇱
sha 🔑
repository_id ➤ REPOSITORY
author_email ➤ USER_EMAIL
committer_email ➤ USER_EMAIL
author_name
author_date
committer_name
committer_date
message
COMMIT ⇱
id 🔑
base_sha ➤ COMMIT
base_repo_id ➤ REPOSITORY
base_user_id ➤ USER
head_sha ➤ COMMIT
head_repo_id ➤ REPOSITORY
head_user_id ➤ USER
issue_id ➤ ISSUE
merge_commit_sha ➤ COMMIT
active_lock_reason
base_label
base_ref
closed_at
created_at
draft
head_label
head_ref
updated_at
PULL_REQUEST ⇱
id 🔑
milestone_id ➤ MILESTONE
repository_id ➤ REPOSITORY
user_id ➤ USER
body
closed_at
created_at
locked
number
state
title
updated_at
ISSUE ⇱
id 🔑
repository_id ➤ REPOSITORY
creator_id ➤ USER
body
number
state
name
created_at
updated_at
is_deleted
PROJECT ⇱
id 🔑
project_id ➤ PROJECT
name
created_at
updated_at
is_deleted
COLUMN ⇱
id 🔑
creator_id ➤ USER
column_id ➤ COLUMN
issue_id ➤ ISSUE
note
archived
created_at
updated_at
is_deleted
CARD ⇱
issue_id 🔑 ➤ ISSUE
label 🔑
label_id 🔑 ➤ LABEL
ISSUE_LABEL⇱
issue_id 🔑 ➤ ISSUE
referenced_at 🔑
actor_id ➤ USER
commit_sha ➤ COMMIT
ISSUE_REFERENCED ⇱
issue_id 🔑 ➤ ISSUE
actor_id 🔑 ➤ USER
updated_at 🔑 �closed 🔑
commit_sha ➤ COMMIT
ISSUE_CLOSED_HISTORY⇱
id 🔑
issue_id ➤ ISSUE
user_id ➤ USER
body
created_at
updated_at
ISSUE_COMMENT ⇱
issue_id 🔑 ➤ ISSUE
actor_id ➤ USER
label 🔑
label_id 🔑 ➤ LABEL
updated_at 🔑
labeled
ISSUE_LABEL_HISTORY ⇱
issue_id 🔑 ➤ ISSUE
user_id 🔑 ➤ USER
updated_at 🔑
assigner_id ➤ USER
assigned
ISSUE_ASSIGNEE_HISTORY ⇱
issue_id 🔑 ➤ ISSUE
user_id 🔑 ➤ USER
updated_at 🔑
ISSUE_MENTION ⇱
issue_id 🔑 ➤ ISSUE
updated_at 🔑
actor_id ➤ USER
from_name
to_name
ISSUE_RENAMED ⇱
issue_id 🔑 ➤ ISSUE
updated_at 🔑
actor_id ➤ USER
locked
ISSUE_LOCKED_HISTORY ⇱
issue_id 🔑 ➤ ISSUE
project_id 🔑➤ PROJECT
updated_at 🔑
actor_id ➤ USER
card_id ➤ CARD
removed
column_name
previous_column_name
ISSUE_PROJECT_HISTORY ⇱
issue_id 🔑 ➤ ISSUE
user_id 🔑 ➤ USER
ISSUE_ASSIGNEE ⇱
issue_id 🔑 ➤ ISSUE
actor_id ➤ USER
milestone_id ➤ MILESTONE
updated_at 🔑
milestoned
ISSUE_MILESTONE_HISTORY⇱
id 🔑
org_id ➤ USER
parent_id ➤ TEAM
name
slug
description
privacy
TEAM ⇱
repository_id 🔑 ➤ REPOSITORY
team_id 🔑 ➤ TEAM
permission
REPO_TEAM ⇱
team_id 🔑 ➤ TEAM�user_id 🔑 ➤ USER
TEAM_MEMBERSHIP ⇱
id 🔑
color
description
is_default
name
url
LABEL ⇱
id 🔑
commit_sha ➤ COMMIT
creator_id ➤ USER
created_at
description
environment
original_environment
payload
production_environment
ref
task
transient_environment
updated_at
DEPLOYMENT ⇱
id 🔑
creator_id ➤ USER
deployment_id ➤ DEPLOYMENT
created_at
description
environment
state
updated_at
DEPLOYMENT_STATUS ⇱
created_at 🔑
pull_request_id 🔑 ➤ PULL_REQUEST�requested_id 🔑 ➤ USER, TEAM�actor_id ➤ USER
requested_reviewer_type�removed
REQUESTED_REVIEWER_HISTORY ⇱
review_id 🔑 ➤ PULL_REQUEST_REVIEW
actor_id ➤ USER
dismissal_commit_sha ➤ COMMIT
created_at�dismissal_message
state
PULL_REQUEST_REVIEW_DISMISSED⇱
commit_sha 🔑 ➤ COMMIT
pull_request_id 🔑 ➤ PULL_REQUEST
COMMIT_PULL_REQUEST ⇱
id 🔑
pull_request_id ➤ PULL_REQUEST
user_id ➤ USER
commit_sha ➤ COMMIT
body
state
submitted_at
PULL_REQUEST_REVIEW ⇱
requested_id is a foreign key reference to USER and TEAM. Which table it refers to is captured in requested_reviewer_type
id 🔑�pull_request_id 🔑 ➤ PULL_REQUEST�parent_comment_id ➤ PULL_REQUEST_REVIEW_COMMENT
user_id ➤ USER
pull_request_review_id ➤ PULL_REQUEST_REVIEW
body�created_at
reaction_minus
reaction_plus�updated_at
PULL_REQUEST_REVIEW_COMMENT ⇱
created_at 🔑
pull_request_id 🔑 ➤ PULL_REQUEST
actor_id ➤ USER�ready_for_review
PULL_REQUEST_READY_FOR_REVIEW_HISTORY ⇱
branch_name 🔑
commit_sha 🔑 ➤ COMMIT
BRANCH_COMMIT_RELATION ⇱
id 🔑
archived
owner_id ➤ USER
created_at
default_branch
description
fork
forks_count
full_name
homepage
language
name
private
watchers_count
REPOSITORY ⇱
id 🔑
release_id ➤ RELEASE�uploader ➤ USER
content_type
created_at
download_count
label
name
size
state
updated_at
ASSET ⇱
id 🔑
author ➤ USER
repository_id ➤ REPOSITORY
body
created_at
draft
name
prerelease
published_at
tag_name
target_commitish
updated_at
RELEASE ⇱
login🔑
repository_id 🔑➤ REPOSITORY
starred_at
STARGAZERS
id 🔑
repository_id ➤ REPOSITORY
created_at
name
path
state
updated_at
WORKFLOW ⇱
pull_request_id 🔑 ➤ PULL_REQUEST
workflow_run_id 🔑 ➤ WORKFLOW_RUN
WORKFLOW_RUN_PULL_REQUEST ⇱
id 🔑
actor ➤ USER
head_sha ➤ COMMIT
repository_id ➤ REPOSITORY
triggering_actor ➤ USER
workflow_id ➤ WORKFLOW
conclusion
created_at
event
head_branch
name
run_attempt
run_number
run_started_at
status
updated_at
WORKFLOW_RUN ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
number 🔑
repository_id 🔑 ➤ REPOSITORY
dismissed_by ➤ USER
security_advisory_ghsa_id ➤ SECURITY_ADVISORY
vulnerability_Id ➤ SECURITY_VULNURABILITY
created_at
dependency_manifest_path
dependency_package_ecosystem
dependency_package_name
dependency_scope
dismissed_at
dismissed_comment
dismissed_reason
fixed_at
state
updated_at
SECURITY_ALERT ⇱
cwe_id 🔑
name
SECURITY_CWE ⇱
ghsa_id 🔑
cve_id
cvss_score
cvss_vector_string
description
published_at
severity
updated_at
withdrawn_at
SECURITY_ADVISORY ⇱
url 🔑
security_advisory_ghsa_id 🔑 ➤ SECURITY_ADVISORY
SECURITY_REFERENCE ⇱
id 🔑
package_ecosystem
package_name
patched_version_identifier
severity
vulnerable_version_range
SECURITY_VULNURABILITY ⇱
vulnerability_Id 🔑 ➤ SECURITY_VULNURABILITY
security_advisory_Id 🔑 ➤ SECURITY_ADVISORY
SECURITY_ADVISORY_VULNURABILITY ⇱
cwe_Id 🔑 ➤ SECURITY_CWE
security_advisory_Id 🔑 ➤ SECURITY_ADVISORY
SECURITY_ADVISORY_CWE ⇱