# Alation schema ERD

Table and field reference for the Fivetran Alation connector.

## Table & Field Reference

### document_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| field_id | Unknown | FK |
| value | Json |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_document_id | Unknown | FK |
| parent_folder_id | Unknown | FK |
| deleted | Boolean |  |
| description | Unknown |  |
| document_hub_id | Unknown |  |
| folder_ids | Json |  |
| nav_link_folder_ids | Json |  |
| nav_links_count | Unknown |  |
| template_id | Unknown |  |
| title | Unknown |  |
| ts_created | Instant |  |
| ts_deleted | Instant |  |
| ts_updated | Instant |  |

### term_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| field_id | Unknown | PK, FK |
| term_id | Unknown | PK, FK |
| field_name | Unknown |  |
| value | Json |  |

### term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted | Boolean |  |
| description | Unknown |  |
| glossary_ids | Json |  |
| template_id | Unknown |  |
| title | Unknown |  |
| ts_created | Instant |  |
| ts_deleted | Instant |  |
| ts_updated | Instant |  |

### policy_steward

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| deleted | Boolean |  |
| email | Unknown |  |
| name | Unknown |  |
| otype | Unknown |  |
| otype_display_name | Unknown |  |
| photo_url | Unknown |  |
| snippet | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| otype | Unknown |  |
| title | Unknown |  |
| ts_created | Instant |  |
| url | Unknown |  |

### policy_group_steward

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_group_id | Unknown | PK, FK |
| deleted | Boolean |  |
| email | Unknown |  |
| name | Unknown |  |
| otype | Unknown |  |
| otype_display_name | Unknown |  |
| photo_url | Unknown |  |
| snippet | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### policy_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| otype | Unknown |  |
| policies_count | Unknown |  |
| title | Unknown |  |
| ts_created | Instant |  |
| url | Unknown |  |

### custom_field_allowed_otype

| Column | Type | Keys |
| --- | --- | --- |
| otype | Unknown | PK |
| custom_field_id | Unknown | PK, FK |

### custom_field_option

| Column | Type | Keys |
| --- | --- | --- |
| option | Unknown | PK |
| custom_field_id | Unknown | PK, FK |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_multiple | Boolean |  |
| backref_name | Unknown |  |
| backref_tooltip_text | Unknown |  |
| builtin_name | Unknown |  |
| field_type | Unknown |  |
| name_plural | Unknown |  |
| name_singular | Unknown |  |
| tooltip_text | Unknown |  |

### column_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| column_detail_id | Unknown | PK, FK |
| field_id | Unknown | FK |
| field_name | Unknown |  |
| source_tag_applied_state | Unknown |  |
| value | Json |  |

### column_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| datasource_id | Unknown | FK |
| schema_id | Unknown | FK |
| table_id | Unknown | FK |
| column_comment | Unknown |  |
| column_type | Unknown |  |
| description | Unknown |  |
| index_is_foreign_key | Unknown |  |
| index_is_other_index | Unknown |  |
| index_is_primary_key | Unknown |  |
| index_referenced_column_id | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| nullable | Boolean |  |
| position | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### child_column_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| column_id | Unknown | PK, FK |
| children | Json |  |
| description | Unknown |  |
| key | Unknown |  |
| other_metadata | Json |  |
| path | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### datasource_ocf

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| all_schemas | Unknown |  |
| auth_tip | Unknown |  |
| aws_access_key_id | Unknown |  |
| aws_region | Unknown |  |
| builtin_datasource | Unknown |  |
| can_data_upload | Boolean |  |
| can_toggle_ds_privacy | Boolean |  |
| compose_oauth_enabled | Boolean |  |
| connector_id | Unknown |  |
| cron_extraction | Unknown |  |
| data_upload_disabled_message | Unknown |  |
| db_username | Unknown |  |
| dbname | Unknown |  |
| dbtype | Unknown |  |
| delete_status | Unknown |  |
| deleted | Boolean |  |
| deployment_setup_complete | Boolean |  |
| description | Unknown |  |
| disable_auto_extraction | Boolean |  |
| enable_complex_type | Boolean |  |
| enable_default_schema_extraction | Boolean |  |
| enable_designated_credential | Boolean |  |
| enable_preserve_query_result | Boolean |  |
| enable_query_result_export | Boolean |  |
| exclude_additional_columns_in_qli | Boolean |  |
| exclude_schemas | Unknown |  |
| favorited_by_list | Json |  |
| has_aws_glue_metastore | Boolean |  |
| has_aws_s_3_based_qli | Boolean |  |
| has_hdfs_based_qli | Boolean |  |
| has_metastore_uri | Boolean |  |
| has_previewable_qli | Boolean |  |
| hive_logs_source | Unknown |  |
| hive_logs_source_type | Unknown |  |
| hive_tez_logs_source | Unknown |  |
| host | Unknown |  |
| icon | Unknown |  |
| is_gone | Boolean |  |
| is_hidden | Boolean |  |
| is_hive | Boolean |  |
| is_presto_hive | Boolean |  |
| is_virtual | Boolean |  |
| jdbc_driver | Unknown |  |
| latest_extraction_successful | Boolean |  |
| latest_extraction_time | Instant |  |
| limit_schemas | Unknown |  |
| metastore_type | Unknown |  |
| metastore_uri | Unknown |  |
| negative_filter_words | Json |  |
| nosql_mde_sample_size | Unknown |  |
| obfuscate_literals | Json |  |
| otype | Unknown |  |
| owner_ids | Json |  |
| port | Unknown |  |
| private | Boolean |  |
| profiling_tip | Unknown |  |
| qli_aws_access_key_id | Unknown |  |
| qli_aws_region | Unknown |  |
| qli_hive_connection_source | Unknown |  |
| qualified_name | Unknown |  |
| remove_filtered_schemas | Boolean |  |
| result_sharing_permission | Unknown |  |
| supports_compose | Boolean |  |
| supports_default_schema_extraction | Boolean |  |
| supports_explain | Boolean |  |
| supports_md_diagnostics | Boolean |  |
| supports_ocf_query_service_api | Boolean |  |
| supports_profiling | Boolean |  |
| supports_profiling_v_2 | Boolean |  |
| supports_qli_daterange | Boolean |  |
| supports_qli_diagnostics | Boolean |  |
| supports_query_cancellation | Boolean |  |
| title | Unknown |  |
| unresolved_mention_fingerprint_method | Unknown |  |
| uri | Unknown |  |
| url | Unknown |  |
| use_query_service | Unknown |  |
| uses_ocf_agent | Boolean |  |
| webhdfs_port | Unknown |  |
| webhdfs_server | Unknown |  |
| webhdfs_username | Unknown |  |

### schema_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| schema_detail_id | Unknown | PK, FK |
| field_id | Unknown | FK |
| field_name | Unknown |  |
| source_tag_applied_state | Unknown |  |
| value | Unknown |  |

### schema_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| datasource_id | Unknown | FK |
| db_comment | Unknown |  |
| description | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### custom_field_value_detail

| Column | Type | Keys |
| --- | --- | --- |
| object_id | Unknown | PK |
| field_id | Unknown | PK, FK |
| otype | Unknown |  |
| source_tag_applied_state | Unknown |  |
| ts_updated | Instant |  |
| value | Json |  |

### table_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| table_detail_id | Unknown | PK, FK |
| field_id | Unknown | FK |
| source_tag_applied_state | Unknown |  |
| value | Json |  |

### table_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| datasource_id | Unknown | FK |
| schema_id | Unknown | FK |
| base_table_key | Unknown |  |
| description | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| partition_columns | Json |  |
| partition_definition | Unknown |  |
| sql | Unknown |  |
| table_comment | Unknown |  |
| table_type | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### folder_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | Unknown | PK, FK |
| folder_id | Unknown | PK, FK |

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_folder_id | Unknown | FK |
| deleted | Boolean |  |
| description | Unknown |  |
| document_hub_id | Unknown |  |
| nav_links_count | Unknown |  |
| template_id | Unknown |  |
| title | Unknown |  |
| ts_created | Instant |  |
| ts_deleted | Instant |  |
| ts_updated | Instant |  |

## Relationships

- document_custom_field(field_id) → custom_field(id)
- document_custom_field(document_id) → document(id)
- document(parent_folder_id) → folder(id)
- document(parent_document_id) → document(id)
- term_custom_field(field_id) → custom_field(id)
- term_custom_field(term_id) → term(id)
- policy_steward(policy_id) → policy(id)
- policy_group_steward(policy_group_id) → policy_group(id)
- custom_field_allowed_otype(custom_field_id) → custom_field(id)
- custom_field_option(custom_field_id) → custom_field(id)
- column_custom_field(field_id) → custom_field(id)
- column_custom_field(column_detail_id) → column_detail(id)
- column_detail(datasource_id) → datasource_ocf(id)
- column_detail(schema_id) → schema_detail(id)
- column_detail(table_id) → table_detail(id)
- child_column_detail(column_id) → column_detail(id)
- schema_custom_field(field_id) → custom_field(id)
- schema_custom_field(schema_detail_id) → schema_detail(id)
- schema_detail(datasource_id) → datasource_ocf(id)
- custom_field_value_detail(field_id) → custom_field(id)
- table_custom_field(field_id) → custom_field(id)
- table_custom_field(table_detail_id) → table_detail(id)
- table_detail(datasource_id) → datasource_ocf(id)
- table_detail(schema_id) → schema_detail(id)
- folder_custom_field(custom_field_id) → custom_field(id)
- folder_custom_field(folder_id) → folder(id)
- folder(parent_folder_id) → folder(id)