# Coalesce schema ERD

Table and field reference for the Fivetran Coalesce connector.

## Table & Field Reference

### source_node_hashed_column

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| source_node_id | Unknown | PK, FK |

### source_node_column

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_id | Unknown | PK, FK |
| source_node_id | Unknown | PK, FK |
| applied_column_tests | Json |  |
| column_references | Json |  |
| config | Json |  |
| data_type | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| hash_algorithm | Unknown |  |
| hash_type | Unknown |  |
| hub_hashes | Json |  |
| is_business_key | Unknown |  |
| is_change_tracking | Unknown |  |
| is_surrogate_key | Unknown |  |
| key_column_type | Unknown |  |
| name | Unknown |  |
| nullable | Unknown |  |
| primary_key | Unknown |  |
| sources | Json |  |
| system_column_type | Unknown |  |
| transform | Unknown |  |
| unique_key | Unknown |  |

### source_node

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_id | Unknown | PK, FK |
| database | Unknown |  |
| description | Unknown |  |
| join_condition | Unknown |  |
| location_name | Unknown |  |
| name | Unknown |  |
| node_type | Json |  |
| schema | Unknown |  |
| source_mapping | Json |  |
| table_name | Unknown |  |

### sql_node_hashed_column

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| sql_node_id | Unknown | PK, FK |

### sql_node_column

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_id | Unknown | PK, FK |
| sql_node_id | Unknown | PK, FK |
| applied_column_tests | Json |  |
| column_references | Json |  |
| config | Json |  |
| data_type | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| hash_algorithm | Unknown |  |
| hash_type | Unknown |  |
| hub_hashes | Json |  |
| is_business_key | Unknown |  |
| is_change_tracking | Unknown |  |
| is_surrogate_key | Unknown |  |
| key_column_type | Unknown |  |
| name | Unknown |  |
| nullable | Unknown |  |
| primary_key | Unknown |  |
| sources | Json |  |
| system_column_type | Unknown |  |
| transform | Unknown |  |
| unique_key | Unknown |  |

### sql_node_applied_test

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| environment_id | Unknown | PK, FK |
| sql_node_id | Unknown | PK, FK |
| continue_on_failure | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| run_order | Unknown |  |
| template_string | Unknown |  |

### sql_node

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_id | Unknown | PK, FK |
| config | Json |  |
| database | Unknown |  |
| description | Unknown |  |
| is_multisource | Unknown |  |
| join_condition | Unknown |  |
| location_name | Unknown |  |
| materialization_type | Unknown |  |
| metadata_cte_string | Unknown |  |
| metadata_description | Unknown |  |
| metadata_destination_name | Unknown |  |
| metadata_enabled_column_test_ids | Json |  |
| metadata_mapping | Json |  |
| metadata_materialization_option | Unknown |  |
| name | Unknown |  |
| node_type | Json |  |
| override_sql | Unknown |  |
| schema | Unknown |  |
| source_mapping | Json |  |
| table_name | Unknown |  |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| connection_account | Unknown |  |
| created_at | Unknown |  |
| created_by_first_name | Unknown |  |
| created_by_id | Unknown |  |
| created_by_last_name | Unknown |  |
| current_git_branch | Unknown |  |
| current_git_commit | Unknown |  |
| current_mappings | Json |  |
| currently_running_jobs | Json |  |
| default_storage_mapping | Unknown |  |
| deployed_commit | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| oauth_enabled | Unknown |  |
| project_id | Unknown |  |
| run_time_parameters | Json |  |
| status | Unknown |  |
| tag_background_color | Unknown |  |
| tag_text_color | Unknown |  |
| updated_at | Unknown |  |

### run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| run_environment_id | Unknown | FK |
| canceled | Unknown |  |
| deploy_commit | Unknown |  |
| deploy_commit_message | Unknown |  |
| end_time | Unknown |  |
| environment_id | Unknown |  |
| exclude_nodes_selector | Unknown |  |
| executor | Unknown |  |
| force_ignore_environment_status | Unknown |  |
| history | Unknown |  |
| include_nodes_selector | Unknown |  |
| job_id | Unknown |  |
| nodes_for_refresh | Unknown |  |
| nodes_in_run | Unknown |  |
| parallelism | Unknown |  |
| re_run_id | Unknown |  |
| refresh_description | Unknown |  |
| start_time | Instant |  |
| status | Unknown |  |
| time_parameters | Json |  |
| type | Unknown |  |
| user_credential_snowflake_account | Unknown |  |
| user_credential_snowflake_auth_type | Unknown |  |
| user_credential_snowflake_role | Unknown |  |
| user_credential_snowflake_username | Unknown |  |
| user_credential_snowflake_warehouse | Unknown |  |
| user_id | Unknown |  |
| version | Unknown |  |

### run_query_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| run_id | Unknown | PK, FK |
| run_result_node_id | Unknown | PK, FK |
| end_time | Unknown |  |
| error_detail | Unknown |  |
| error_string | Unknown |  |
| is_running | Unknown |  |
| name | Unknown |  |
| query_id | Unknown |  |
| row_deleted | Unknown |  |
| row_inserted | Unknown |  |
| row_updated | Unknown |  |
| sql | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| success | Unknown |  |
| warehouse | Unknown |  |

### run_result

| Column | Type | Keys |
| --- | --- | --- |
| node_id | Unknown | PK |
| run_id | Unknown | PK, FK |
| end_time | Unknown |  |
| error_detail | Unknown |  |
| error_string | Unknown |  |
| is_running | Unknown |  |
| name | Unknown |  |
| origin | Unknown |  |
| query_id | Unknown |  |
| row_deleted | Unknown |  |
| row_inserted | Unknown |  |
| row_updated | Unknown |  |
| run_state | Unknown |  |
| sql | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| success | Unknown |  |
| warehouse | Unknown |  |

## Relationships

- source_node_hashed_column(id) → source_node_column(id)
- source_node_hashed_column(source_node_id) → source_node_column(source_node_id)
- source_node_hashed_column(environment_id) → source_node_column(environment_id)
- source_node_column(source_node_id) → source_node(id)
- source_node_column(environment_id) → source_node(environment_id)
- source_node(environment_id) → environment(id)
- sql_node_hashed_column(id) → sql_node_column(id)
- sql_node_hashed_column(sql_node_id) → sql_node_column(sql_node_id)
- sql_node_hashed_column(environment_id) → sql_node_column(environment_id)
- sql_node_column(sql_node_id) → sql_node(id)
- sql_node_column(environment_id) → sql_node(environment_id)
- sql_node_applied_test(sql_node_id) → sql_node(id)
- sql_node_applied_test(environment_id) → sql_node(environment_id)
- sql_node(environment_id) → environment(id)
- run(project_id) → environment(project_id)
- run(run_environment_id) → environment(id)
- run_query_result(run_result_node_id) → run_result(node_id)
- run_query_result(run_id) → run_result(run_id)
- run_result(run_id) → run(id)