GitLab

Explore the interactive ERD

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	PKFK
`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	PKFK

project_compliance_framework

Column	Type	Keys
`compliance_framework`	String	PK
`project_id`	String	PKFK

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	PKFK
`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	PKFK

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	PKFK
`project_id`	String	PKFK

project_commit

Column	Type	Keys
`id`	String	PK
`project_id`	String	PKFK
`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	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK

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	PKFK
`provider`	String

project_user

Column	Type	Keys
`id`	String	PK
`project_id`	String	PKFK
`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	PKFK
`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	PKFK

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	PKFK

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	PKFK
`external`	String
`link_type`	String
`name`	String
`url`	String

project_release_evidence

Column	Type	Keys
`_fivetran_id`	String	PK
`project_release_fivetran_id`	Unknown	PKFK
`collected_at`	String
`filepath`	String
`sha`	String

project_release_milestone

Column	Type	Keys
`id`	String	PK
`project_release_fivetran_id`	Unknown	PKFK
`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	PKFK
`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	PKFK

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	PKFK
`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	PKFK
`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	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`project_merge_request_iid`	Long	PKFK
`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