# Validio schema ERD

Table and field reference for the Fivetran Validio connector.

## Table & Field Reference

### namespace_user

| Column | Type | Keys |
| --- | --- | --- |
| namespace_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| role | Unknown |  |

### namespace_team

| Column | Type | Keys |
| --- | --- | --- |
| namespace_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| role | Unknown |  |

### namespace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar | Unknown |  |
| avatar_thumbnail | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### validator_incident

| Column | Type | Keys |
| --- | --- | --- |
| incident_id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |
| validator_id | Unknown | PK, FK |

### validator_segment

| Column | Type | Keys |
| --- | --- | --- |
| segment_id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |
| validator_id | Unknown | PK, FK |

### validator_tag

| Column | Type | Keys |
| --- | --- | --- |
| source_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |
| validator_id | Unknown | PK, FK |

### validator

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| source_id | Unknown | PK, FK |
| filter_id | Unknown | FK |
| namespace_id | Unknown | FK |
| owner_id | Unknown | FK |
| reference_filter_id | Unknown | FK |
| reference_window_id | Unknown | FK |
| segmentation_id | Unknown | FK |
| window_id | Unknown | FK |
| config_initialize_with_backfill | Unknown |  |
| config_metadata_enabled | Unknown |  |
| config_metric | Unknown |  |
| config_minimum_reference_data_point | Unknown |  |
| config_minimum_relative_difference_percent | Unknown |  |
| config_mininum_absolute_difference | Unknown |  |
| config_query | Unknown |  |
| config_reference_source_field | Unknown |  |
| config_sensitivity | Unknown |  |
| config_source_field | Unknown |  |
| config_source_field_minuend | Unknown |  |
| config_source_field_subtrahend | Unknown |  |
| config_source_fields | Json |  |
| config_threshold_adaption_rate | Unknown |  |
| config_threshold_decision_bounds_type | Unknown |  |
| config_threshold_difference_type | Unknown |  |
| config_threshold_number_of_window | Unknown |  |
| config_threshold_operator | Unknown |  |
| config_threshold_sensitivity | Unknown |  |
| config_threshold_value | Unknown |  |
| created_at | Unknown |  |
| data_quality | Unknown |  |
| data_quality_diff | Unknown |  |
| data_quality_incident_count | Unknown |  |
| data_quality_total_count | Unknown |  |
| description | Unknown |  |
| metric_value_format | Unknown |  |
| name | Unknown |  |
| progress_percentage | Unknown |  |
| progress_processed | Unknown |  |
| progress_total | Unknown |  |
| reference_source_config_filter | Unknown |  |
| reference_source_config_history | Unknown |  |
| reference_source_config_offset | Unknown |  |
| resource_name | Unknown |  |
| state | Unknown |  |
| state_updated_at | Unknown |  |
| stats_last_artifact_at | Unknown |  |
| stats_last_incident_at | Unknown |  |
| updated_at | Unknown |  |

### incident

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| backfill_mode | Unknown |  |
| created_at | Unknown |  |
| deviation | Unknown |  |
| end_time | Unknown |  |
| lower_bound | Unknown |  |
| severity | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| upper_bound | Unknown |  |
| value | Unknown |  |

### lineage_graph_edge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| source_catalog_asset_id | Unknown | PK, FK |
| downstream_field | Unknown |  |
| sql_query | Unknown |  |
| upstream_field | Unknown |  |

### lineage_graph

| Column | Type | Keys |
| --- | --- | --- |
| source_catalog_asset_id | Unknown | PK, FK |
| total_asset_count | Unknown |  |
| total_edge_count | Unknown |  |
| total_source_count | Unknown |  |

### validator_metric

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| segment_id | Unknown | FK |
| validator_id | Unknown | FK |
| bound | Unknown |  |
| decision_bounds_type | Unknown |  |
| end_time | Unknown |  |
| is_burn_in | Unknown |  |
| is_incident | Unknown |  |
| lower_bound | Unknown |  |
| operator | Unknown |  |
| severity | Unknown |  |
| start_time | Unknown |  |
| upper_bound | Unknown |  |
| value | Unknown |  |

### incident_group_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_group_id | Unknown | PK, FK |
| author_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### incident_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| source_id | Unknown | FK |
| validator_id | Unknown | FK |
| comment_count | Unknown |  |
| first_seen_at | Unknown |  |
| last_seen_at | Unknown |  |
| mute_until | Unknown |  |
| priority | Unknown |  |
| severity_stat_high_count | Unknown |  |
| severity_stat_low_count | Unknown |  |
| severity_stat_medium_count | Unknown |  |
| severity_stat_total_count | Unknown |  |
| status | Unknown |  |

### notification_rule_owner_condition

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| notification_rule_id | Unknown | PK, FK |
| id | Unknown | FK |

### notification_rule_segment_condition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| notification_rule_id | Unknown | PK, FK |
| config_segment | Json |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### notification_rule_source_condition

| Column | Type | Keys |
| --- | --- | --- |
| source_id | Unknown | PK |
| notification_rule_id | Unknown | PK, FK |
| id | Unknown | FK |

### notification_rule_tag_condition

| Column | Type | Keys |
| --- | --- | --- |
| notification_rule_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### notification_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| channel_id | Unknown | FK |
| namespace_id | Unknown | FK |
| config_owner_condition_created_at | Unknown |  |
| config_owner_condition_id | Unknown |  |
| config_owner_condition_updated_at | Unknown |  |
| config_severity_condition | Json |  |
| config_severity_condition_created_at | Unknown |  |
| config_severity_condition_id | Unknown |  |
| config_severity_condition_updated_at | Unknown |  |
| config_source_condition_created_at | Unknown |  |
| config_source_condition_id | Unknown |  |
| config_source_condition_updated_at | Unknown |  |
| config_tag_condition_created_at | Unknown |  |
| config_tag_condition_id | Unknown |  |
| config_tag_condition_updated_at | Unknown |  |
| config_type_condition | Json |  |
| config_type_condition_created_at | Unknown |  |
| config_type_condition_id | Unknown |  |
| config_type_condition_updated_at | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| resource_name | Unknown |  |
| updated_at | Unknown |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| segmentation_id | Unknown | PK, FK |
| data_quality | Unknown |  |
| data_quality_diff | Unknown |  |
| data_quality_incident_count | Unknown |  |
| data_quality_total_count | Unknown |  |
| field | Json |  |

### filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| namespace_id | Unknown | FK |
| config_field | Unknown |  |
| config_operator | Unknown |  |
| config_query | Unknown |  |
| config_value | Unknown |  |
| config_values | Json |  |
| created_at | Unknown |  |
| name | Unknown |  |
| resource_name | Unknown |  |
| updated_at | Unknown |  |

### window

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| namespace_id | Unknown | FK |
| config_batch_size | Unknown |  |
| config_batch_timeout_secs | Unknown |  |
| config_segment_retention_period_days | Unknown |  |
| config_segmented_batching | Unknown |  |
| config_time_unit | Unknown |  |
| config_window_size | Unknown |  |
| config_window_timout_disabled | Unknown |  |
| created_at | Unknown |  |
| data_time_field | Unknown |  |
| name | Unknown |  |
| resource_name | Unknown |  |
| updated_at | Unknown |  |

### channel_notification_rule

| Column | Type | Keys |
| --- | --- | --- |
| channel_id | Unknown | PK, FK |
| notification_rule_id | Unknown | PK, FK |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| namespace_id | Unknown | FK |
| config_application_link_url | Unknown |  |
| config_auth_address | Unknown |  |
| config_auth_encryption | Unknown |  |
| config_auth_port | Unknown |  |
| config_auth_username | Unknown |  |
| config_interactive_message_enabled | Unknown |  |
| config_microsoft_teams_channel_id | Unknown |  |
| config_recipient_address | Json |  |
| config_sender_address | Unknown |  |
| config_slack_channel_id | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| resource_name | Unknown |  |
| updated_at | Unknown |  |

### source_catalog_asset_description

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| source_catalog_asset_id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |
| description | Unknown |  |
| origin | Unknown |  |

### source_catalog_asset_tag

| Column | Type | Keys |
| --- | --- | --- |
| source_catalog_asset_id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### source_catalog_asset_external_tag

| Column | Type | Keys |
| --- | --- | --- |
| source_catalog_asset_id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### source_catalog_asset_joined_table

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |

### source_catalog_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| source_id | Unknown | PK, FK |
| asset_type | Unknown |  |
| config_bucket | Unknown |  |
| config_catalog | Unknown |  |
| config_dashboard_id | Unknown |  |
| config_database | Unknown |  |
| config_dataset | Unknown |  |
| config_explore_id | Unknown |  |
| config_folder | Unknown |  |
| config_prefix | Unknown |  |
| config_project | Unknown |  |
| config_schema | Unknown |  |
| config_stream_name | Unknown |  |
| config_subscription_id | Unknown |  |
| config_table | Unknown |  |
| config_tile_id | Unknown |  |
| config_title | Unknown |  |
| config_topic | Unknown |  |
| config_workbook_id | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| field_count | Unknown |  |
| is_dbt_model | Unknown |  |
| name | Unknown |  |
| query_user | Json |  |
| stats_number_of_reads | Unknown |  |
| stats_number_of_writes | Unknown |  |
| stats_utilization | Unknown |  |
| updated_at | Unknown |  |

### source_window

| Column | Type | Keys |
| --- | --- | --- |
| source_id | Unknown | PK, FK |
| window_id | Unknown | PK, FK |

### source_tag

| Column | Type | Keys |
| --- | --- | --- |
| source_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### source_filter

| Column | Type | Keys |
| --- | --- | --- |
| filter_id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |

### source_segmentation

| Column | Type | Keys |
| --- | --- | --- |
| segmentation_id | Unknown | PK, FK |
| source_id | Unknown | PK, FK |

### source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credential_id | Unknown | FK |
| namespace_id | Unknown | FK |
| owner_id | Unknown | FK |
| config_bucket | Unknown |  |
| config_catalog | Unknown |  |
| config_csv_delimiter | Unknown |  |
| config_csv_null_marker | Unknown |  |
| config_cursor_field | Unknown |  |
| config_database | Unknown |  |
| config_dataset | Unknown |  |
| config_file_format | Unknown |  |
| config_file_pattern | Unknown |  |
| config_folder | Unknown |  |
| config_http_path | Unknown |  |
| config_job_name | Unknown |  |
| config_look_back_day | Unknown |  |
| config_message_format | Unknown |  |
| config_message_format_schema | Unknown |  |
| config_prefix | Unknown |  |
| config_project | Unknown |  |
| config_project_name | Unknown |  |
| config_region | Unknown |  |
| config_role | Unknown |  |
| config_schedule | Unknown |  |
| config_schema | Unknown |  |
| config_stream_name | Unknown |  |
| config_subscription_id | Unknown |  |
| config_table | Unknown |  |
| config_topic | Unknown |  |
| config_warehouse | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| jtd_schema_additional_property | Unknown |  |
| jtd_schema_nullable | Unknown |  |
| jtd_schema_optional_property | Json |  |
| name | Unknown |  |
| resource_name | Unknown |  |
| state | Unknown |  |
| state_updated_at | Unknown |  |
| updated_at | Unknown |  |

### segmentation_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| segmentation_id | Unknown | PK, FK |
| field | Unknown |  |

### segmentation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| filter_id | Unknown | FK |
| namespace_id | Unknown | FK |
| source_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| resource_name | Unknown |  |
| updated_at | Unknown |  |

### credential

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| namespace_id | Unknown | FK |
| config_account | Unknown |  |
| config_account_id | Unknown |  |
| config_api_base_url | Unknown |  |
| config_application_link_url | Unknown |  |
| config_auth_client_id | Unknown |  |
| config_auth_tenant_id | Unknown |  |
| config_auth_user | Unknown |  |
| config_backend_type | Unknown |  |
| config_base_url | Unknown |  |
| config_boot_strap_server | Unknown |  |
| config_ca_certificate | Unknown |  |
| config_client_id | Unknown |  |
| config_database | Unknown |  |
| config_default_database | Unknown |  |
| config_host | Unknown |  |
| config_http_path | Unknown |  |
| config_port | Unknown |  |
| config_protocol | Unknown |  |
| config_query_result_location | Unknown |  |
| config_region | Unknown |  |
| config_role | Unknown |  |
| config_secret_id | Unknown |  |
| config_site | Unknown |  |
| config_token_name | Unknown |  |
| config_user | Unknown |  |
| config_username | Unknown |  |
| config_warehouse | Unknown |  |
| created_at | Unknown |  |
| enable_catalog | Unknown |  |
| name | Unknown |  |
| resource_name | Unknown |  |
| updated_at | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar | Unknown |  |
| avatar_thumbnail | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### user_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### user_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| idp_config_cert | Unknown |  |
| idp_config_entity_id | Unknown |  |
| idp_config_entry_point | Unknown |  |
| idp_created_at | Unknown |  |
| idp_disabled | Unknown |  |
| idp_id | Unknown |  |
| idp_name | Unknown |  |
| idp_resource_name | Unknown |  |
| idp_updated_at | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar | Unknown |  |
| avatar_thumbnail | Unknown |  |
| created_at | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| full_name | Unknown |  |
| global_role | Unknown |  |
| last_login_at | Unknown |  |
| login_type | Unknown |  |
| resource_name | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| key | Unknown |  |
| origin | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

## Relationships

- namespace_user(user_id) → users(id)
- namespace_user(namespace_id) → namespace(id)
- namespace_team(team_id) → team(id)
- namespace_team(namespace_id) → namespace(id)
- validator_incident(incident_id) → incident(id)
- validator_incident(source_id) → validator(source_id)
- validator_incident(validator_id) → validator(id)
- validator_segment(segment_id) → segment(id)
- validator_segment(source_id) → validator(source_id)
- validator_segment(validator_id) → validator(id)
- validator_tag(tag_id) → tags(id)
- validator_tag(source_id) → validator(source_id)
- validator_tag(validator_id) → validator(id)
- validator(segmentation_id) → segmentation(id)
- validator(reference_window_id) → window(id)
- validator(filter_id) → filter(id)
- validator(owner_id) → users(id)
- validator(namespace_id) → namespace(id)
- validator(reference_filter_id) → filter(id)
- validator(window_id) → window(id)
- validator(source_id) → source(id)
- lineage_graph_edge(source_catalog_asset_id) → lineage_graph(source_catalog_asset_id)
- lineage_graph(source_catalog_asset_id) → source_catalog_asset(id)
- validator_metric(segment_id) → validator_segment(segment_id)
- validator_metric(validator_id) → validator_segment(validator_id)
- incident_group_comment(author_id) → users(id)
- incident_group_comment(incident_group_id) → incident_group(id)
- incident_group(owner_id) → users(id)
- incident_group(source_id) → source(id)
- incident_group(validator_id) → validator(id)
- notification_rule_owner_condition(id) → users(id)
- notification_rule_owner_condition(notification_rule_id) → notification_rule(id)
- notification_rule_segment_condition(notification_rule_id) → notification_rule(id)
- notification_rule_source_condition(id) → source(id)
- notification_rule_source_condition(notification_rule_id) → notification_rule(id)
- notification_rule_tag_condition(tag_id) → tags(id)
- notification_rule_tag_condition(notification_rule_id) → notification_rule(id)
- notification_rule(namespace_id) → namespace(id)
- notification_rule(channel_id) → channel(id)
- segment(segmentation_id) → segmentation(id)
- filter(namespace_id) → namespace(id)
- window(namespace_id) → namespace(id)
- channel_notification_rule(notification_rule_id) → notification_rule(id)
- channel_notification_rule(channel_id) → channel(id)
- channel(namespace_id) → namespace(id)
- source_catalog_asset_description(source_catalog_asset_id) → source_catalog_asset(id)
- source_catalog_asset_description(source_id) → source_catalog_asset(source_id)
- source_catalog_asset_tag(tag_id) → tags(id)
- source_catalog_asset_tag(source_catalog_asset_id) → source_catalog_asset(id)
- source_catalog_asset_tag(source_id) → source_catalog_asset(source_id)
- source_catalog_asset_external_tag(tag_id) → tags(id)
- source_catalog_asset_external_tag(source_catalog_asset_id) → source_catalog_asset(id)
- source_catalog_asset_external_tag(source_id) → source_catalog_asset(source_id)
- source_catalog_asset_joined_table(id) → source_catalog_asset(id)
- source_catalog_asset_joined_table(source_id) → source_catalog_asset(source_id)
- source_catalog_asset(source_id) → source(id)
- source_window(window_id) → window(id)
- source_window(source_id) → source(id)
- source_tag(tag_id) → tags(id)
- source_tag(source_id) → source(id)
- source_filter(filter_id) → filter(id)
- source_filter(source_id) → source(id)
- source_segmentation(segmentation_id) → segmentation(id)
- source_segmentation(source_id) → source(id)
- source(credential_id) → credential(id)
- source(owner_id) → users(id)
- source(namespace_id) → namespace(id)
- segmentation_field(segmentation_id) → segmentation(id)
- segmentation(namespace_id) → namespace(id)
- segmentation(source_id) → source(id)
- segmentation(filter_id) → filter(id)
- credential(namespace_id) → namespace(id)
- user_team(team_id) → team(id)
- user_team(user_id) → users(id)
- user_identity(user_id) → users(id)