# GitHub schema ERD

Table and field reference for the Fivetran GitHub connector.

## 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 | PK, FK |
| label_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Long | PK, FK |
| role | String |  |

### workflow_run_pull_request

| Column | Type | Keys |
| --- | --- | --- |
| pull_request_id | Long | PK, FK |
| workflow_run_id | Long | PK, FK |

### 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 | PK, FK |
| issue_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| organization_id | String | PK, FK |
| 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 | PK, FK |
| organization_id | String | PK, FK |
| 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 | PK, FK |
| actor_id | Long | FK |
| locked | Boolean |  |

### branch_commit_relation

| Column | Type | Keys |
| --- | --- | --- |
| branch_name | String | PK |
| commit_sha | String | PK, FK |

### copilot_org_metric_by_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature | String | PK |
| day | String | PK, FK |
| organization_id | String | PK, FK |
| 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 | PK, FK |
| user_id | Long | PK, FK |

### security_reference

| Column | Type | Keys |
| --- | --- | --- |
| url | String | PK |
| security_advisory_ghsa_id | String | PK, FK |

### page_view

| Column | Type | Keys |
| --- | --- | --- |
| timestamp_value | Instant | PK |
| repository_id | Long | PK, FK |
| 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 | PK, FK |
| user_id | Long | PK, FK |

### 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 | PK, FK |
| label_id | Long | PK, FK |
| label | String |  |

### repo_collaborator

| Column | Type | Keys |
| --- | --- | --- |
| repository_id | Long | PK, FK |
| user_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Long | PK, FK |
| assigner_id | Long | FK |
| assigned | Boolean |  |

### copilot_seat

| Column | Type | Keys |
| --- | --- | --- |
| organization | String | PK |
| assignee_id | Long | PK, FK |
| 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 | PK, FK |

### repo_team

| Column | Type | Keys |
| --- | --- | --- |
| repository_id | Long | PK, FK |
| team_id | Long | PK, FK |
| permission | String |  |

### pull_request_review_dismissed

| Column | Type | Keys |
| --- | --- | --- |
| pull_request_review_id | Long | PK, FK |
| 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 | PK, FK |
| pull_request_id | Long | PK, FK |

### org_member

| Column | Type | Keys |
| --- | --- | --- |
| org_id | Long | PK, FK |
| user_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| actor_id | Long | FK |
| commit_sha | String | FK |

### security_advisory_cwe

| Column | Type | Keys |
| --- | --- | --- |
| cwe_id | String | PK, FK |
| security_advisory_id | String | PK, FK |

### copilot_user_metric_by_language_model

| Column | Type | Keys |
| --- | --- | --- |
| language | String | PK |
| model | String | PK |
| day | String | PK, FK |
| organization_id | String | PK, FK |
| user_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| organization_id | String | PK, FK |
| 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 | PK, FK |
| organization_id | String | PK, FK |
| user_id | Long | PK, FK |
| 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 | PK, FK |
| count_value | Int |  |
| uniques | Int |  |

### commit_parent

| Column | Type | Keys |
| --- | --- | --- |
| commit_sha | String | PK, FK |
| parent_sha | String | PK, FK |

### workflow_run_job_step

| Column | Type | Keys |
| --- | --- | --- |
| number | Int | PK |
| workflow_run_job_id | Long | PK, FK |
| 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 | PK, FK |
| actor_id | Long | FK |

### repository_language

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| repository_id | Long | PK, FK |
| bytes | Long |  |

### security_alert

| Column | Type | Keys |
| --- | --- | --- |
| number | Long | PK |
| repository_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| organization_id | String | PK, FK |
| user_id | Long | PK, FK |
| 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 | PK, FK |
| starred_at | Instant |  |

### copilot_org_metric_by_model_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature | String | PK |
| model | String | PK |
| day | String | PK, FK |
| organization_id | String | PK, FK |
| 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 | PK, FK |
| vulnerability_id | String | PK, FK |

### copilot_user_metric_by_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature | String | PK |
| day | String | PK, FK |
| organization_id | String | PK, FK |
| user_id | Long | PK, FK |
| 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 | PK, FK |
| organization_id | String | PK, FK |
| user_id | Long | PK, FK |
| 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 | PK, FK |
| actor_id | Long | FK |
| milestone_id | Long | FK |
| milestoned | Boolean |  |

### repository_property

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| repository_id | Long | PK, FK |
| value | String |  |

## Relationships

- issue(repository_id) → repository(id)
- issue(milestone_id) → milestone(id)
- issue(user_id) → user(id)
- issue_label_history(issue_id) → issue(id)
- issue_label_history(label_id) → label(id)
- issue_label_history(actor_id) → user(id)
- deployment_status(deployment_id) → deployment(id)
- deployment_status(creator_id) → user(id)
- workflow_run_attempt(id) → workflow_run(id)
- workflow_run_attempt(head_sha) → commit(sha)
- workflow_run_attempt(repository_id) → repository(id)
- workflow_run_attempt(workflow_id) → workflow(id)
- workflow_run_attempt(actor_id) → user(id)
- workflow_run_attempt(triggering_actor_id) → user(id)
- pull_request(issue_id) → issue(id)
- pull_request(head_repo_id) → repository(id)
- pull_request(head_user_id) → user(id)
- pull_request(base_repo_id) → repository(id)
- pull_request(base_user_id) → user(id)
- team_membership(team_id) → team(id)
- team_membership(user_id) → user(id)
- workflow_run_pull_request(workflow_run_id) → workflow_run(id)
- workflow_run_pull_request(pull_request_id) → pull_request(id)
- workflow_run(head_sha) → commit(sha)
- workflow_run(repository_id) → repository(id)
- workflow_run(workflow_id) → workflow(id)
- workflow_run(actor_id) → user(id)
- workflow_run(triggering_actor_id) → user(id)
- issue_merged(issue_id) → issue(id)
- issue_merged(commit_sha) → commit(sha)
- issue_merged(actor_id) → user(id)
- pull_request_ready_for_review_history(pull_request_id) → pull_request(id)
- pull_request_ready_for_review_history(actor_id) → user(id)
- project_v_2_custom_field(project_v_2_item_id) → project_v_2(id)
- pull_request_auto_merge(pull_request_id) → pull_request(id)
- pull_request_auto_merge(actor_id) → user(id)
- copilot_org_metric_by_language_feature(day) → copilot_org_metric(day)
- copilot_org_metric_by_language_feature(organization_id) → copilot_org_metric(organization_id)
- copilot_org_metric_by_ide(day) → copilot_org_metric(day)
- copilot_org_metric_by_ide(organization_id) → copilot_org_metric(organization_id)
- issue_locked_history(issue_id) → issue(id)
- issue_locked_history(actor_id) → user(id)
- branch_commit_relation(commit_sha) → commit(sha)
- copilot_org_metric_by_feature(day) → copilot_org_metric(day)
- copilot_org_metric_by_feature(organization_id) → copilot_org_metric(organization_id)
- user_email(user_id) → user(id)
- issue_comment(issue_id) → issue(id)
- issue_comment(user_id) → user(id)
- issue_mention(issue_id) → issue(id)
- issue_mention(user_id) → user(id)
- security_reference(security_advisory_ghsa_id) → security_advisory(ghsa_id)
- page_view(repository_id) → repository(id)
- asset(release_id) → release(id)
- asset(uploader_id) → user(id)
- issue_assignee(issue_id) → issue(id)
- issue_assignee(user_id) → user(id)
- pull_request_review(pull_request_id) → pull_request(id)
- pull_request_review(user_id) → user(id)
- pull_request_review(commit_sha) → commit(sha)
- issue_label(issue_id) → issue(id)
- issue_label(label_id) → label(id)
- repo_collaborator(repository_id) → repository(id)
- repo_collaborator(user_id) → user(id)
- pull_request_review_comments(pull_request_id) → pull_request(id)
- pull_request_review_comments(pull_request_review_id) → pull_request_review(id)
- pull_request_review_comments(parent_comment_id) → pull_request_review_comments(id)
- pull_request_review_comments(user_id) → user(id)
- issue_assignee_history(issue_id) → issue(id)
- issue_assignee_history(user_id) → user(id)
- issue_assignee_history(assigner_id) → user(id)
- copilot_seat(assignee_id) → user(id)
- copilot_seat(assigning_team_id) → team(id)
- repository(owner_id) → user(id)
- team(org_id) → user(id)
- team(parent_id) → team(id)
- repository_topic(repository_id) → repository(id)
- repo_team(repository_id) → repository(id)
- repo_team(team_id) → team(id)
- pull_request_review_dismissed(actor_id) → user(id)
- pull_request_review_dismissed(pull_request_review_id) → pull_request_review(id)
- pull_request_review_dismissed(dismissal_commit_sha) → commit(sha)
- commit_pull_request(commit_sha) → commit(sha)
- commit_pull_request(pull_request_id) → pull_request(id)
- org_member(org_id) → user(id)
- org_member(user_id) → user(id)
- commit(repository_id) → repository(id)
- commit(author_email) → user_email(email)
- commit(committer_email) → user_email(email)
- commit_check_run(commit_sha) → commit(sha)
- issue_closed_history(issue_id) → issue(id)
- issue_closed_history(actor_id) → user(id)
- issue_closed_history(commit_sha) → commit(sha)
- security_advisory_cwe(cwe_id) → security_cwe(cwe_id)
- security_advisory_cwe(security_advisory_id) → security_advisory(ghsa_id)
- copilot_user_metric_by_language_model(day) → copilot_user_metric(day)
- copilot_user_metric_by_language_model(organization_id) → copilot_user_metric(organization_id)
- copilot_user_metric_by_language_model(user_id) → copilot_user_metric(user_id)
- issue_referenced(issue_id) → issue(id)
- issue_referenced(commit_sha) → commit(sha)
- issue_referenced(actor_id) → user(id)
- requested_reviewer_history(pull_request_id) → pull_request(id)
- requested_reviewer_history(actor_id) → user(id)
- workflow(repository_id) → repository(id)
- copilot_org_metric_by_language_model(day) → copilot_org_metric(day)
- copilot_org_metric_by_language_model(organization_id) → copilot_org_metric(organization_id)
- copilot_user_metric_by_model_feature(day) → copilot_user_metric(day)
- copilot_user_metric_by_model_feature(organization_id) → copilot_user_metric(organization_id)
- copilot_user_metric_by_model_feature(user_id) → copilot_user_metric(user_id)
- release(repository_id) → repository(id)
- release(author_id) → user(id)
- project_v_2(latest_status_update_creator_id) → user(id)
- project_v_2(deleted_by_id) → user(id)
- project_v_2(creator_id) → user(id)
- project_v_2(owner_id) → user(id)
- repository_clone(repository_id) → repository(id)
- commit_parent(commit_sha) → commit(sha)
- commit_parent(parent_sha) → commit(sha)
- workflow_run_job_step(workflow_run_job_id) → workflow_run_job(id)
- pull_request_merge_queue(pull_request_id) → pull_request(id)
- pull_request_merge_queue(actor_id) → user(id)
- repository_language(repository_id) → repository(id)
- security_alert(repository_id) → repository(id)
- security_alert(vulnerability_id) → security_vulnerability(_fivetran_id)
- security_alert(security_advisory_ghsa_id) → security_advisory(ghsa_id)
- security_alert(dismissed_by) → user(id)
- commit_status(commit_sha) → commit(sha)
- issue_renamed(issue_id) → issue(id)
- issue_renamed(actor_id) → user(id)
- copilot_user_metric_by_ide(day) → copilot_user_metric(day)
- copilot_user_metric_by_ide(organization_id) → copilot_user_metric(organization_id)
- copilot_user_metric_by_ide(user_id) → copilot_user_metric(user_id)
- milestone(repository_id) → repository(id)
- milestone(creator_id) → user(id)
- stargazer(repository_id) → repository(id)
- copilot_org_metric_by_model_feature(day) → copilot_org_metric(day)
- copilot_org_metric_by_model_feature(organization_id) → copilot_org_metric(organization_id)
- workflow_run_job(run_id) → workflow_run(id)
- security_advisory_vulnerability(vulnerability_id) → security_vulnerability(_fivetran_id)
- security_advisory_vulnerability(security_advisory_id) → security_advisory(ghsa_id)
- copilot_user_metric_by_feature(day) → copilot_user_metric(day)
- copilot_user_metric_by_feature(organization_id) → copilot_user_metric(organization_id)
- copilot_user_metric_by_feature(user_id) → copilot_user_metric(user_id)
- deployment(commit_sha) → commit(sha)
- deployment(creator_id) → user(id)
- project_v_2_item(project_v_2_id) → project_v_2(id)
- project_v_2_item(milestone_id) → milestone(id)
- project_v_2_item(repository_id) → repository(id)
- project_v_2_item(parent_issue_id) → issue(id)
- project_v_2_item(creator_id) → user(id)
- copilot_user_metric_by_language_feature(day) → copilot_user_metric(day)
- copilot_user_metric_by_language_feature(organization_id) → copilot_user_metric(organization_id)
- copilot_user_metric_by_language_feature(user_id) → copilot_user_metric(user_id)
- issue_milestone_history(issue_id) → issue(id)
- issue_milestone_history(milestone_id) → milestone(id)
- issue_milestone_history(actor_id) → user(id)
- repository_property(repository_id) → repository(id)