# Talkwalker schema ERD

Table and field reference for the Fivetran Talkwalker connector.

## Table & Field Reference

### credit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| estimate_credits_used_until_end_of_billing_period | Unknown |  |
| monthly_total | Unknown |  |
| next_billing_period | Unknown |  |
| remaining_credits_monthly | Unknown |  |
| remaining_credits_onetime | Unknown |  |
| used_credits_monthly | Unknown |  |
| used_credits_onetime | Unknown |  |

### collector

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

### dashboard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| view_id | Unknown | FK |
| last_update | Unknown |  |
| title | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| view_id | Unknown | FK |
| last_update | Unknown |  |
| title | Unknown |  |

### view

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| title | Unknown |  |

### topic_node

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| resource_topic_id | Unknown | PK, FK |
| resource_id | Unknown | FK |
| description | Unknown |  |
| title | Unknown |  |

### resource_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| resource_id | Unknown | PK, FK |
| description | Unknown |  |
| title | Unknown |  |

### resource_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| resource_id | Unknown | PK, FK |
| title | Unknown |  |

### filter_node

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| resource_filter_id | Unknown | PK, FK |
| resource_id | Unknown | FK |
| description | Unknown |  |
| title | Unknown |  |

### resource_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| resource_id | Unknown | PK, FK |
| description | Unknown |  |
| title | Unknown |  |

### channel_node

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| resource_channel_id | Unknown | PK, FK |
| resource_id | Unknown | PK, FK |
| title | Unknown |  |
| type | Unknown |  |

### resource_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| resource_id | Unknown | PK, FK |
| title | Unknown |  |

### resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| title | Unknown |  |

### task_message

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| task_id | Unknown | PK, FK |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creation_date | Unknown |  |
| processed | Unknown |  |
| progress | Unknown |  |
| status | Unknown |  |
| target | Unknown |  |
| type | Unknown |  |

### project_import_type

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| project_id | Unknown | PK, FK |

### project

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

### collector_data_source_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| collector_id | Unknown | PK, FK |
| indexed | Unknown | PK, FK |
| search_indexed | Unknown | PK, FK |
| source_type | Unknown |  |

### collector_data_collection

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| collector_id | Unknown | PK, FK |
| indexed | Unknown | PK, FK |
| search_indexed | Unknown | PK, FK |
| collection_id | Unknown |  |

### collector_data_token_content

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| collector_id | Unknown | PK, FK |
| indexed | Unknown | PK, FK |
| search_indexed | Unknown | PK, FK |
| token_content | Unknown |  |

### collector_data_token_title

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| collector_id | Unknown | PK, FK |
| indexed | Unknown | PK, FK |
| search_indexed | Unknown | PK, FK |
| token_title | Unknown |  |

### collector_data

| Column | Type | Keys |
| --- | --- | --- |
| indexed | Unknown | PK |
| search_indexed | Unknown | PK |
| collector_id | Unknown | PK, FK |
| article_extended_attribute_douyin_collect | Unknown |  |
| article_extended_attribute_douyin_share_num | Unknown |  |
| article_extended_attribute_douyin_video_likes | Unknown |  |
| article_extended_attribute_num_comments | Unknown |  |
| article_extended_attribute_url_views | Unknown |  |
| content | Unknown |  |
| domain_url | Unknown |  |
| extra_author_attribute_gender | Unknown |  |
| extra_author_attribute_id | Unknown |  |
| extra_author_attribute_name | Unknown |  |
| extra_source_attribute_id | Unknown |  |
| extra_source_attribute_name | Unknown |  |
| extra_source_attribute_world_data_city | Unknown |  |
| extra_source_attribute_world_data_continent | Unknown |  |
| extra_source_attribute_world_data_country | Unknown |  |
| extra_source_attribute_world_data_country_code | Unknown |  |
| extra_source_attribute_world_data_latitude | Unknown |  |
| extra_source_attribute_world_data_longitude | Unknown |  |
| extra_source_attribute_world_data_region | Unknown |  |
| extra_source_attribute_world_data_resolution | Unknown |  |
| fluency_level | Unknown |  |
| host_url | Unknown |  |
| lang | Unknown |  |
| matched_appearance | Unknown |  |
| parent_url | Unknown |  |
| porn_level | Unknown |  |
| post_type | Json |  |
| published | Unknown |  |
| root_url | Unknown |  |
| sentiment | Unknown |  |
| source_extended_attribute_alexa_pageviews | Unknown |  |
| source_extended_attribute_alexa_unique_visitors | Unknown |  |
| source_extended_attribute_douyin_reach | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |
| word_count | Unknown |  |

### collector_highlighted_data_project_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| collector_highlighted_data_fivetran_id | Unknown | PK, FK |
| category | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### collector_highlighted_data

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| collector_id | Unknown | FK |
| matched_project_id | Unknown | FK |
| content_snippet | Unknown |  |
| title_snippet | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| label | Unknown |  |

## Relationships

- dashboard(view_id) → view(project_id)
- report(view_id) → view(project_id)
- view(project_id) → project(id)
- topic_node(resource_topic_id) → resource_topic(id)
- topic_node(resource_id) → resource_topic(resource_id)
- resource_topic(resource_id) → resource(id)
- resource_event(resource_id) → resource(id)
- filter_node(resource_filter_id) → resource_filter(id)
- filter_node(resource_id) → resource_filter(resource_id)
- resource_filter(resource_id) → resource(id)
- channel_node(resource_channel_id) → resource_channel(id)
- channel_node(resource_id) → resource_channel(resource_id)
- resource_channel(resource_id) → resource(id)
- resource(project_id) → project(id)
- task_message(task_id) → task(id)
- project_import_type(project_id) → project(id)
- collector_data_source_type(collector_id) → collector_data(collector_id)
- collector_data_source_type(search_indexed) → collector_data(search_indexed)
- collector_data_source_type(indexed) → collector_data(indexed)
- collector_data_collection(collector_id) → collector_data(collector_id)
- collector_data_collection(indexed) → collector_data(indexed)
- collector_data_collection(search_indexed) → collector_data(search_indexed)
- collector_data_token_content(collector_id) → collector_data(collector_id)
- collector_data_token_content(indexed) → collector_data(indexed)
- collector_data_token_content(search_indexed) → collector_data(search_indexed)
- collector_data_token_title(collector_id) → collector_data(collector_id)
- collector_data_token_title(indexed) → collector_data(indexed)
- collector_data_token_title(search_indexed) → collector_data(search_indexed)
- collector_data(collector_id) → collector(id)
- collector_highlighted_data_project_profile(collector_highlighted_data_fivetran_id) → collector_highlighted_data(_fivetran_id)
- collector_highlighted_data(matched_project_id) → project(id)
- collector_highlighted_data(collector_id) → collector(id)
- tags(project_id) → project(id)