# Writesonic schema ERD

Table and field reference for the Fivetran Writesonic connector.

## Table & Field Reference

### content_keyword_response

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| content_keyword_id | Unknown | PK, FK |
| created_at | Unknown |  |
| paragraph | Unknown |  |
| platform_name | Unknown |  |
| query | Unknown |  |
| sentence | Unknown |  |
| sentiment | Unknown |  |

### content_keyword_response_compare

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| content_keyword_id | Unknown | PK, FK |
| created_at | Unknown |  |
| paragraph | Unknown |  |
| platform_name | Unknown |  |
| query | Unknown |  |
| sentence | Unknown |  |
| sentiment | Unknown |  |

### content_keyword

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| created_at_compare | Unknown |  |
| keyword | Unknown |  |
| subtheme | Unknown |  |
| theme | Unknown |  |

### performance_summary

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| website_id | Unknown | PK |
| rank | Unknown |  |
| rank_compare | Unknown |  |
| rank_diff | Unknown |  |
| total_mentions | Unknown |  |
| total_mentions_compare | Unknown |  |
| total_mentions_diff | Unknown |  |
| total_prompts | Unknown |  |
| total_prompts_compare | Unknown |  |
| total_prompts_diff | Unknown |  |
| total_results | Unknown |  |
| total_results_compare | Unknown |  |
| total_results_diff | Unknown |  |
| visibility_score | Unknown |  |
| visibility_score_compare | Unknown |  |
| visibility_score_diff | Unknown |  |
| website_name | Unknown |  |
| website_url | Unknown |  |

### content_citation_mentioned_website

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| content_citation_id | Unknown | PK, FK |
| id | Unknown |  |
| is_competitor | Unknown |  |
| is_self_website | Unknown |  |
| name | Unknown |  |

### content_citation_response

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| content_citation_id | Unknown | PK, FK |
| prompt_id | Unknown | FK |
| created_at | Unknown |  |
| model_id | Unknown |  |
| model_name | Unknown |  |
| prompt_text | Unknown |  |
| result_id | Unknown |  |
| topic_id | Unknown |  |
| topic_name | Unknown |  |

### content_citation_mentioned_website_compare

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| content_citation_id | Unknown | PK, FK |
| id | Unknown |  |
| is_competitor | Unknown |  |
| is_self_website | Unknown |  |
| name | Unknown |  |

### content_citation_response_compare

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| content_citation_id | Unknown | PK, FK |
| created_at | Unknown |  |
| model_id | Unknown |  |
| model_name | Unknown |  |
| prompt_id | Unknown |  |
| prompt_text | Unknown |  |
| result_id | Unknown |  |
| topic_id | Unknown |  |
| topic_name | Unknown |  |

### content_citation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| citation_domain | Unknown |  |
| citation_title | Unknown |  |
| citation_uri | Unknown |  |
| created_at | Unknown |  |

### performance_answer_brand_mention

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| platform_id | Unknown | PK, FK |
| prompt_id | Unknown | PK, FK |
| website_id | Unknown | FK |
| brand_name | Unknown |  |
| rank | Unknown |  |
| sentences | Json |  |
| visibility_score | Unknown |  |
| website_url | Unknown |  |

### performance_answer

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| platform_id | Unknown | PK |
| prompt_id | Unknown | PK, FK |
| answer_text | Unknown |  |
| avg_rank | Unknown |  |
| avg_rank_compare | Unknown |  |
| avg_rank_diff | Unknown |  |
| avg_visibility_score | Unknown |  |
| avg_visibility_score_compare | Unknown |  |
| avg_visibility_score_diff | Unknown |  |
| platform | Unknown |  |
| platform_name | Unknown |  |
| prompt | Unknown |  |
| rank | Unknown |  |
| response | Unknown |  |
| response_id | Unknown |  |
| topic | Unknown |  |
| topic_id | Unknown |  |
| visibility_score | Unknown |  |

### performance_prompt

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| id | Unknown | PK |
| avg_rank | Unknown |  |
| avg_rank_compare | Unknown |  |
| avg_rank_diff | Unknown |  |
| avg_visibility_score | Unknown |  |
| avg_visibility_score_compare | Unknown |  |
| avg_visibility_score_diff | Unknown |  |
| prompt_text | Unknown |  |
| topic_id | Unknown |  |
| topic_name | Unknown |  |
| total_mentions | Unknown |  |
| total_mentions_compare | Unknown |  |
| total_mentions_diff | Unknown |  |
| total_models | Unknown |  |
| total_models_compare | Unknown |  |
| total_models_diff | Unknown |  |

## Relationships

- content_keyword_response(content_keyword_id) → content_keyword(id)
- content_keyword_response_compare(content_keyword_id) → content_keyword(id)
- content_citation_mentioned_website(content_citation_id) → content_citation(id)
- content_citation_response(prompt_id) → performance_prompt(id)
- content_citation_response(content_citation_id) → content_citation(id)
- content_citation_mentioned_website_compare(content_citation_id) → content_citation(id)
- content_citation_response_compare(content_citation_id) → content_citation(id)
- performance_answer_brand_mention(website_id) → performance_summary(website_id)
- performance_answer_brand_mention(prompt_id) → performance_answer(prompt_id)
- performance_answer_brand_mention(platform_id) → performance_answer(platform_id)
- performance_answer(prompt_id) → performance_prompt(id)