# Trisolute schema ERD

Table and field reference for the Fivetran Trisolute connector.

## Table & Field Reference

### keyword_category

| Column | Type | Keys |
| --- | --- | --- |
| category | Unknown | PK |
| index | Unknown | PK |
| keyword_added | Unknown | PK, FK |
| keyword_keyword | Unknown | PK, FK |

### keyword

| Column | Type | Keys |
| --- | --- | --- |
| added | Unknown | PK |
| keyword | Unknown | PK |
| crawl_interval | Unknown |  |
| ignored | Unknown |  |
| priority | Unknown |  |
| relevance | Unknown |  |
| source | Unknown |  |
| updated | Unknown |  |

### serp_drilldown_keyword

| Column | Type | Keys |
| --- | --- | --- |
| keyword | Unknown | PK |
| object_type | Unknown | PK |
| total_ranking_count | Unknown |  |

### serp_publisher

| Column | Type | Keys |
| --- | --- | --- |
| publisher | Unknown | PK |
| keyword | Unknown | PK, FK |
| object_type | Unknown | PK, FK |
| ranking_count | Unknown |  |

### ranking_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ranking_identifier | Unknown | FK |
| ranking_keyword | Unknown | FK |
| amp | Unknown |  |
| crawl_date | Unknown |  |
| device | Unknown |  |
| object_type | Unknown |  |
| position | Unknown |  |
| position_in_ranking_type | Unknown |  |
| ranking_lost | Unknown |  |
| ranking_type | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |
| video | Unknown |  |

### ranking

| Column | Type | Keys |
| --- | --- | --- |
| identifier | Unknown | PK |
| keyword | Unknown | PK |
| news_tab_crawl_date | Unknown |  |
| news_tab_title | Unknown |  |
| news_tab_url | Unknown |  |
| object_type | Unknown |  |

### keyword_without_article_ranking

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| amp | Unknown |  |
| crawl_date | Unknown |  |
| device | Unknown |  |
| keyword_with_article_identifier | Unknown |  |
| keyword_with_article_keyword | Unknown |  |
| position | Unknown |  |
| position_in_ranking_type | Unknown |  |
| ranking_lost | Unknown |  |
| ranking_type | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |
| video | Unknown |  |

### keyword_with_article

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| keyword | Unknown | FK |
| identifier | Unknown |  |
| news_tab_crawl_date | Unknown |  |
| news_tab_title | Unknown |  |
| news_tab_url | Unknown |  |

### serp_drilldown_article

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| url | Unknown | PK |
| score_percentage_within_top_hit | Unknown |  |
| title | Unknown |  |

### missing_topic

| Column | Type | Keys |
| --- | --- | --- |
| date_filter | Unknown | PK |
| key | Unknown | PK, FK |

### serp_visibility_value

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| publisher | Unknown | PK |
| object_type | Unknown |  |
| value | Unknown |  |

### articles_without_ranking_keyword

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| title | Unknown | PK |
| url | Unknown | PK |
| keyword | Unknown |  |

### category_distribution_chart

| Column | Type | Keys |
| --- | --- | --- |
| category | Unknown | PK |
| date | Unknown | PK |
| publisher | Unknown | PK |
| value | Unknown |  |

### google_news_visibility_chart

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| google_chart_publisher | Unknown | PK |
| value | Unknown |  |

### general_keyword_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| general_keyword_keyword | Unknown | PK, FK |
| general_object | Unknown | PK, FK |
| category | Unknown |  |

### general_keyword

| Column | Type | Keys |
| --- | --- | --- |
| keyword | Unknown | PK |
| type | Unknown | PK |
| relevance | Unknown |  |

### topic_coverage_chart

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| publisher | Unknown | PK |
| value | Unknown |  |

### indexed_article

| Column | Type | Keys |
| --- | --- | --- |
| indexed | Unknown | PK |
| url | Unknown | PK |
| title | Unknown |  |

### index_rate_chart

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| index_chart_publisher | Unknown | PK |
| value | Unknown |  |

## Relationships

- keyword_category(keyword_keyword) → keyword(keyword)
- keyword_category(keyword_added) → keyword(added)
- serp_publisher(keyword) → serp_drilldown_keyword(keyword)
- serp_publisher(object_type) → serp_drilldown_keyword(object_type)
- ranking_detail(ranking_keyword) → ranking(keyword)
- ranking_detail(ranking_identifier) → ranking(identifier)
- keyword_with_article(keyword) → keyword(keyword)
- missing_topic(key) → keyword(keyword)
- general_keyword_category(general_keyword_keyword) → general_keyword(keyword)
- general_keyword_category(general_object) → general_keyword(type)