# Meltwater schema ERD

Table and field reference for the Fivetran Meltwater connector.

## Table & Field Reference

### search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| query_boolean | Unknown |  |
| query_case_sensitivity | Unknown |  |
| query_filter_set | Unknown |  |
| query_type | Unknown |  |
| updated | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### document_author

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| external_id | Unknown |  |
| information_type | Unknown |  |
| name | Unknown |  |
| profile_url | Unknown |  |

### document_key_phrase

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| key_phrase | Unknown |  |

### document_matched_keyword

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| keyword | Unknown |  |

### document_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| tags | Unknown |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| search_id | Unknown | FK |
| city | Unknown |  |
| city_latitude | Unknown |  |
| city_longitude | Unknown |  |
| city_name | Unknown |  |
| enagement | Unknown |  |
| external_id | Unknown |  |
| hashtag | Json |  |
| hidden | Unknown |  |
| hit_sentence | Unknown |  |
| image_link | Unknown |  |
| language_code | Unknown |  |
| locatin_approximate | Unknown |  |
| media_type | Unknown |  |
| opening_text | Unknown |  |
| publish_date | Unknown |  |
| region | Unknown |  |
| region_latitude | Unknown |  |
| region_longitude | Unknown |  |
| region_name | Unknown |  |
| search_name | Unknown |  |
| sentiment | Unknown |  |
| social_echo_facebook | Unknown |  |
| social_echo_reddit | Unknown |  |
| social_echo_twitter | Unknown |  |
| source_ave | Unknown |  |
| source_country_code | Unknown |  |
| source_id | Unknown |  |
| source_information_type | Unknown |  |
| source_name | Unknown |  |
| source_reach | Unknown |  |
| source_reach_desktop | Unknown |  |
| source_reach_mobile | Unknown |  |
| source_subregion | Unknown |  |
| tag_name | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |
| view | Unknown |  |
| visibility | Unknown |  |

## Relationships

- document_author(document_id) → document(id)
- document_key_phrase(document_id) → document(id)
- document_matched_keyword(document_id) → document(id)
- document_tag(document_id) → document(id)
- document(company_id) → company(id)
- document(search_id) → search(id)