# GitLab schema ERD

Table and field reference for the Fivetran GitLab connector.

## Table & Field Reference

### project_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | FK |
| created_at | Instant |  |
| description | String |  |
| due_date | String |  |
| expired | Boolean |  |
| iid | Long |  |
| start_date | String |  |
| state | String |  |
| title | String |  |
| updated_at | Instant |  |
| web_url | String |  |

### project_member

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | PK, FK |
| created_by_id | String | FK |
| access_level | Long |  |
| avatar_url | String |  |
| created_at | Instant |  |
| expires_at | String |  |
| group_saml_identity_extern_uid | String |  |
| group_saml_identity_provider | String |  |
| group_saml_identity_saml_provider_id | String |  |
| membership_state | String |  |
| name | String |  |
| state | String |  |
| username | String |  |
| web_url | String |  |

### project_topic

| Column | Type | Keys |
| --- | --- | --- |
| topic | String | PK |
| project_id | String | PK, FK |

### project_compliance_framework

| Column | Type | Keys |
| --- | --- | --- |
| compliance_framework | String | PK |
| project_id | String | PK, FK |

### project_shared_with_group

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_id | String | FK |
| compliance_frameworks | String |  |
| group_access_level | String |  |
| group_full_path | String |  |
| group_name | String |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| namespace_id | String | FK |
| _links_cluster_agents | String |  |
| _links_events | String |  |
| _links_issues | String |  |
| _links_labels | String |  |
| _links_members | String |  |
| _links_merge_requests | String |  |
| _links_repo_branches | String |  |
| _links_self | String |  |
| allow_merge_on_skipped_pipeline | Boolean |  |
| analytics_access_level | String |  |
| archived | String |  |
| auto_cancel_pending_pipelines | String |  |
| auto_devops_deploy_strategy | String |  |
| auto_devops_enabled | String |  |
| autoclose_referenced_issues | Boolean |  |
| avatar_url | String |  |
| build_coverage_regex | String |  |
| build_timeout | String |  |
| builds_access_level | String |  |
| can_create_merge_request_in | Boolean |  |
| ci_config_path | String |  |
| ci_default_git_depth | String |  |
| ci_forward_deployment_enabled | Boolean |  |
| ci_job_token_scope_enabled | Boolean |  |
| ci_separated_caches | Boolean |  |
| container_expiration_policy_cadence | String |  |
| container_expiration_policy_enabled | String |  |
| container_expiration_policy_keep_n | String |  |
| container_expiration_policy_name_regex | String |  |
| container_expiration_policy_name_regex_keep | String |  |
| container_expiration_policy_next_run_at | String |  |
| container_expiration_policy_older_than | String |  |
| container_registry_access_level | String |  |
| container_registry_image_prefix | String |  |
| created_at | Instant |  |
| creator_id | String |  |
| default_branch | String |  |
| description | String |  |
| emails_disabled | String |  |
| empty_repo | String |  |
| enforce_auth_checks_on_uploads | Boolean |  |
| external_authorization_classification_label | String |  |
| forking_access_level | String |  |
| forks_count | String |  |
| http_url_to_repo | String |  |
| import_status | String |  |
| import_type | String |  |
| import_url | String |  |
| issues_access_level | String |  |
| issues_enabled | Boolean |  |
| jobs_enabled | Boolean |  |
| keep_latest_artifact | Boolean |  |
| last_activity_at | Instant |  |
| lfs_enabled | Boolean |  |
| marked_for_deletion_on | String |  |
| merge_commit_template | String |  |
| merge_method | String |  |
| merge_requests_access_level | String |  |
| merge_requests_enabled | Boolean |  |
| name | String |  |
| name_with_namespace | String |  |
| namespace_avatar_url | String |  |
| namespace_full_path | String |  |
| namespace_kind | String |  |
| namespace_name | String |  |
| namespace_parent_id | String |  |
| namespace_path | String |  |
| namespace_web_url | String |  |
| only_allow_merge_if_all_discussions_are_resolved | Boolean |  |
| only_allow_merge_if_pipeline_succeeds | Boolean |  |
| open_issues_count | String |  |
| operations_access_level | String |  |
| owner_created_at | Instant |  |
| owner_id | String |  |
| owner_name | String |  |
| packages_enabled | String |  |
| pages_access_level | String |  |
| path | String |  |
| path_with_namespace | String |  |
| permissions_group_access_access_level | String |  |
| permissions_group_access_notification_level | String |  |
| permissions_project_access_access_level | String |  |
| permissions_project_access_notification_level | String |  |
| printing_merge_request_link_enabled | Boolean |  |
| public_jobs | Boolean |  |
| readme_url | String |  |
| remove_source_branch_after_merge | Boolean |  |
| repository_access_level | String |  |
| request_access_enabled | Boolean |  |
| requirements_access_level | String |  |
| requirements_enabled | Boolean |  |
| resolve_outdated_diff_discussions | String |  |
| restrict_user_defined_variables | Boolean |  |
| runner_token_expiration_interval | String |  |
| runners_token | String |  |
| security_and_compliance_access_level | String |  |
| security_and_compliance_enabled | Boolean |  |
| service_desk_address | String |  |
| service_desk_enabled | Boolean |  |
| shared_runners_enabled | Boolean |  |
| snippets_access_level | String |  |
| snippets_enabled | Boolean |  |
| squash_commit_template | String |  |
| squash_option | String |  |
| ssh_url_to_repo | String |  |
| star_count | String |  |
| statistics_commit_count | Long |  |
| statistics_job_artifacts_size | Long |  |
| statistics_lfs_objects_size | Long |  |
| statistics_packages_size | Long |  |
| statistics_pipeline_artifacts_size | Long |  |
| statistics_repository_size | Long |  |
| statistics_snippets_size | Long |  |
| statistics_storage_size | Long |  |
| statistics_uploads_size | Long |  |
| statistics_wiki_size | Long |  |
| suggestion_commit_message | String |  |
| visibility | String |  |
| web_url | String |  |
| wiki_access_level | String |  |
| wiki_enabled | Boolean |  |

### groups_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| group_id | Unknown | FK |
| milestone_id | Unknown | FK |
| _links_award_emoji | Unknown |  |
| _links_notes | Unknown |  |
| _links_project | Unknown |  |
| _links_self | Unknown |  |
| assignee_avatar_url | Unknown |  |
| assignee_id | Unknown |  |
| assignee_name | Unknown |  |
| assignee_state | Unknown |  |
| assignee_username | Unknown |  |
| assignee_web_url | Unknown |  |
| closed_at | Unknown |  |
| confidential | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| discussion_locked | Unknown |  |
| down_votes | Unknown |  |
| due_date | Unknown |  |
| has_tasks | Unknown |  |
| iid | Unknown |  |
| issue_type | Unknown |  |
| merge_requests_count | Unknown |  |
| references_full | Unknown |  |
| references_relative | Unknown |  |
| references_short | Unknown |  |
| severity | Unknown |  |
| state | Unknown |  |
| time_stats_human_time_estimate | Unknown |  |
| time_stats_human_total_time_spent | Unknown |  |
| time_stats_time_estimate | Unknown |  |
| time_stats_total_time_spent | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| up_votes | Unknown |  |
| updated_at | Instant |  |
| user_notes_count | Unknown |  |
| web_url | Unknown |  |
| weight | Unknown |  |

### groups_label

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| groups_id | String | PK, FK |
| closed_issues_count | Long |  |
| color | String |  |
| description | String |  |
| description_html | String |  |
| name | String |  |
| open_issues_count | Long |  |
| open_merge_requests_count | Long |  |
| subscribed | Boolean |  |
| text_color | String |  |

### project_vulnerability

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| project_id | Unknown | FK |
| confidence | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| dismissed_at | Unknown |  |
| dismissed_by_id | Unknown |  |
| finding_confidence | Unknown |  |
| finding_created_at | Unknown |  |
| finding_id | Unknown |  |
| finding_location_fingerprint | Unknown |  |
| finding_metadata_version | Unknown |  |
| finding_name | Unknown |  |
| finding_primary_identifier_id | Unknown |  |
| finding_project_id | Unknown |  |
| finding_raw_metadata | Unknown |  |
| finding_report_type | Unknown |  |
| finding_scanner_id | Unknown |  |
| finding_severity | Unknown |  |
| finding_updated_at | Unknown |  |
| finding_uuid | Unknown |  |
| finding_vulnerability_id | Unknown |  |
| project_default_branch | Unknown |  |
| report_type | Unknown |  |
| resolved_at | Unknown |  |
| resolved_by_id | Unknown |  |
| resolved_on_default_branch | Unknown |  |
| severity | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |

### project_repo_tag_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| parent_id | String | PK |
| project_repo_tag_fivetran_id | Unknown | PK, FK |

### project_repo_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| commit_id | String | FK |
| project_id | String | FK |
| message | String |  |
| name | String |  |
| protected | String |  |
| release_description | String |  |
| release_tag_name | String |  |
| target | String |  |

### project_commit_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| parent_id | String | PK |
| project_commit_id | String | PK, FK |
| project_id | String | PK, FK |

### project_commit

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | PK, FK |
| author_email | String |  |
| author_name | String |  |
| authored_date | Instant |  |
| committed_date | Instant |  |
| committer_email | String |  |
| committer_name | String |  |
| created_at | Instant |  |
| extended_trailers | Json |  |
| message | String |  |
| short_id | String |  |
| stats_addition | Unknown |  |
| stats_deletion | Unknown |  |
| stats_total | Unknown |  |
| title | String |  |
| trailers | Json |  |
| web_url | String |  |

### groups_iteration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| iid | Unknown |  |
| sequence | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |
| web_url | Unknown |  |

### project_job_tag_list

| Column | Type | Keys |
| --- | --- | --- |
| tag_list | String | PK |
| project_job_id | String | PK, FK |

### project_job_artifact

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_job_id | String | FK |
| file_format | String |  |
| file_type | String |  |
| filename | String |  |
| size | String |  |

### project_job

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | PK, FK |
| commit_id | String | FK |
| user_id | String | FK |
| allow_failure | Boolean |  |
| artifacts_expire_at | Instant |  |
| artifacts_file_filename | String |  |
| artifacts_file_size | String |  |
| coverage | String |  |
| created_at | Instant |  |
| duration | String |  |
| failure_reason | String |  |
| finished_at | Instant |  |
| name | String |  |
| pipeline_id | String |  |
| pipeline_project_id | String |  |
| pipeline_ref | String |  |
| pipeline_sha | String |  |
| pipeline_status | String |  |
| queued_duration | String |  |
| ref | String |  |
| runner_active | Boolean |  |
| runner_description | String |  |
| runner_id | String |  |
| runner_ip_address | String |  |
| runner_is_shared | Boolean |  |
| runner_name | String |  |
| runner_online | Boolean |  |
| runner_paused | Boolean |  |
| runner_runner_type | String |  |
| runner_status | String |  |
| stage | String |  |
| started_at | Instant |  |
| status | String |  |
| tags | Boolean |  |
| web_url | String |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| auto_devops_enabled | Boolean |  |
| avatar_url | String |  |
| created_at | Instant |  |
| default_branch_protection | Long |  |
| description | String |  |
| emails_disabled | String |  |
| file_template_project_id | Long |  |
| full_name | String |  |
| full_path | String |  |
| ldap_access | String |  |
| ldap_cn | String |  |
| lfs_enabled | Boolean |  |
| mentions_disabled | String |  |
| name | String |  |
| parent_id | String |  |
| path | String |  |
| project_creation_level | String |  |
| request_access_enabled | Boolean |  |
| require_two_factor_authentication | Boolean |  |
| share_with_group_lock | Boolean |  |
| statistics_job_artifacts_size | Long |  |
| statistics_lfs_objects_size | Long |  |
| statistics_packages_size | Long |  |
| statistics_pipeline_artifacts_size | Long |  |
| statistics_repository_size | Long |  |
| statistics_snippets_size | Long |  |
| statistics_storage_size | Long |  |
| statistics_uploads_size | Long |  |
| statistics_wiki_size | Long |  |
| subgroup_creation_level | String |  |
| two_factor_grace_period | Long |  |
| visibility | String |  |
| web_url | String |  |

### project_merge_request_assignee

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_merge_request_id | String | PK, FK |
| avatar_url | String |  |
| name | String |  |
| state | String |  |
| username | String |  |
| web_url | String |  |

### project_merge_request_reviewer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_merge_request_id | String | PK, FK |
| avatar_url | String |  |
| name | String |  |
| state | String |  |
| username | String |  |
| web_url | String |  |

### project_merge_request_label

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| project_merge_request_id | String | PK, FK |

### project_merge_request

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| author_id | String | FK |
| milestone_id | String | FK |
| project_id | String | FK |
| allow_collaboration | String |  |
| allow_maintainer_to_push | String |  |
| assignee_avatar_url | String |  |
| assignee_id | String |  |
| assignee_name | String |  |
| assignee_state | String |  |
| assignee_username | String |  |
| assignee_web_url | String |  |
| blocking_discussions_resolved | String |  |
| closed_at | Instant |  |
| closed_by | String |  |
| created_at | Instant |  |
| description | String |  |
| discussion_locked | String |  |
| downvotes | String |  |
| draft | String |  |
| force_remove_source_branch | String |  |
| has_conflicts | String |  |
| iid | Long |  |
| merge_commit_sha | String |  |
| merge_status | String |  |
| merge_user_avatar_url | String |  |
| merge_user_id | String |  |
| merge_user_name | String |  |
| merge_user_state | String |  |
| merge_user_username | String |  |
| merge_user_web_url | String |  |
| merge_when_pipeline_succeeds | String |  |
| merged_at | String |  |
| merged_by_avatar_url | String |  |
| merged_by_id | String |  |
| merged_by_name | String |  |
| merged_by_state | String |  |
| merged_by_username | String |  |
| merged_by_web_url | String |  |
| references_full | String |  |
| references_relative | String |  |
| references_short | String |  |
| sha | String |  |
| should_remove_source_branch | String |  |
| source_branch | String |  |
| source_project_id | String |  |
| squash | String |  |
| squash_commit_sha | String |  |
| state | String |  |
| target_branch | String |  |
| target_project_id | String |  |
| task_completion_status_completed_count | String |  |
| task_completion_status_count | String |  |
| time_stats_human_time_estimate | String |  |
| time_stats_human_total_time_spent | String |  |
| time_stats_time_estimate | String |  |
| time_stats_total_time_spent | String |  |
| title | String |  |
| updated_at | Instant |  |
| upvotes | String |  |
| user_notes_count | String |  |
| web_url | String |  |
| work_in_progress | String |  |

### project_label

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | FK |
| color | String |  |
| description | String |  |
| description_html | String |  |
| is_project_label | Boolean |  |
| name | String |  |
| priority | String |  |
| subscribed | Boolean |  |
| text_color | String |  |

### groups_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| group_id | String | FK |
| created_at | Instant |  |
| description | String |  |
| due_date | String |  |
| expired | Boolean |  |
| iid | Long |  |
| start_date | String |  |
| state | String |  |
| title | String |  |
| updated_at | Instant |  |
| web_url | String |  |

### project_user_identity

| Column | Type | Keys |
| --- | --- | --- |
| extern_uid | String | PK |
| project_user_id | String | PK, FK |
| provider | String |  |

### project_user

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | PK, FK |
| avatar_url | String |  |
| bio | String |  |
| can_create_group | Boolean |  |
| can_create_project | Boolean |  |
| color_scheme_id | String |  |
| confirmed_at | Instant |  |
| created_at | Instant |  |
| current_sign_in_at | Instant |  |
| current_sign_in_ip | String |  |
| email | String |  |
| external | Boolean |  |
| is_admin | Boolean |  |
| job_title | String |  |
| last_activity_on | String |  |
| last_sign_in_at | Instant |  |
| last_sign_in_ip | String |  |
| linkedin | String |  |
| location | String |  |
| name | String |  |
| namespace_id | String |  |
| note | String |  |
| organization | String |  |
| private_profile | Boolean |  |
| projects_limit | Long |  |
| skype | String |  |
| state | String |  |
| theme_id | Long |  |
| twitter | String |  |
| two_factor_enabled | Boolean |  |
| username | String |  |
| web_url | String |  |
| website_url | String |  |

### project_issue_assignee

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_issue_id | String | PK, FK |
| avatar_url | String |  |
| name | String |  |
| state | String |  |
| username | String |  |
| web_url | String |  |

### project_issue_label

| Column | Type | Keys |
| --- | --- | --- |
| label | String | PK |
| project_issue_id | String | PK, FK |

### project_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| author_id | String | FK |
| milestone_id | String | FK |
| project_id | String | FK |
| _links_award_emoji | String |  |
| _links_notes | String |  |
| _links_project | String |  |
| _links_self | String |  |
| assignee_avatar_url | String |  |
| assignee_id | String |  |
| assignee_name | String |  |
| assignee_state | String |  |
| assignee_username | String |  |
| assignee_web_url | String |  |
| closed_at | Instant |  |
| closed_by_avatar_url | String |  |
| closed_by_id | String |  |
| closed_by_name | String |  |
| closed_by_state | String |  |
| closed_by_username | String |  |
| closed_by_web_url | String |  |
| confidential | String |  |
| created_at | Instant |  |
| description | String |  |
| discussion_locked | String |  |
| downvotes | String |  |
| due_date | String |  |
| has_tasks | Boolean |  |
| iid | Long |  |
| issue_type | String |  |
| merge_requests_count | String |  |
| references_full | String |  |
| references_relative | String |  |
| references_short | String |  |
| severity | String |  |
| state | String |  |
| task_completion_status_completed_count | String |  |
| task_completion_status_count | String |  |
| task_status | String |  |
| time_stats_human_time_estimate | String |  |
| time_stats_human_total_time_spent | String |  |
| time_stats_time_estimate | String |  |
| time_stats_total_time_spent | String |  |
| title | String |  |
| type | String |  |
| updated_at | Instant |  |
| upvotes | String |  |
| user_notes_count | String |  |
| web_url | String |  |
| weight | Unknown |  |

### project_release_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| parent_id | Unknown | PK |
| project_release_fivetran_id | Unknown | PK, FK |

### project_release_asset_source

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_release_fivetran_id | Unknown | FK |
| format | String |  |
| url | String |  |

### project_release_asset_link

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_release_fivetran_id | Unknown | PK, FK |
| external | String |  |
| link_type | String |  |
| name | String |  |
| url | String |  |

### project_release_evidence

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_release_fivetran_id | Unknown | PK, FK |
| collected_at | String |  |
| filepath | String |  |
| sha | String |  |

### project_release_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_release_fivetran_id | Unknown | PK, FK |
| created_at | Instant |  |
| description | String |  |
| due_date | String |  |
| iid | Long |  |
| issue_stats_closed | String |  |
| issue_stats_total | String |  |
| project_id | String |  |
| start_date | String |  |
| state | String |  |
| title | String |  |
| updated_at | Instant |  |
| web_url | String |  |

### project_release

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_id | String | PK, FK |
| author_id | String | FK |
| commit_id | String | FK |
| assets_count | String |  |
| assets_evidence_file_path | String |  |
| commit_path | String |  |
| created_at | String |  |
| description | String |  |
| name | String |  |
| released_at | Instant |  |
| tag_name | String |  |
| tag_path | String |  |

### epic_issue_label

| Column | Type | Keys |
| --- | --- | --- |
| label | String | PK |
| epic_issue_id | String | PK, FK |

### epic_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| author_id | String | FK |
| group_id | String | FK |
| _links_epic_issues | String |  |
| _links_group | String |  |
| _links_parent | String |  |
| _links_self | String |  |
| closed_at | Instant |  |
| color | String |  |
| confidential | String |  |
| created_at | Instant |  |
| description | String |  |
| downvotes | Long |  |
| due_date | String |  |
| due_date_fixed | String |  |
| due_date_from_inherited_source | String |  |
| due_date_from_milestones | String |  |
| due_date_is_fixed | Boolean |  |
| end_date | String |  |
| iid | Long |  |
| parent_id | String |  |
| parent_iid | Long |  |
| reference | String |  |
| references_full | String |  |
| references_relative | String |  |
| references_short | String |  |
| start_date | String |  |
| start_date_fixed | String |  |
| start_date_from_inherited_source | String |  |
| start_date_from_milestones | String |  |
| start_date_is_fixed | Boolean |  |
| state | String |  |
| text_color | String |  |
| title | String |  |
| updated_at | Instant |  |
| upvotes | Long |  |
| web_edit_url | String |  |
| web_url | String |  |

### groups_epic_board_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| groups_epic_board_id | Unknown | PK, FK |
| group_id | Unknown | FK |
| project_id | Unknown | FK |
| color | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| template | Unknown |  |
| text_color | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### groups_epic_board_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| groups_epic_board_id | Unknown | PK, FK |
| label_id | Unknown | FK |
| list_type | Unknown |  |
| position | Unknown |  |

### groups_epic_board

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| hide_backlog_list | Unknown |  |
| hide_closed_list | Unknown |  |
| name | Unknown |  |

### project_branch_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| parent_id | String | PK |
| project_branch_fivetran_id | Unknown | PK, FK |

### project_branch

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| commit_id | String | FK |
| project_id | String | FK |
| can_push | Boolean |  |
| defaults | Boolean |  |
| developers_can_merge | Boolean |  |
| developers_can_push | Boolean |  |
| merged | Boolean |  |
| name | String |  |
| protected | Boolean |  |
| web_url | String |  |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| groups_id | String | PK, FK |
| created_by_id | String | FK |
| access_level | Long |  |
| avatar_url | String |  |
| created_at | Instant |  |
| expires_at | String |  |
| group_saml_identity_extern_uid | String |  |
| group_saml_identity_provider | String |  |
| group_saml_identity_saml_provider_id | Long |  |
| membership_state | String |  |
| name | String |  |
| state | String |  |
| username | String |  |
| web_url | String |  |

### project_merge_request_discussion_note

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | PK |
| project_merge_request_iid | Long | PK |
| project_merge_request_discussion_id | String | PK, FK |
| author_id | String | FK |
| attachment | Unknown |  |
| author_avatar_url | String |  |
| author_name | String |  |
| author_state | String |  |
| author_username | String |  |
| author_web_url | String |  |
| body | String |  |
| created_at | Instant |  |
| is_system | Boolean |  |
| noteable_id | String |  |
| noteable_iid | Unknown |  |
| noteable_type | String |  |
| position_base_sha | String |  |
| position_head_sha | String |  |
| position_line_range | Json |  |
| position_new_line | String |  |
| position_new_path | String |  |
| position_old_line | String |  |
| position_old_path | String |  |
| position_position_type | String |  |
| position_start_sha | String |  |
| resolvable | Boolean |  |
| resolved | Boolean |  |
| resolved_at | Instant |  |
| resolved_by | Json |  |
| suggestions | Json |  |
| type | String |  |
| updated_at | Instant |  |

### project_merge_request_discussion

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | PK, FK |
| project_merge_request_iid | Long | PK, FK |
| individual_note | Boolean |  |

### project_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_id | String | FK |
| created_at | Instant |  |
| iid | Long |  |
| ref | String |  |
| sha | String |  |
| source | String |  |
| status | String |  |
| updated_at | Instant |  |
| web_url | String |  |

## Relationships

- project_milestone(project_id) → project(id)
- project_member(created_by_id) → project_user(id)
- project_member(project_id) → project(id)
- project_topic(project_id) → project(id)
- project_compliance_framework(project_id) → project(id)
- project_shared_with_group(project_id) → project(id)
- project(namespace_id) → groups(id)
- groups_issue(author_id) → project_user(id)
- groups_issue(group_id) → groups(id)
- groups_issue(milestone_id) → project_milestone(id)
- groups_label(groups_id) → groups(id)
- project_vulnerability(author_id) → project_user(id)
- project_vulnerability(project_id) → project(id)
- project_repo_tag_parent_id(project_repo_tag_fivetran_id) → project_repo_tag(_fivetran_id)
- project_repo_tag(commit_id) → project_commit(id)
- project_repo_tag(project_id) → project(id)
- project_commit_parent_id(project_id) → project_commit(project_id)
- project_commit_parent_id(project_commit_id) → project_commit(id)
- project_commit(project_id) → project(id)
- groups_iteration(group_id) → groups(id)
- project_job_tag_list(project_job_id) → project_job(id)
- project_job_artifact(project_job_id) → project_job(id)
- project_job(user_id) → project_user(id)
- project_job(commit_id) → project_commit(id)
- project_job(project_id) → project(id)
- project_merge_request_assignee(project_merge_request_id) → project_merge_request(id)
- project_merge_request_reviewer(project_merge_request_id) → project_merge_request(id)
- project_merge_request_label(project_merge_request_id) → project_merge_request(id)
- project_merge_request(author_id) → project_user(id)
- project_merge_request(milestone_id) → project_milestone(id)
- project_merge_request(project_id) → project(id)
- project_label(project_id) → project(id)
- groups_milestone(group_id) → groups(id)
- project_user_identity(project_user_id) → project_user(id)
- project_user(project_id) → project(id)
- project_issue_assignee(project_issue_id) → project_issue(id)
- project_issue_label(project_issue_id) → project_issue(id)
- project_issue(author_id) → project_user(id)
- project_issue(milestone_id) → project_milestone(id)
- project_issue(project_id) → project(id)
- project_release_parent_id(project_release_fivetran_id) → project_release(_fivetran_id)
- project_release_asset_source(project_release_fivetran_id) → project_release(_fivetran_id)
- project_release_asset_link(project_release_fivetran_id) → project_release(_fivetran_id)
- project_release_evidence(project_release_fivetran_id) → project_release(_fivetran_id)
- project_release_milestone(project_release_fivetran_id) → project_release(_fivetran_id)
- project_release(author_id) → project_user(id)
- project_release(commit_id) → project_commit(id)
- project_release(project_id) → project(id)
- epic_issue_label(epic_issue_id) → epic_issue(id)
- epic_issue(author_id) → project_user(id)
- epic_issue(group_id) → groups(id)
- groups_epic_board_label(group_id) → groups(id)
- groups_epic_board_label(project_id) → project(id)
- groups_epic_board_label(groups_epic_board_id) → groups_epic_board(id)
- groups_epic_board_list(label_id) → groups_epic_board_label(id)
- groups_epic_board_list(groups_epic_board_id) → groups_epic_board(id)
- groups_epic_board(group_id) → groups(id)
- project_branch_parent_id(project_branch_fivetran_id) → project_branch(_fivetran_id)
- project_branch(commit_id) → project_commit(id)
- project_branch(project_id) → project(id)
- group_member(created_by_id) → project_user(id)
- group_member(groups_id) → groups(id)
- project_merge_request_discussion_note(author_id) → project_user(id)
- project_merge_request_discussion_note(project_merge_request_discussion_id) → project_merge_request_discussion(id)
- project_merge_request_discussion(project_id) → project_merge_request(project_id)
- project_merge_request_discussion(project_merge_request_iid) → project_merge_request(iid)
- project_pipeline(project_id) → project(id)