# Codefresh schema ERD

Table and field reference for the Fivetran Codefresh connector.

## Table & Field Reference

### repos

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| clone_url | Unknown |  |
| context | Unknown |  |
| default_branch | Unknown |  |
| features_create_branch | Unknown |  |
| features_merge_branch | Unknown |  |
| features_pull_request | Unknown |  |
| features_remove_branch | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| open_issues | Unknown |  |
| org | Unknown |  |
| owner_avatar_url | Unknown |  |
| owner_login | Unknown |  |
| permissions_admin | Unknown |  |
| private | Unknown |  |
| provider | Unknown |  |
| pushed_at | Unknown |  |
| ssh_url | Unknown |  |

### trigger

| Column | Type | Keys |
| --- | --- | --- |
| pipeline | Unknown | PK, FK |
| event | Unknown | FK |
| filter_tag | Unknown |  |

### build_system_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| build_id | Unknown | PK, FK |
| kind | Unknown |  |
| message | Unknown |  |
| retriable | Unknown |  |
| step | Unknown |  |

### build_annotation_env

| Column | Type | Keys |
| --- | --- | --- |
| enviroment_type | Unknown | PK |
| build_annotation_id | Unknown | PK, FK |
| build_id | Unknown | PK, FK |

### build_annotation_user

| Column | Type | Keys |
| --- | --- | --- |
| user_name | Unknown | PK |
| build_annotation_id | Unknown | PK, FK |
| build_id | Unknown | PK, FK |

### build_annotation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| build_id | Unknown | PK, FK |
| display | Unknown |  |
| key | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### build_step

| Column | Type | Keys |
| --- | --- | --- |
| steps | Unknown | PK |
| build_id | Unknown | PK, FK |

### build_parent_info_scm_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| build_id | Unknown | PK, FK |
| value | Unknown |  |

### build

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| triggered_by | Unknown | FK |
| account | Unknown |  |
| auto_generated_yaml | Unknown |  |
| branch_name | Unknown |  |
| branch_url | Unknown |  |
| build_strategy | Unknown |  |
| commit_message | Unknown |  |
| commit_url | Unknown |  |
| committer | Unknown |  |
| committer_avatar | Unknown |  |
| created | Unknown |  |
| cron_event_description | Unknown |  |
| cron_event_message | Unknown |  |
| delayed | Unknown |  |
| event | Unknown |  |
| event_label | Unknown |  |
| event_name | Unknown |  |
| exposed_variables_pipeline_trigger_shared | Unknown |  |
| final_workflow_yaml | Unknown |  |
| finished | Unknown |  |
| has_extended_yaml | Unknown |  |
| has_implicit_git_clone_step | Unknown |  |
| initiator | Unknown |  |
| initiator_avatar | Unknown |  |
| keep_p_v_cs_for_pending_approval | Unknown |  |
| pack_id | Unknown |  |
| parent_workflow_info_buil_durl | Unknown |  |
| parent_workflow_info_pipeline_name | Unknown |  |
| parent_workflow_info_trigger_type | Unknown |  |
| parent_workflow_info_workflow_id | Unknown |  |
| pending_approval_concurrency_applied | Unknown |  |
| pending_license | Unknown |  |
| permit_restart_from_failed_step | Unknown |  |
| pipeline_name | Unknown |  |
| pipeline_trigger_id | Unknown |  |
| pipeline_trigger_name | Unknown |  |
| progress | Unknown |  |
| project | Unknown |  |
| provider | Unknown |  |
| repo_name | Unknown |  |
| repo_owner | Unknown |  |
| repo_url | Unknown |  |
| request | Unknown |  |
| revision | Unknown |  |
| runtime_scheduler_config_type | Unknown |  |
| service_id | Unknown |  |
| service_name | Unknown |  |
| started | Unknown |  |
| status | Unknown |  |
| termination_request | Json |  |
| trigger | Unknown |  |
| trigger_type | Unknown |  |
| triggers_count | Unknown |  |
| use_debugger | Unknown |  |
| user_yaml_descriptor | Unknown |  |
| webhook_triggered | Unknown |  |

### build_exposed_variable_ops

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| build_id | Unknown | FK |
| key | Unknown |  |
| type | String |  |
| value | Unknown |  |

### view_type_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| view_type_name | Unknown | PK, FK |
| description | Unknown |  |

### view_type

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |

### view_filter_value

| Column | Type | Keys |
| --- | --- | --- |
| value | Unknown | PK |
| view_filter_id | Unknown | PK, FK |
| view_id | Unknown | PK, FK |

### view_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| view_id | Unknown | PK, FK |
| find_type | Unknown |  |
| selected_value | Unknown |  |

### view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown |  |
| last_updated | Unknown |  |
| name | Unknown |  |
| tags | Json |  |
| time_frame_start | Unknown |  |
| type | Unknown |  |

### context

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| api_version | Unknown |  |
| kind | Unknown |  |
| metadata_default | Unknown |  |
| metadata_name | Unknown |  |
| metadata_system | Unknown |  |
| owner | Unknown |  |
| spec_sharing_policy | Unknown |  |
| spec_type | Unknown |  |
| custom_** |  |  |

### execution_context_assignment

| Column | Type | Keys |
| --- | --- | --- |
| execution_context_id | Unknown | PK |
| pipeline_id | Unknown | PK |
| id | Unknown | FK |
| account | Unknown |  |

### summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| environment_id | Unknown | FK |
| deployments_fail | Unknown |  |
| deployments_pending | Unknown |  |
| deployments_ready | Unknown |  |
| pods_fail | Unknown |  |
| pods_pending | Unknown |  |
| pods_ready | Unknown |  |
| services_fail | Unknown |  |
| services_pending | Unknown |  |
| services_ready | Unknown |  |

### all_existing_trigger_type_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| all_existing_trigger_type_kind | Unknown | PK, FK |
| all_existing_trigger_type_type | Unknown | PK, FK |
| help | Unknown |  |
| image | Unknown |  |
| name | Unknown |  |
| name_label | Unknown |  |
| options_push | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |
| validator | Unknown |  |

### all_existing_trigger_type_filter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| all_existing_trigger_type_kind | Unknown | PK, FK |
| all_existing_trigger_type_type | Unknown | PK, FK |
| help | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| validator | Unknown |  |

### all_existing_trigger_type

| Column | Type | Keys |
| --- | --- | --- |
| kind | Unknown | PK |
| type | Unknown | PK |
| help_url | Unknown |  |
| service_url | Unknown |  |
| uri_regex | Unknown |  |
| uri_template | Unknown |  |

### cluster

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| behind_firewall | Unknown |  |
| cluster_config | Unknown |  |
| helm_3 | Unknown |  |
| namespaces | Json |  |
| provider | Unknown |  |
| provider_agent | Unknown |  |
| selector | Unknown |  |

### project_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| project_id | Unknown | PK, FK |

### project_variable

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_id | Unknown | FK |
| encrypted | Unknown |  |
| key | Unknown |  |
| value | Unknown |  |

### project_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| project_id | Unknown | PK, FK |
| value | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| favorite | Unknown |  |
| image | Unknown |  |
| pipeline_number | Unknown |  |
| project_name | Unknown |  |
| updated_at | Unknown |  |

### runtime_environment_extend

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| runtime_environment_name | Unknown | PK, FK |
| extends | Unknown |  |

### runtime_environment

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| description | Unknown |  |
| docker_daemon_scheduler_default_dind_resources_limits_cpu | Unknown |  |
| docker_daemon_scheduler_default_dind_resources_limits_dind_storage | Unknown |  |
| docker_daemon_scheduler_default_dind_resources_limits_memory | Unknown |  |
| status_healthy | Unknown |  |
| status_last_report_id | Unknown |  |
| status_manual_resolving | Unknown |  |
| status_valid_until | Unknown |  |
| version | Unknown |  |

### registry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| behind_firewall | Unknown |  |
| defaults | Unknown |  |
| deny_composite_domain | Unknown |  |
| domain | Unknown |  |
| fallback_registry | Unknown |  |
| internal | Unknown |  |
| is_primary | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| provider | Unknown |  |
| username | Unknown |  |

### incorrectly_configured_trigger_of_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| context | Unknown |  |
| name | Unknown |  |
| pipeline_name | Unknown |  |
| provider | Unknown |  |
| repo | Unknown |  |

### environment_spec_filter

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| environment_id | Unknown | FK |
| cluster | Unknown |  |
| namespace | Unknown |  |

### environment_spec_endpoint

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| environment_id | Unknown | FK |
| name | Unknown |  |
| url | Unknown |  |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| created_at | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| spec_activities | Json |  |
| spec_type | Unknown |  |
| updated_at | Unknown |  |
| version | Unknown |  |

### agent_runtime

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agent_id | Unknown | PK, FK |
| agent_runtime | Unknown |  |

### agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown |  |
| name | Unknown |  |
| status_health_status | Unknown |  |
| status_reported_at | Unknown |  |
| token_name | Unknown |  |

### composition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| account | Unknown |  |
| created | Unknown |  |
| entry_point | Unknown |  |
| is_advanced | Unknown |  |
| name | Unknown |  |
| updated | Unknown |  |
| v | Unknown |  |
| vars | Json |  |
| yaml_json | Unknown |  |

### rule_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attributes | Unknown | PK |
| rule_id | Unknown | PK, FK |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action | Unknown |  |
| resource | Unknown |  |
| role | Unknown |  |

### pipeline_spec_stage

| Column | Type | Keys |
| --- | --- | --- |
| stage | Unknown | PK |
| pipeline_id | Unknown | PK, FK |

### pipeline_spec_variable

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| pipeline_id | Unknown | FK |
| encrypted | Unknown |  |
| key | Unknown |  |
| value | Unknown |  |

### pipeline_spec_trigger_event

| Column | Type | Keys |
| --- | --- | --- |
| event | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| pipeline_spec_trigger_id | Unknown | PK, FK |

### pipeline_spec_trigger

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| branch_regex | Unknown |  |
| branch_regex_input | Unknown |  |
| comment_regex | Unknown |  |
| context | Unknown |  |
| contexts | Json |  |
| disabled | Unknown |  |
| gerrit_ci_status_labels | Unknown |  |
| last_execution_date | Unknown |  |
| name | Unknown |  |
| provider | Unknown |  |
| pull_request_allow_fork_events | Unknown |  |
| pull_request_target_branch_regex | Unknown |  |
| repo | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| variables | Unknown |  |
| verified | Unknown |  |

### pipeline_spec_step_init_command

| Column | Type | Keys |
| --- | --- | --- |
| command | Unknown | PK |
| pipeline_id | Unknown | PK, FK |

### pipeline_spec_step_update_ltaf_service_command

| Column | Type | Keys |
| --- | --- | --- |
| command | Unknown | PK |
| pipeline_id | Unknown | PK, FK |

### pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| account_id | Unknown |  |
| created_at | Unknown |  |
| deprecate | Json |  |
| kind | Unknown |  |
| label_tag | Json |  |
| last_executed | Unknown |  |
| name | Unknown |  |
| original_yaml_string | Unknown |  |
| revision | Unknown |  |
| short_name | Unknown |  |
| spec_cluster_info_inject_all | Unknown |  |
| spec_context | Json |  |
| spec_external_resources | Json |  |
| spec_permit_restart_from_failed_steps | Unknown |  |
| spec_runtime_environment_cpu | Unknown |  |
| spec_runtime_environment_dind_storage | Unknown |  |
| spec_runtime_environment_memory | Unknown |  |
| spec_runtime_environment_name | Unknown |  |
| spec_step_init_image | Unknown |  |
| spec_step_init_stage | Unknown |  |
| spec_step_init_title | Unknown |  |
| spec_steps | Unknown |  |
| spec_steps_clone_helm_3_platform_git | Unknown |  |
| spec_steps_clone_helm_3_platform_repo | Unknown |  |
| spec_steps_clone_helm_3_platform_revision | Unknown |  |
| spec_steps_clone_helm_3_platform_stage | Unknown |  |
| spec_steps_clone_helm_3_platform_title | Unknown |  |
| spec_steps_clone_helm_3_platform_type | Unknown |  |
| spec_steps_freestyle_argument_image | Unknown |  |
| spec_steps_freestyle_title | Unknown |  |
| spec_steps_freestyle_type | Unknown |  |
| spec_steps_freestyle_working_directory | Unknown |  |
| spec_steps_update_ltaf_service_image | Unknown |  |
| spec_steps_update_ltaf_service_stage | Unknown |  |
| spec_steps_update_ltaf_service_title | Unknown |  |
| spec_steps_update_ltaf_service_working_directory | Unknown |  |
| spec_termination_policy | Json |  |
| updated_at | Unknown |  |
| version | Unknown |  |

### trigger_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account | Unknown |  |
| description | Unknown |  |
| endpoint | Unknown |  |
| help | Unknown |  |
| kind | Unknown |  |
| secret | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| uri | Unknown |  |

### trigger_of_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| context | Unknown | FK |
| name | Unknown |  |
| pipeline_name | Unknown |  |
| provider | Unknown |  |
| repo | Unknown |  |

### team_user_role

| Column | Type | Keys |
| --- | --- | --- |
| user_role | Unknown | PK |
| team_id | Unknown | PK, FK |
| team_user_id | Unknown | PK, FK |

### team_user_account

| Column | Type | Keys |
| --- | --- | --- |
| account | Unknown | PK |
| team_id | Unknown | PK, FK |
| team_user_id | Unknown | PK, FK |

### team_user_email

| Column | Type | Keys |
| --- | --- | --- |
| user_email | Unknown | PK |
| team_id | Unknown | PK, FK |
| team_user_id | Unknown | PK, FK |

### team_user_notification

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| team_user_id | Unknown | PK, FK |
| event | Unknown |  |
| type | Unknown |  |

### team_user_login

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| team_user_id | Unknown | PK, FK |
| idp_id | Unknown |  |
| permission | Json |  |
| personal_git | Unknown |  |
| sso | Unknown |  |
| user_id | Unknown |  |
| user_name | Unknown |  |

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| default_account | Unknown |  |
| git_ops_setting | Json |  |
| has_password | Unknown |  |
| invited_account | Unknown |  |
| last_login_date | Unknown |  |
| notification_email | Unknown |  |
| register_date | Unknown |  |
| setting_allow_admin_to_login | Unknown |  |
| setting_date_format | Unknown |  |
| setting_display_welcome_screen | Unknown |  |
| setting_filter_inaccessible_kubernetes | Unknown |  |
| setting_notify_my_changes | Unknown |  |
| setting_send_weekly_report | Unknown |  |
| setting_theme | Unknown |  |
| setting_time_format | Unknown |  |
| short_profile_username | Unknown |  |
| show_sso_invite_screen | Unknown |  |
| status | Unknown |  |
| user_data_email | Unknown |  |
| user_data_image | Unknown |  |
| user_data_name | Unknown |  |
| user_name | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| tags | Json |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| v | Unknown |  |

### execution_context_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| execution_context_id | Unknown | PK, FK |

### execution_context

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown |  |
| account_default | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- trigger(pipeline) → pipeline(id)
- trigger(event) → trigger_event(uri)
- build_system_event(build_id) → build(id)
- build_annotation_env(build_annotation_id) → build_annotation(id)
- build_annotation_env(build_id) → build_annotation(build_id)
- build_annotation_user(build_annotation_id) → build_annotation(id)
- build_annotation_user(build_id) → build_annotation(build_id)
- build_annotation(build_id) → build(id)
- build_step(build_id) → build(id)
- build_parent_info_scm_metadata(build_id) → build(id)
- build(project_id) → project(id)
- build(triggered_by) → team_user(id)
- build_exposed_variable_ops(build_id) → build(id)
- view_type_field(view_type_name) → view_type(name)
- view_filter_value(view_id) → view_filter(view_id)
- view_filter_value(view_filter_id) → view_filter(id)
- view_filter(view_id) → view(id)
- execution_context_assignment(id) → execution_context(id)
- summary(environment_id) → environment(id)
- all_existing_trigger_type_config(all_existing_trigger_type_type) → all_existing_trigger_type(type)
- all_existing_trigger_type_config(all_existing_trigger_type_kind) → all_existing_trigger_type(kind)
- all_existing_trigger_type_filter(all_existing_trigger_type_type) → all_existing_trigger_type(type)
- all_existing_trigger_type_filter(all_existing_trigger_type_kind) → all_existing_trigger_type(kind)
- project_tag(project_id) → project(id)
- project_variable(project_id) → project(id)
- project_metadata(project_id) → project(id)
- runtime_environment_extend(runtime_environment_name) → runtime_environment(name)
- environment_spec_filter(environment_id) → environment(id)
- environment_spec_endpoint(environment_id) → environment(id)
- agent_runtime(agent_id) → agent(id)
- composition(created_by) → team_user(id)
- composition(updated_by) → team_user(id)
- rule_attribute(rule_id) → rule(id)
- pipeline_spec_stage(pipeline_id) → pipeline(id)
- pipeline_spec_variable(pipeline_id) → pipeline(id)
- pipeline_spec_trigger_event(pipeline_spec_trigger_id) → pipeline_spec_trigger(id)
- pipeline_spec_trigger_event(pipeline_id) → pipeline_spec_trigger(pipeline_id)
- pipeline_spec_trigger(pipeline_id) → pipeline(id)
- pipeline_spec_step_init_command(pipeline_id) → pipeline(id)
- pipeline_spec_step_update_ltaf_service_command(pipeline_id) → pipeline(id)
- pipeline(project_id) → project(id)
- trigger_of_pipeline(id) → build(pipeline_trigger_id)
- trigger_of_pipeline(context) → pipeline_spec_trigger(context)
- team_user_role(team_id) → team_user(team_id)
- team_user_role(team_user_id) → team_user(id)
- team_user_account(team_id) → team_user(team_id)
- team_user_account(team_user_id) → team_user(id)
- team_user_email(team_id) → team_user(team_id)
- team_user_email(team_user_id) → team_user(id)
- team_user_notification(team_id) → team_user(team_id)
- team_user_notification(team_user_id) → team_user(id)
- team_user_login(team_id) → team_user(team_id)
- team_user_login(team_user_id) → team_user(id)
- team_user(team_id) → team(id)
- execution_context_tag(execution_context_id) → execution_context(id)