# Atlassian Compass schema ERD

Table and field reference for the Fivetran Atlassian Compass connector.

## Table & Field Reference

### custom_field_definition_component_type_id

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_definition_component_type_id | Unknown | PK, FK |
| custom_field_definition_id | Unknown | PK, FK |

### custom_field_definition_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_field_definition_id | Unknown | PK, FK |
| value | Unknown |  |

### custom_field_definition

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

### scorecard_component_type

| Column | Type | Keys |
| --- | --- | --- |
| scorecard_component_type | Unknown | PK, FK |
| scorecard_id | Unknown | PK, FK |

### scorecard_criteria

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| scorecard_id | Unknown | PK, FK |
| boolean_comparator | Unknown |  |
| boolean_comparator_value | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| custom_field_definition_** |  |  |

### scorecard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_model_application_type | Unknown |  |
| component_tier_value | Json |  |
| description | Unknown |  |
| failing_lower_bound | Unknown |  |
| failing_upper_bound | Unknown |  |
| importance | Unknown |  |
| is_deactivation_enabled | Unknown |  |
| name | Unknown |  |
| needs_attention_lower_bound | Unknown |  |
| needs_attention_upper_bound | Unknown |  |
| passing_lower_bound | Unknown |  |
| passing_upper_bound | Unknown |  |
| state | Unknown |  |
| url | Unknown |  |
| verified | Unknown |  |

### scorecard_applied_component_criteria_score

| Column | Type | Keys |
| --- | --- | --- |
| criterion_id | Unknown | PK, FK |
| scorecard_applied_component_component_id | Unknown | PK, FK |
| scorecard_applied_component_scorecard_id | Unknown | PK, FK |
| data_source_last_updated | Unknown |  |
| explanation | Unknown |  |
| max_score | Unknown |  |
| score | Unknown |  |
| status | Unknown |  |

### scorecard_maturity_group_criteria_score

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| scorecard_applied_component_component_id | Unknown | PK, FK |
| scorecard_applied_component_scorecard_id | Unknown | PK, FK |
| criterion_id | Unknown | FK |
| data_source_last_updated | Unknown |  |
| explanation | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### scorecard_applied_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK, FK |
| scorecard_id | Unknown | PK, FK |
| maturity_level_display_name | Unknown |  |
| maturity_level_duration_since | Unknown |  |
| maturity_level_id | Unknown |  |
| status_duration_since | Unknown |  |
| status_lower_bound | Unknown |  |
| status_name | Unknown |  |
| status_upper_bound | Unknown |  |
| viewer_permissions_jira_issue_allowed | Unknown |  |
| viewer_permissions_jira_issue_denial_reasons | Json |  |
| viewer_permissions_jira_issue_limit | Unknown |  |
| viewer_permissions_remove_allowed | Unknown |  |
| viewer_permissions_remove_denial_reasons | Json |  |
| viewer_permissions_remove_limit | Unknown |  |
| viewer_permissions_work_item_allowed | Unknown |  |
| viewer_permissions_work_item_denial_reasons | Json |  |
| viewer_permissions_work_item_limit | Unknown |  |

### component_type_field_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_type_id | Unknown | PK, FK |
| boolean_default | Unknown |  |
| boolean_values | Unknown |  |
| default_option | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| options | Unknown |  |
| type | Unknown |  |

### component_type

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

### component_metric_source_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| annotation_content | Unknown |  |
| annotation_created_at | Unknown |  |
| date_time | Unknown |  |
| value | Unknown |  |

### component_metric_source

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| component_id | Unknown | FK |
| derived_from_id | Unknown | FK |
| external_metric_source_id | Unknown |  |
| forge_app_id | Unknown |  |
| id | Unknown |  |
| metric_definition_derived_event_types | Json |  |
| metric_definition_description | Unknown |  |
| metric_definition_format_suffix | Unknown |  |
| metric_definition_id | Unknown |  |
| metric_definition_is_pinned | Unknown |  |
| metric_definition_name | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### catalog_bootstrap

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| source | Unknown |  |
| status | Unknown |  |

### component_event_alert

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| acknowledged_at | Unknown |  |
| alert_id | Unknown |  |
| closed_at | Unknown |  |
| created_at | Unknown |  |
| priority | Unknown |  |
| snoozed_at | Unknown |  |
| status | Unknown |  |

### component_event_build

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| completed_at | Unknown |  |
| pipeline_id | Unknown |  |
| pipeline_name | Unknown |  |
| pipeline_url | Unknown |  |
| started_at | Unknown |  |
| state | Unknown |  |

### component_event_custom

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| icon | Unknown |  |
| id | Unknown |  |

### component_event_deployment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| completed_at | Unknown |  |
| deployment_sequence_number | Unknown |  |
| env_category | Unknown |  |
| env_id | Unknown |  |
| env_name | Unknown |  |
| pipeline_id | Unknown |  |
| pipeline_name | Unknown |  |
| pipeline_url | Unknown |  |
| started_at | Unknown |  |
| state | Unknown |  |

### component_event_flag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| id | Unknown |  |
| status | Unknown |  |

### component_event_incident

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| end_time | Unknown |  |
| id | Unknown |  |
| severity_label | Unknown |  |
| severity_level | Unknown |  |
| start_time | Unknown |  |
| state | Unknown |  |

### component_event_lifecycle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| id | Unknown |  |
| stage | Unknown |  |

### component_event_pull_request

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| id | Unknown |  |
| repo_url | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |

### component_event_push

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| branch_name | Unknown |  |
| id | Unknown |  |

### component_event_vulnerability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| discovery_source | Unknown |  |
| discovery_time | Unknown |  |
| id | Unknown |  |
| remediation_time | Unknown |  |
| score | Unknown |  |
| severity_label | Unknown |  |
| severity_level | Unknown |  |
| start_time | Unknown |  |
| state | Unknown |  |
| vulnerable_target | Unknown |  |

### component_event_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| event_type | Unknown |  |
| external_event_source_id | Unknown |  |
| forge_app_id | Unknown |  |

### component_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| component_id | Unknown | FK |
| description | Unknown |  |
| display_name | Unknown |  |
| event_type | Unknown |  |
| last_updated | Unknown |  |
| update_sequence_number | Unknown |  |
| url | Unknown |  |

### component_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | PK, FK |
| name | Unknown |  |
| object_id | Unknown |  |
| url | Unknown |  |

### component_auto_population_metadata

| Column | Type | Keys |
| --- | --- | --- |
| field_id | Unknown | PK |
| component_id | Unknown | PK, FK |
| source_link | Unknown |  |
| source_name | Unknown |  |
| value | Unknown |  |
| verified | Unknown |  |

### component_label

| Column | Type | Keys |
| --- | --- | --- |
| component_label | Unknown | PK |
| component_id | Unknown | PK, FK |

### component_announcement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | PK, FK |
| description | Unknown |  |
| has_acknowledged | Unknown |  |
| target_date | Unknown |  |
| title | Unknown |  |

### component_relationship

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| component_id | Unknown | PK, FK |
| end_node_id | Unknown | FK |
| start_node_id | Unknown | FK |
| created_at | Unknown |  |
| last_user_modification_at | Unknown |  |
| relationship_type | Unknown |  |

### component_external_alias

| Column | Type | Keys |
| --- | --- | --- |
| external_alias_id | Unknown | PK |
| component_id | Unknown | PK, FK |
| external_source | Unknown |  |
| url | Unknown |  |

### component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| ecosystem_app_id | Unknown |  |
| external_source_url | Unknown |  |
| last_sync_errors | Unknown |  |
| last_sync_status | Unknown |  |
| last_sync_time | Unknown |  |
| last_user_modification_at | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| slug | Unknown |  |
| state | Unknown |  |
| url | Unknown |  |
| viewer_subscribed | Unknown |  |

## Relationships

- custom_field_definition_component_type_id(custom_field_definition_component_type_id) → component_type(id)
- custom_field_definition_component_type_id(custom_field_definition_id) → custom_field_definition(id)
- custom_field_definition_option(custom_field_definition_id) → custom_field_definition(id)
- scorecard_component_type(scorecard_component_type) → component_type(id)
- scorecard_component_type(scorecard_id) → scorecard(id)
- scorecard_criteria(scorecard_id) → scorecard(id)
- scorecard_applied_component_criteria_score(criterion_id) → scorecard_criteria(id)
- scorecard_applied_component_criteria_score(scorecard_applied_component_component_id) → scorecard_applied_component(component_id)
- scorecard_applied_component_criteria_score(scorecard_applied_component_scorecard_id) → scorecard_applied_component(scorecard_id)
- scorecard_maturity_group_criteria_score(criterion_id) → scorecard_criteria(id)
- scorecard_maturity_group_criteria_score(scorecard_applied_component_component_id) → scorecard_applied_component(component_id)
- scorecard_maturity_group_criteria_score(scorecard_applied_component_scorecard_id) → scorecard_applied_component(scorecard_id)
- scorecard_applied_component(component_id) → component(id)
- scorecard_applied_component(scorecard_id) → scorecard(id)
- component_type_field_definition(component_type_id) → component_type(id)
- component_metric_source_value(_fivetran_id) → component_metric_source(_fivetran_id)
- component_metric_source(component_id) → component(id)
- component_metric_source(derived_from_id) → component_event_source(id)
- component_event_alert(_fivetran_id) → component_event(_fivetran_id)
- component_event_build(_fivetran_id) → component_event(_fivetran_id)
- component_event_custom(_fivetran_id) → component_event(_fivetran_id)
- component_event_deployment(_fivetran_id) → component_event(_fivetran_id)
- component_event_flag(_fivetran_id) → component_event(_fivetran_id)
- component_event_incident(_fivetran_id) → component_event(_fivetran_id)
- component_event_lifecycle(_fivetran_id) → component_event(_fivetran_id)
- component_event_pull_request(_fivetran_id) → component_event(_fivetran_id)
- component_event_push(_fivetran_id) → component_event(_fivetran_id)
- component_event_vulnerability(_fivetran_id) → component_event(_fivetran_id)
- component_event_source(_fivetran_id) → component_event(_fivetran_id)
- component_event(component_id) → component(id)
- component_link(component_id) → component(id)
- component_auto_population_metadata(component_id) → component(id)
- component_label(component_id) → component(id)
- component_announcement(component_id) → component(id)
- component_relationship(start_node_id) → component(id)
- component_relationship(end_node_id) → component(id)
- component_relationship(component_id) → component(id)
- component_external_alias(component_id) → component(id)
- component(type_id) → component_type(id)