# Mode schema ERD

Table and field reference for the Fivetran Mode connector.

## Table & Field Reference

### report_collection_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_collection_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| form_fields | Json |  |
| is_latest_report_run | Unknown |  |
| is_latest_successful_report_run | Unknown |  |
| parameters | Json |  |
| purge_completed_at | Unknown |  |
| purge_started_at | Unknown |  |
| python_state | Unknown |  |
| report_has_failures_since_last_success | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_access_level | Unknown |  |
| description | Unknown |  |
| free_default | Unknown |  |
| name | Unknown |  |
| restricted | Unknown |  |
| space_type | Unknown |  |
| state | Unknown |  |
| token | Unknown |  |
| viewable | Unknown |  |
| viewed | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| managed | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### data_source_custom_attribute

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

### data_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| adapter | Unknown |  |
| adapter_version | Unknown |  |
| asleep | Unknown |  |
| bridged | Unknown |  |
| created_at | Unknown |  |
| database | Unknown |  |
| default_access_level | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| has_expensive_schema_updates | Unknown |  |
| host | Unknown |  |
| ldap | Unknown |  |
| name | Unknown |  |
| organization_plan_code | Unknown |  |
| organization_token | Unknown |  |
| port | Unknown |  |
| provider | Unknown |  |
| public | Unknown |  |
| queryable | Unknown |  |
| soft_deleted | Unknown |  |
| ssl | Unknown |  |
| ssl_trusted_cert | Unknown |  |
| token | Unknown |  |
| updated_at | Unknown |  |
| username | Unknown |  |
| vendor | Unknown |  |
| warehouse | Unknown |  |

### dataset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| data_source_id | Unknown | FK |
| archived | Unknown |  |
| color_mapping | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| drill_anywhere_enabled | Unknown |  |
| drilldowns_enabled | Unknown |  |
| edited_at | Unknown |  |
| expected_runtime | Unknown |  |
| flamingo_signature | Unknown |  |
| full_width | Unknown |  |
| github_link | Unknown |  |
| imported_datasets | Unknown |  |
| is_embedded | Unknown |  |
| is_signed | Unknown |  |
| last_run_at | Unknown |  |
| last_saved_at | Unknown |  |
| last_successful_run_token | Unknown |  |
| last_successful_sync_at | Unknown |  |
| last_successfully_run_at | Unknown |  |
| layout | Unknown |  |
| manual_run_disabled | Unknown |  |
| name | Unknown |  |
| public | Unknown |  |
| published_at | Unknown |  |
| query_preview | Unknown |  |
| run_privately | Unknown |  |
| shared | Unknown |  |
| space_token | Unknown |  |
| theme_id | Unknown |  |
| token | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| view_count | Unknown |  |
| web_preview_image | Unknown |  |

### report_data_source_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_using_data_source_id | Unknown | FK |
| created_at | Unknown |  |
| hour | Unknown |  |
| last_run_at | Unknown |  |
| last_scheduled_run | Unknown |  |
| last_succeeded_at | Unknown |  |
| minute | Unknown |  |
| name | Unknown |  |
| next_scheduled_run | Unknown |  |
| parameters | Json |  |
| retry_state | Unknown |  |
| subscribed | Unknown |  |
| time_zone | Unknown |  |
| timeout | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### report_collection_query

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_source_id | Unknown | FK |
| report_collection_id | Unknown | FK |
| created_at | Unknown |  |
| dbt_metric_id | Unknown |  |
| dbt_metric_token | Unknown |  |
| explorations_count | Unknown |  |
| last_run_id | Unknown |  |
| mapping_id | Unknown |  |
| name | Unknown |  |
| raw_query | Unknown |  |
| token | Unknown |  |
| updated_at | Unknown |  |

### collection_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| collection_id | Unknown | PK, FK |
| email | Unknown |  |
| member_token | Unknown |  |
| token | Unknown |  |
| type | Unknown |  |

### account_avatar

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

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| admin_data_source_connections_only | Unknown |  |
| authorized_domains | Json |  |
| created_at | Unknown |  |
| dataset_size_limit_mb | Unknown |  |
| is_user | Unknown |  |
| membership_type | Unknown |  |
| name | Unknown |  |
| payment_method_confirmed | Unknown |  |
| plan_code | Unknown |  |
| private_definition_limit | Unknown |  |
| query_run_size_limit_mb | Unknown |  |
| token | Unknown |  |
| trial_state | Unknown |  |
| username | Unknown |  |

### report_collection_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_collection_id | Unknown | FK |
| created_at | Unknown |  |
| hour | Unknown |  |
| last_run_at | Unknown |  |
| last_scheduled_run | Unknown |  |
| last_succeeded_at | Unknown |  |
| minute | Unknown |  |
| name | Unknown |  |
| next_scheduled_run | Unknown |  |
| parameters | Json |  |
| retry_state | Unknown |  |
| subscribed | Unknown |  |
| time_zone | Unknown |  |
| timeout | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### dataset_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dataset_id | Unknown | FK |
| created_at | Unknown |  |
| hour | Unknown |  |
| last_run_at | Unknown |  |
| last_scheduled_run | Unknown |  |
| last_succeeded_at | Unknown |  |
| minute | Unknown |  |
| name | Unknown |  |
| next_scheduled_run | Unknown |  |
| parameters | Json |  |
| retry_state | Unknown |  |
| subscribed | Unknown |  |
| time_zone | Unknown |  |
| timeout | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### report_using_data_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| data_source_id | Unknown | FK |
| account_username | Unknown |  |
| archived | Unknown |  |
| color_mapping | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| drill_anywhere_enabled | Unknown |  |
| drilldowns_enabled | Unknown |  |
| edited_at | Unknown |  |
| expected_runtime | Unknown |  |
| full_width | Unknown |  |
| github_link | Unknown |  |
| imported_dataset | Unknown |  |
| is_embedded | Unknown |  |
| is_signed | Unknown |  |
| last_run_at | Unknown |  |
| last_saved_at | Unknown |  |
| last_successful_run_token | Unknown |  |
| last_successful_sync_at | Unknown |  |
| last_successfully_run_at | Unknown |  |
| layout | Unknown |  |
| manual_run_disabled | Unknown |  |
| name | Unknown |  |
| public | Unknown |  |
| published_at | Unknown |  |
| query_preview | Unknown |  |
| run_privately | Unknown |  |
| shared | Unknown |  |
| space_token | Unknown |  |
| theme_id | Unknown |  |
| token | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| view_count | Unknown |  |
| web_preview_image | Unknown |  |

### definition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_source_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| github_link | Unknown |  |
| last_saved_at | Unknown |  |
| last_successful_sync_at | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |
| token | Unknown |  |
| updated_at | Unknown |  |

### report_collection_query_chart

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_collection_id | Unknown | FK |
| report_collection_query_id | Unknown | FK |
| color_palette_token | Unknown |  |
| created_at | Unknown |  |
| switch_view_token | Unknown |  |
| updated_at | Unknown |  |
| view | Json |  |
| view_vegas | Json |  |
| view_version | Unknown |  |

### report_data_source_query_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_source_id | Unknown | FK |
| query_token | Unknown | FK |
| report_data_source_run_id | Unknown | FK |
| report_using_data_source_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| dbt_metric_id | Unknown |  |
| dbt_metric_token | Unknown |  |
| error_code | Unknown |  |
| error_message | Unknown |  |
| error_type | Unknown |  |
| help_url | Unknown |  |
| limits | Unknown |  |
| max_result_bytes | Unknown |  |
| parameters | Json |  |
| raw_source | Unknown |  |
| rendered_source | Unknown |  |
| state | Unknown |  |
| statement_annotation | Unknown |  |
| token | Unknown |  |

### report_data_source_query

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_source_id | Unknown | FK |
| report_using_data_source_id | Unknown | FK |
| created_at | Unknown |  |
| dbt_metric_id | Unknown |  |
| dbt_metric_token | Unknown |  |
| explorations_count | Unknown |  |
| last_run_id | Unknown |  |
| mapping_id | Unknown |  |
| name | Unknown |  |
| raw_query | Unknown |  |
| token | Unknown |  |
| updated_at | Unknown |  |

### report_data_source_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_using_data_source_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| form_fields | Json |  |
| is_latest_report_run | Unknown |  |
| is_latest_successful_report_run | Unknown |  |
| parameters | Json |  |
| purge_completed_at | Unknown |  |
| purge_started_at | Unknown |  |
| python_state | Unknown |  |
| report_has_failures_since_last_success | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### group_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| member_id | Unknown | FK |

### workspace_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activated_at | Unknown |  |
| admin | Unknown |  |
| invited | Unknown |  |
| managed_by_scim | Unknown |  |
| state | Unknown |  |
| username | Unknown |  |

### dataset_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dataset_id | Unknown | FK |
| created_at | Unknown |  |
| form_fields | Json |  |
| is_latest_report_run | Unknown |  |
| is_latest_successful_report_run | Unknown |  |
| parameters | Json |  |
| purge_completed_at | Unknown |  |
| purge_started_at | Unknown |  |
| python_state | Unknown |  |
| report_has_failures_since_last_success | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### report_data_source_query_chart

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_data_source_query_id | Unknown | FK |
| report_using_data_source_id | Unknown | FK |
| color_palette_token | Unknown |  |
| created_at | Unknown |  |
| switch_view_token | Unknown |  |
| updated_at | Unknown |  |
| view | Json |  |
| view_vegas | Json |  |
| view_version | Unknown |  |

### report_collection_query_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_source_id | Unknown | FK |
| query_token | Unknown | FK |
| report_collection_id | Unknown | FK |
| report_collection_run_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| dbt_metric_id | Unknown |  |
| dbt_metric_token | Unknown |  |
| error_code | Unknown |  |
| error_message | Unknown |  |
| error_type | Unknown |  |
| help_url | Unknown |  |
| limits | Unknown |  |
| max_result_bytes | Unknown |  |
| parameters | Json |  |
| raw_source | Unknown |  |
| rendered_source | Unknown |  |
| state | Unknown |  |
| statement_annotation | Unknown |  |
| token | Unknown |  |

### report_collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| collection_id | Unknown | FK |
| account_username | Unknown |  |
| archived | Unknown |  |
| color_mapping | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| drill_anywhere_enabled | Unknown |  |
| drilldowns_enabled | Unknown |  |
| edited_at | Unknown |  |
| expected_runtime | Unknown |  |
| full_width | Unknown |  |
| github_link | Unknown |  |
| imported_dataset | Unknown |  |
| is_embedded | Unknown |  |
| is_signed | Unknown |  |
| last_run_at | Unknown |  |
| last_saved_at | Unknown |  |
| last_successful_run_token | Unknown |  |
| last_successful_sync_at | Unknown |  |
| last_successfully_run_at | Unknown |  |
| layout | Unknown |  |
| manual_run_disabled | Unknown |  |
| name | Unknown |  |
| public | Unknown |  |
| published_at | Unknown |  |
| query_preview | Unknown |  |
| run_privately | Unknown |  |
| shared | Unknown |  |
| space_token | Unknown |  |
| theme_id | Unknown |  |
| token | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| view_count | Unknown |  |
| web_preview_image | Unknown |  |

## Relationships

- report_collection_run(report_collection_id) → report_collection(id)
- data_source_custom_attribute(data_source_id) → data_source(id)
- data_source(account_id) → account(id)
- dataset(account_id) → account(id)
- dataset(data_source_id) → data_source(id)
- report_data_source_schedule(report_using_data_source_id) → report_using_data_source(id)
- report_collection_query(data_source_id) → data_source(id)
- report_collection_query(report_collection_id) → report_collection(id)
- collection_membership(collection_id) → collection(id)
- account_avatar(account_id) → account(id)
- report_collection_schedule(report_collection_id) → report_collection(id)
- dataset_schedule(dataset_id) → dataset(id)
- report_using_data_source(account_id) → account(id)
- report_using_data_source(data_source_id) → data_source(id)
- definition(data_source_id) → data_source(id)
- report_collection_query_chart(report_collection_id) → report_collection(id)
- report_collection_query_chart(report_collection_query_id) → report_collection_query(id)
- report_data_source_query_run(query_token) → report_data_source_query(token)
- report_data_source_query_run(data_source_id) → data_source(id)
- report_data_source_query_run(report_using_data_source_id) → report_using_data_source(id)
- report_data_source_query_run(report_data_source_run_id) → report_data_source_run(id)
- report_data_source_query(data_source_id) → data_source(id)
- report_data_source_query(report_using_data_source_id) → report_using_data_source(id)
- report_data_source_run(report_using_data_source_id) → report_using_data_source(id)
- group_membership(member_id) → workspace_membership(id)
- group_membership(group_id) → groups(id)
- dataset_run(dataset_id) → dataset(id)
- report_data_source_query_chart(report_using_data_source_id) → report_using_data_source(id)
- report_data_source_query_chart(report_data_source_query_id) → report_data_source_query(id)
- report_collection_query_run(query_token) → report_collection_query(token)
- report_collection_query_run(data_source_id) → data_source(id)
- report_collection_query_run(report_collection_id) → report_collection(id)
- report_collection_query_run(report_collection_run_id) → report_collection_run(id)
- report_collection(account_id) → account(id)
- report_collection(collection_id) → collection(id)