Fivetran documentation

Search the docs

/

Atlassian Compass

Explore the interactive ERD

Table & Field Reference

custom_field_definition_component_type_id

Column	Type	Keys
`custom_field_definition_component_type_id`	Unknown	PKFK
`custom_field_definition_id`	Unknown	PKFK

custom_field_definition_option

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

scorecard_criteria

Column	Type	Keys
`id`	Unknown	PK
`scorecard_id`	Unknown	PKFK
`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	PKFK
`scorecard_applied_component_component_id`	Unknown	PKFK
`scorecard_applied_component_scorecard_id`	Unknown	PKFK
`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	PKFK
`scorecard_applied_component_scorecard_id`	Unknown	PKFK
`criterion_id`	Unknown	FK
`data_source_last_updated`	Unknown
`explanation`	Unknown
`name`	Unknown
`status`	Unknown

scorecard_applied_component

Column	Type	Keys
`component_id`	Unknown	PKFK
`scorecard_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`icon`	Unknown
`id`	Unknown

component_event_deployment

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`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	PKFK
`id`	Unknown
`status`	Unknown

component_event_incident

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`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	PKFK
`id`	Unknown
`stage`	Unknown

component_event_pull_request

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`id`	Unknown
`repo_url`	Unknown
`status`	Unknown
`url`	Unknown

component_event_push

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`branch_name`	Unknown
`id`	Unknown

component_event_vulnerability

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`name`	Unknown
`object_id`	Unknown
`url`	Unknown

component_auto_population_metadata

Column	Type	Keys
`field_id`	Unknown	PK
`component_id`	Unknown	PKFK
`source_link`	Unknown
`source_name`	Unknown
`value`	Unknown
`verified`	Unknown

component_label

Column	Type	Keys
`component_label`	Unknown	PK
`component_id`	Unknown	PKFK

component_announcement

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	PKFK
`description`	Unknown
`has_acknowledged`	Unknown
`target_date`	Unknown
`title`	Unknown

component_relationship

Column	Type	Keys
`index`	Unknown	PK
`component_id`	Unknown	PKFK
`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	PKFK
`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