GitHub

Explore the interactive ERD

Table & Field Reference

issue

Column	Type	Keys
`id`	Long	PK
`milestone_id`	Long	FK
`repository_id`	Long	FK
`user_id`	Long	FK
`body`	String
`closed_at`	Instant
`created_at`	Instant
`locked`	Boolean
`number`	Long
`pull_request`	Boolean
`state`	String
`state_reason`	String
`title`	String
`updated_at`	Instant

label

Column	Type	Keys
`id`	Long	PK
`color`	String
`description`	String
`is_default`	Boolean
`name`	String
`url`	String

issue_label_history

Column	Type	Keys
`updated_at`	Instant	PK
`issue_id`	Long	PKFK
`label_id`	Long	PKFK
`actor_id`	Long	FK
`labeled`	Boolean

deployment_status

Column	Type	Keys
`id`	Long	PK
`creator_id`	Long	FK
`deployment_id`	Long	FK
`created_at`	Instant
`description`	String
`environment`	String
`state`	String
`updated_at`	Instant

workflow_run_attempt

Column	Type	Keys
`run_attempt`	Long	PK
`id`	Long	PKFK
`actor_id`	Long	FK
`head_sha`	String	FK
`repository_id`	Long	FK
`triggering_actor_id`	Long	FK
`workflow_id`	Long	FK
`conclusion`	String
`created_at`	Instant
`event`	String
`head_branch`	String
`name`	String
`run_number`	Long
`run_started_at`	Instant
`status`	String
`updated_at`	Instant

pull_request

Column	Type	Keys
`id`	Long	PK
`base_repo_id`	Long	FK
`base_user_id`	Long	FK
`head_repo_id`	Long	FK
`head_user_id`	Long	FK
`issue_id`	Long	FK
`active_lock_reason`	String
`base_label`	String
`base_ref`	String
`base_sha`	String
`closed_at`	Instant
`created_at`	Instant
`draft`	Boolean
`head_label`	String
`head_ref`	String
`head_sha`	String
`merge_commit_sha`	String
`updated_at`	Instant

team_membership

Column	Type	Keys
`team_id`	Long	PKFK
`user_id`	Long	PKFK
`role`	String

workflow_run_pull_request

Column	Type	Keys
`pull_request_id`	Long	PKFK
`workflow_run_id`	Long	PKFK

workflow_run

Column	Type	Keys
`id`	Long	PK
`actor_id`	Long	FK
`head_sha`	String	FK
`repository_id`	Long	FK
`triggering_actor_id`	Long	FK
`workflow_id`	Long	FK
`conclusion`	String
`created_at`	Instant
`event`	String
`head_branch`	String
`name`	String
`run_attempt`	Long
`run_number`	Long
`run_started_at`	Instant
`status`	String
`updated_at`	Instant

issue_merged

Column	Type	Keys
`merged_at`	Instant	PK
`commit_sha`	String	PKFK
`issue_id`	Long	PKFK
`actor_id`	Long	FK

copilot_user_metric

Column	Type	Keys
`day`	String	PK
`organization_id`	String	PK
`user_id`	Long	PK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`enterprise_id`	String
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`used_agent`	Boolean
`used_chat`	Boolean
`user_initiated_interaction_count`	Long
`user_login`	String

pull_request_ready_for_review_history

Column	Type	Keys
`created_at`	Instant	PK
`pull_request_id`	Long	PKFK
`actor_id`	Long	FK
`ready_for_review`	Boolean

project_v_2_custom_field

Column	Type	Keys
`project_v_2_field_id`	Long	PK
`project_v_2_item_id`	Long	PKFK
`data_type`	String
`name`	String
`value`	String

pull_request_auto_merge

Column	Type	Keys
`created_at`	Instant	PK
`enabled`	Boolean	PK
`pull_request_id`	Long	PKFK
`actor_id`	Long	FK

security_vulnerability

Column	Type	Keys
`_fivetran_id`	String	PK
`package_ecosystem`	String
`package_name`	String
`patched_version_identifier`	String
`severity`	String
`vulnerable_version_range`	String

security_cwe

Column	Type	Keys
`cwe_id`	String	PK
`name`	String

copilot_org_metric_by_language_feature

Column	Type	Keys
`feature`	String	PK
`language`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

copilot_org_metric_by_ide

Column	Type	Keys
`ide`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

issue_locked_history

Column	Type	Keys
`updated_at`	Instant	PK
`issue_id`	Long	PKFK
`actor_id`	Long	FK
`locked`	Boolean

branch_commit_relation

Column	Type	Keys
`branch_name`	String	PK
`commit_sha`	String	PKFK

copilot_org_metric_by_feature

Column	Type	Keys
`feature`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

user_email

Column	Type	Keys
`email`	String	PK
`user_id`	Long	FK
`name`	String

issue_comment

Column	Type	Keys
`id`	Long	PK
`issue_id`	Long	FK
`user_id`	Long	FK
`body`	String
`created_at`	Instant
`updated_at`	Instant

issue_mention

Column	Type	Keys
`updated_at`	Instant	PK
`issue_id`	Long	PKFK
`user_id`	Long	PKFK

security_reference

Column	Type	Keys
`url`	String	PK
`security_advisory_ghsa_id`	String	PKFK

page_view

Column	Type	Keys
`timestamp_value`	Instant	PK
`repository_id`	Long	PKFK
`count_value`	Int
`uniques`	Int

asset

Column	Type	Keys
`id`	Long	PK
`release_id`	Long	FK
`uploader_id`	Long	FK
`content_type`	String
`created_at`	Instant
`download_count`	Int
`label`	String
`name`	String
`size`	Long
`state`	String
`updated_at`	Instant

issue_assignee

Column	Type	Keys
`issue_id`	Long	PKFK
`user_id`	Long	PKFK

security_advisory

Column	Type	Keys
`ghsa_id`	String	PK
`cve_id`	String
`cvss_score`	Double
`cvss_vector_string`	String
`description`	String
`epss_percentage`	Double
`epss_percentile`	Double
`published_at`	Instant
`severity`	String
`updated_at`	Instant
`withdrawn_at`	Instant

pull_request_review

Column	Type	Keys
`id`	Long	PK
`commit_sha`	String	FK
`pull_request_id`	Long	FK
`user_id`	Long	FK
`body`	String
`state`	String
`submitted_at`	Instant

issue_label

Column	Type	Keys
`issue_id`	Long	PKFK
`label_id`	Long	PKFK
`label`	String

repo_collaborator

Column	Type	Keys
`repository_id`	Long	PKFK
`user_id`	Long	PKFK
`admin`	Boolean
`maintain`	Boolean
`pull`	Boolean
`push`	Boolean
`role_name`	String
`site_admin`	Boolean
`triage`	Boolean

pull_request_review_comments

Column	Type	Keys
`id`	Long	PK
`pull_request_id`	Long	PKFK
`parent_comment_id`	Long	FK
`pull_request_review_id`	Long	FK
`user_id`	Long	FK
`body`	String
`created_at`	Instant
`line`	Int
`original_line`	Int
`original_start_line`	Int
`path`	String
`reaction_minus_count`	Int
`reaction_plus_count`	Int
`start_line`	Int
`updated_at`	Instant

issue_assignee_history

Column	Type	Keys
`updated_at`	Instant	PK
`issue_id`	Long	PKFK
`user_id`	Long	PKFK
`assigner_id`	Long	FK
`assigned`	Boolean

copilot_seat

Column	Type	Keys
`organization`	String	PK
`assignee_id`	Long	PKFK
`assigning_team_id`	Long	FK
`created_at`	Instant
`last_activity_at`	Instant
`last_activity_editor`	String
`last_authenticated_at`	Instant
`pending_cancellation_date`	String
`plan_type`	String
`updated_at`	Instant

repository

Column	Type	Keys
`id`	Long	PK
`owner_id`	Long	FK
`archived`	Boolean
`created_at`	Instant
`default_branch`	String
`description`	String
`fork`	Boolean
`forks_count`	Int
`full_name`	String
`homepage`	String
`language`	String
`name`	String
`private`	Boolean
`watchers_count`	Int

team

Column	Type	Keys
`id`	Long	PK
`org_id`	Long	FK
`parent_id`	Long	FK
`description`	String
`name`	String
`privacy`	String
`slug`	String

repository_topic

Column	Type	Keys
`name`	String	PK
`repository_id`	Long	PKFK

repo_team

Column	Type	Keys
`repository_id`	Long	PKFK
`team_id`	Long	PKFK
`permission`	String

pull_request_review_dismissed

Column	Type	Keys
`pull_request_review_id`	Long	PKFK
`actor_id`	Long	FK
`dismissal_commit_sha`	String	FK
`created_at`	Instant
`dismissal_message`	String
`state`	String

commit_pull_request

Column	Type	Keys
`commit_sha`	String	PKFK
`pull_request_id`	Long	PKFK

org_member

Column	Type	Keys
`org_id`	Long	PKFK
`user_id`	Long	PKFK
`role`	String

commit

Column	Type	Keys
`sha`	String	PK
`author_email`	String	FK
`committer_email`	String	FK
`repository_id`	Long	FK
`author_date`	Instant
`author_name`	String
`committer_date`	Instant
`committer_name`	String
`message`	String

commit_check_run

Column	Type	Keys
`id`	Long	PK
`commit_sha`	String	PKFK
`app_id`	Long
`app_name`	String
`check_suite_id`	Long
`completed_at`	Instant
`conclusion`	String
`external_id`	String
`name`	String
`started_at`	Instant
`status`	String

issue_closed_history

Column	Type	Keys
`closed`	Boolean	PK
`updated_at`	Instant	PK
`issue_id`	Long	PKFK
`actor_id`	Long	FK
`commit_sha`	String	FK

security_advisory_cwe

Column	Type	Keys
`cwe_id`	String	PKFK
`security_advisory_id`	String	PKFK

copilot_user_metric_by_language_model

Column	Type	Keys
`language`	String	PK
`model`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`user_id`	Long	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

issue_referenced

Column	Type	Keys
`referenced_at`	Instant	PK
`issue_id`	Long	PKFK
`actor_id`	Long	FK
`commit_sha`	String	FK

requested_reviewer_history

Column	Type	Keys
`created_at`	Instant	PK
`requested_id`	Long	PK
`pull_request_id`	Long	PKFK
`actor_id`	Long	FK
`removed`	Boolean
`requested_reviewer_type`	String

workflow

Column	Type	Keys
`id`	Long	PK
`repository_id`	Long	FK
`created_at`	Instant
`name`	String
`path`	String
`state`	String
`updated_at`	Instant

copilot_org_metric_by_language_model

Column	Type	Keys
`language`	String	PK
`model`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

copilot_user_metric_by_model_feature

Column	Type	Keys
`feature`	String	PK
`model`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`user_id`	Long	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

release

Column	Type	Keys
`id`	Long	PK
`author_id`	Long	FK
`repository_id`	Long	FK
`body`	String
`created_at`	Instant
`draft`	Boolean
`name`	String
`prerelease`	Boolean
`published_at`	Instant
`tag_name`	String
`target_commitish`	String
`updated_at`	Instant

project_v_2

Column	Type	Keys
`id`	Long	PK
`creator_id`	Long	FK
`deleted_by_id`	Long	FK
`latest_status_update_creator_id`	Long	FK
`owner_id`	Long	FK
`closed_at`	Instant
`created_at`	Instant
`deleted_at`	Instant
`description`	String
`is_public`	Boolean
`is_template`	Boolean
`latest_status_update_body`	String
`latest_status_update_created_at`	Instant
`latest_status_update_id`	Long
`latest_status_update_start_date`	LocalDate
`latest_status_update_status`	String
`latest_status_update_target_date`	LocalDate
`latest_status_update_updated_at`	Instant
`number`	Long
`short_description`	String
`state`	String
`title`	String
`updated_at`	Instant

repository_clone

Column	Type	Keys
`timestamp_value`	Instant	PK
`repository_id`	Long	PKFK
`count_value`	Int
`uniques`	Int

commit_parent

Column	Type	Keys
`commit_sha`	String	PKFK
`parent_sha`	String	PKFK

workflow_run_job_step

Column	Type	Keys
`number`	Int	PK
`workflow_run_job_id`	Long	PKFK
`completed_at`	String
`conclusion`	String
`name`	String
`started_at`	String
`status`	String

pull_request_merge_queue

Column	Type	Keys
`added`	Boolean	PK
`created_at`	Instant	PK
`pull_request_id`	Long	PKFK
`actor_id`	Long	FK

repository_language

Column	Type	Keys
`name`	String	PK
`repository_id`	Long	PKFK
`bytes`	Long

security_alert

Column	Type	Keys
`number`	Long	PK
`repository_id`	Long	PKFK
`dismissed_by`	Long	FK
`security_advisory_ghsa_id`	String	FK
`vulnerability_id`	String	FK
`created_at`	Instant
`dependency_manifest_path`	String
`dependency_package_ecosystem`	String
`dependency_package_name`	String
`dependency_scope`	String
`dismissed_at`	Instant
`dismissed_comment`	String
`dismissed_reason`	String
`fixed_at`	Instant
`state`	String
`updated_at`	Instant

copilot_org_metric

Column	Type	Keys
`day`	String	PK
`organization_id`	String	PK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`daily_active_users`	Long
`enterprise_id`	String
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`monthly_active_agent_users`	Long
`monthly_active_chat_users`	Long
`monthly_active_users`	Long
`user_initiated_interaction_count`	Long
`weekly_active_users`	Long
`pull_requests_`

commit_status

Column	Type	Keys
`id`	Long	PK
`commit_sha`	String	PKFK
`context`	String
`created_at`	Instant
`description`	String
`state`	String
`target_url`	String
`updated_at`	Instant

issue_renamed

Column	Type	Keys
`updated_at`	Instant	PK
`issue_id`	Long	PKFK
`actor_id`	Long	FK
`from_name`	String
`to_name`	String

user

Column	Type	Keys
`id`	Long	PK
`bio`	String
`blog`	String
`company`	String
`created_at`	Instant
`hireable`	Boolean
`location`	String
`login`	String
`name`	String
`site_admin`	Boolean
`type`	String
`updated_at`	Instant

copilot_user_metric_by_ide

Column	Type	Keys
`ide`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`user_id`	Long	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`last_known_ide_version_ide_version`	String
`last_known_ide_version_sampled_at`	String
`last_known_plugin_version_plugin`	String
`last_known_plugin_version_plugin_version`	String
`last_known_plugin_version_sampled_at`	String
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

milestone

Column	Type	Keys
`id`	Long	PK
`creator_id`	Long	FK
`repository_id`	Long	FK
`closed_at`	Instant
`created_at`	Instant
`description`	String
`due_on`	Instant
`is_deleted`	Boolean
`number`	Long
`state`	String
`title`	String
`updated_at`	Instant

stargazer

Column	Type	Keys
`login`	String	PK
`repository_id`	Long	PKFK
`starred_at`	Instant

copilot_org_metric_by_model_feature

Column	Type	Keys
`feature`	String	PK
`model`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

workflow_run_job

Column	Type	Keys
`id`	Long	PK
`run_id`	Long	FK
`check_run_url`	String
`completed_at`	String
`conclusion`	String
`created_at`	String
`head_branch`	String
`head_sha`	String
`html_url`	String
`labels`	Json
`name`	String
`node_id`	String
`run_attempt`	Int
`run_url`	String
`runner_group_id`	Int
`runner_group_name`	String
`runner_id`	Int
`runner_name`	String
`started_at`	String
`status`	String
`url`	String
`workflow_name`	String

commit_file

Column	Type	Keys
`commit_sha`	String	PK
`filename`	String	PK
`additions`	Long
`changes`	Long
`deletions`	Long
`status`	String

security_advisory_vulnerability

Column	Type	Keys
`security_advisory_id`	String	PKFK
`vulnerability_id`	String	PKFK

copilot_user_metric_by_feature

Column	Type	Keys
`feature`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`user_id`	Long	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

deployment

Column	Type	Keys
`id`	Long	PK
`commit_sha`	String	FK
`creator_id`	Long	FK
`created_at`	Instant
`description`	String
`environment`	String
`original_environment`	String
`payload`	Json
`production_environment`	Boolean
`ref`	String
`task`	String
`transient_environment`	Boolean
`updated_at`	Instant

project_v_2_item

Column	Type	Keys
`id`	Long	PK
`creator_id`	Long	FK
`milestone_id`	Long	FK
`parent_issue_id`	Long	FK
`project_v_2_id`	Long	FK
`repository_id`	Long	FK
`archived_at`	Instant
`created_at`	Instant
`status`	String
`updated_at`	Instant
`content_`

copilot_user_metric_by_language_feature

Column	Type	Keys
`feature`	String	PK
`language`	String	PK
`day`	String	PKFK
`organization_id`	String	PKFK
`user_id`	Long	PKFK
`code_acceptance_activity_count`	Long
`code_generation_activity_count`	Long
`loc_added_sum`	Long
`loc_deleted_sum`	Long
`loc_suggested_to_add_sum`	Long
`loc_suggested_to_delete_sum`	Long
`user_initiated_interaction_count`	Long

issue_milestone_history

Column	Type	Keys
`updated_at`	Instant	PK
`issue_id`	Long	PKFK
`actor_id`	Long	FK
`milestone_id`	Long	FK
`milestoned`	Boolean

repository_property

Column	Type	Keys
`name`	String	PK
`repository_id`	Long	PKFK
`value`	String