Writesonic
Explore the interactive ERD
Table & Field Reference
content_keyword_response
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
content_keyword_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | |
is_competitor | Unknown | |
is_self_website | Unknown | |
name | Unknown |
content_citation_response
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
content_citation_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
prompt_id | Unknown | PKFK |
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 | PKFK |
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 |