# Profound schema ERD

Table and field reference for the Fivetran Profound connector.

## Table & Field Reference

### report_citation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| category_id | Unknown | FK |
| prompt_id | Unknown | FK |
| topic_id | Unknown | FK |
| citation_category | Unknown |  |
| citation_share | Unknown |  |
| count | Unknown |  |
| date | Unknown |  |
| hostname | Unknown |  |
| model | Unknown |  |
| path | Unknown |  |
| persona | Unknown |  |
| region | Unknown |  |
| root_domain | Unknown |  |
| tags | Unknown |  |
| url | Unknown |  |

### category_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | PK, FK |
| name | Unknown |  |
| status | Unknown |  |

### optimization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | PK, FK |
| created_at | Instant |  |
| extracted_input | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### model

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

### persona_employment_industry

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| persona_id | Unknown | PK, FK |
| industry | Unknown |  |

### persona_employment_job_title

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| persona_id | Unknown | PK, FK |
| job_title | Unknown |  |

### persona_employment_company_size

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| persona_id | Unknown | PK, FK |
| company_size | Unknown |  |

### persona_employment_role_seniority

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| persona_id | Unknown | PK, FK |
| role_seniority | Unknown |  |

### persona_demographics_age_range

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| persona_id | Unknown | PK, FK |
| age_range | Unknown |  |

### persona

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| behavior_motivations | Unknown |  |
| behavior_pain_points | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| organization_name | Unknown |  |

### report_fanout

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| category_id | Unknown | FK |
| date | Unknown |  |
| fanouts_per_execution | Unknown |  |
| model | Unknown |  |
| prompt | Unknown |  |
| query | Unknown |  |
| region | Unknown |  |
| share | Unknown |  |
| total_fanouts | Unknown |  |

### report_sentiment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asset_id | Unknown | FK |
| category_id | Unknown | FK |
| prompt_id | Unknown | FK |
| topic_id | Unknown | FK |
| date | Unknown |  |
| model | Unknown |  |
| negative | Unknown |  |
| occurrences | Unknown |  |
| persona | Unknown |  |
| positive | Unknown |  |
| region | Unknown |  |
| sentiment_type | Unknown |  |
| tags | Unknown |  |
| theme | Unknown |  |

### answer_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |
| tags | Unknown |  |

### answer_mention

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |
| mention | Unknown |  |

### answer_citation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |
| citation | Unknown |  |

### answer_search_query

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |
| search_query | Unknown |  |

### answer_sentiment_theme

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| category_id | Unknown | PK, FK |
| run_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### answer

| Column | Type | Keys |
| --- | --- | --- |
| run_id | Unknown | PK |
| category_id | Unknown | PK, FK |
| asset_id | Unknown | FK |
| model_id | Unknown | FK |
| prompt_id | Unknown | FK |
| topic_id | Unknown | FK |
| created_at | Unknown |  |
| persona | Unknown |  |
| region | Unknown |  |
| response | Unknown |  |

### category_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | PK, FK |
| name | Unknown |  |

### domain

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| organization_name | Unknown |  |

### report_visibility

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asset_id | Unknown | FK |
| category_id | Unknown | FK |
| prompt_id | Unknown | FK |
| topic_id | Unknown | FK |
| average_position | Unknown |  |
| date | Unknown |  |
| executions | Unknown |  |
| mentions_count | Unknown |  |
| model | Unknown |  |
| persona | Unknown |  |
| region | Unknown |  |
| share_of_voice | Unknown |  |
| tags | Unknown |  |
| visibility_score | Unknown |  |

### asset_alternate_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| domain | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| created_at | Instant |  |
| is_owned | Unknown |  |
| logo_url | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| organization_name | Unknown |  |
| website | Unknown |  |

### region

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

### category

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

### prompt_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| prompt_id | Unknown | PK, FK |
| region_id | Unknown | FK |

### prompt_platform

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| prompt_id | Unknown | PK, FK |
| name | Unknown |  |
| platform_id | Unknown |  |

### prompt_analysis_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| prompt_id | Unknown | PK, FK |
| analysis_type | Unknown |  |

### prompt

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | PK, FK |
| topic_id | Unknown | FK |
| created_at | Instant |  |
| languages | Unknown |  |
| personas | Json |  |
| prompt | Unknown |  |
| tags | Json |  |

## Relationships

- report_citation(topic_id) → category_topic(id)
- report_citation(prompt_id) → prompt(id)
- report_citation(category_id) → category(id)
- category_topic(category_id) → category(id)
- optimization(asset_id) → asset(id)
- persona_employment_industry(persona_id) → persona(id)
- persona_employment_job_title(persona_id) → persona(id)
- persona_employment_company_size(persona_id) → persona(id)
- persona_employment_role_seniority(persona_id) → persona(id)
- persona_demographics_age_range(persona_id) → persona(id)
- persona(category_id) → category(id)
- report_fanout(category_id) → category(id)
- report_sentiment(topic_id) → category_topic(id)
- report_sentiment(asset_id) → asset(id)
- report_sentiment(prompt_id) → prompt(id)
- report_sentiment(category_id) → category(id)
- answer_tag(category_id) → answer(category_id)
- answer_tag(run_id) → answer(run_id)
- answer_mention(category_id) → answer(category_id)
- answer_mention(run_id) → answer(run_id)
- answer_citation(category_id) → answer(category_id)
- answer_citation(run_id) → answer(run_id)
- answer_search_query(category_id) → answer(category_id)
- answer_search_query(run_id) → answer(run_id)
- answer_sentiment_theme(category_id) → answer(category_id)
- answer_sentiment_theme(run_id) → answer(run_id)
- answer(topic_id) → category_topic(id)
- answer(asset_id) → asset(id)
- answer(prompt_id) → prompt(id)
- answer(model_id) → model(id)
- answer(category_id) → category(id)
- category_tag(category_id) → category(id)
- report_visibility(topic_id) → category_topic(id)
- report_visibility(asset_id) → asset(id)
- report_visibility(prompt_id) → prompt(id)
- report_visibility(category_id) → category(id)
- asset_alternate_domain(asset_id) → asset(id)
- asset(category_id) → category(id)
- prompt_region(region_id) → region(id)
- prompt_region(prompt_id) → prompt(id)
- prompt_platform(prompt_id) → prompt(id)
- prompt_analysis_type(prompt_id) → prompt(id)
- prompt(topic_id) → category_topic(id)
- prompt(category_id) → category(id)