# YouGov BrandIndex schema ERD

Table and field reference for the Fivetran YouGov BrandIndex connector.

## Table & Field Reference

### analysis_report

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| analysis_id | Unknown | FK |
| brand_id | Unknown | FK |
| custom_sector_label | Unknown | FK |
| metric | Unknown | FK |
| query_id | Unknown | FK |
| region | Unknown | FK |
| brand_label | Unknown |  |
| custom_sector_uuid | Unknown |  |
| negatives | Unknown |  |
| negatives_neutrals | Unknown |  |
| neutrals | Unknown |  |
| positives | Unknown |  |
| positives_neutrals | Unknown |  |
| query_index | Unknown |  |
| score | Unknown |  |
| sector_id | Unknown |  |
| sector_label | Unknown |  |
| volume | Unknown |  |

### analysis_query

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| analysis_id | Unknown | PK, FK |
| entity_brand_id | Unknown | FK |
| entity_region | Unknown | FK |
| entity_sector_id | Unknown | FK |
| confidence_bound | Unknown |  |
| entity | Json |  |
| filters | Json |  |
| is_market_scanner | Unknown |  |
| metrics_score_types | Json |  |
| moving_average | Unknown |  |
| period_end_date | Json |  |
| period_start_date | Json |  |
| properties_meta_filter | Json |  |
| resample_size | Unknown |  |
| resample_type | Unknown |  |
| scoring | Unknown |  |
| title | Unknown |  |
| uuid | Unknown |  |
| visualization_attributes_color | Unknown |  |
| visualization_attributes_metrics | Json |  |

### analysis_tags

| Column | Type | Keys |
| --- | --- | --- |
| analysis_id | Unknown | PK, FK |
| label | Unknown | PK, FK |
| uuid | Unknown |  |

### analysis

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| has_market_scanner | Unknown |  |
| is_listed | Unknown |  |
| is_public | Unknown |  |
| resource_meta_author_email | Unknown |  |
| resource_meta_author_first_name | Unknown |  |
| resource_meta_author_last_name | Unknown |  |
| resource_meta_author_uuid | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |
| visualization_attributes_chart | Unknown |  |
| visualization_attributes_confidence_bounds | Unknown |  |
| visualization_attributes_options | Json |  |
| visualization_attributes_type | Unknown |  |
| visualization_attributes_use_all_entities | Unknown |  |
| visualization_attributes_use_all_filters | Unknown |  |
| visualization_attributes_use_all_metrics | Unknown |  |

### ranking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comparison_period_end_date | Json |  |
| comparison_period_start_date | Json |  |
| created_at | Unknown |  |
| entities | Json |  |
| filters | Json |  |
| is_listed | Unknown |  |
| is_market_scanner | Unknown |  |
| is_public | Unknown |  |
| metrics_score_types | Json |  |
| period_end_date_days | Json |  |
| period_start_date | Json |  |
| resource_meta_author_email | Unknown |  |
| resource_meta_author_first_name | Unknown |  |
| resource_meta_author_last_name | Unknown |  |
| resource_meta_author_uuid | Unknown |  |
| scoring | Unknown |  |
| significance_percentages | Json |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |
| visualization_attributes_type | Unknown |  |

### event_tags

| Column | Type | Keys |
| --- | --- | --- |
| event_label | Unknown | PK, FK |
| label | Unknown | PK, FK |
| uuid | Unknown |  |

### event_context

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_label | Unknown | PK, FK |
| brand_id | Unknown | FK |
| metric | Unknown | FK |
| region | Unknown | FK |
| sector_id | Unknown | FK |

### event

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| is_global | Unknown |  |
| is_listed | Unknown |  |
| is_public | Unknown |  |
| resource_meta_author_email | Unknown |  |
| resource_meta_author_first_name | Unknown |  |
| resource_meta_author_last_name | Unknown |  |
| resource_meta_author_uuid | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |

### profiles_dataseries_language

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| profiles_dataseries_name | Unknown | PK |

### region_sector

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| region | Unknown | PK, FK |
| industry_label | Unknown | FK |
| is_active | Unknown |  |
| is_market_scanner | Unknown |  |
| label | Unknown |  |

### custom_sector_brand

| Column | Type | Keys |
| --- | --- | --- |
| custom_sector_label | Unknown | PK, FK |
| region_sector_brand_id | Unknown | PK, FK |

### custom_sector_tags

| Column | Type | Keys |
| --- | --- | --- |
| custom_sector_label | Unknown | PK, FK |
| label | Unknown | PK, FK |

### custom_sector

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| created_at | Unknown |  |
| has_market_scanner | Unknown |  |
| is_listed | Unknown |  |
| is_public | Unknown |  |
| resource_meta_author_email | Unknown |  |
| resource_meta_author_first_name | Unknown |  |
| resource_meta_author_last_name | Unknown |  |
| resource_meta_author_uuid | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |

### metric

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| label | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### industry_tree_children_brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| industry_tree_children_label | Unknown | PK, FK |
| industry_tree_label | Unknown | PK, FK |

### industry_tree_children

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| industry_tree_label | Unknown | PK, FK |
| children | Json |  |
| created_at | Unknown |  |
| parent_uuid | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |

### industry_tree_brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| industry_tree_label | Unknown | PK, FK |

### industry_tree

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| region_name | Unknown | PK, FK |
| parent_uuid | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |

### region

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| has_market_scanner | Unknown |  |
| label | Unknown |  |
| permitted | Unknown |  |

### region_sector_brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| region | Unknown | PK, FK |
| sector_id | Unknown | PK, FK |
| is_active | Unknown |  |
| label | Unknown |  |
| validity_period_end_date | Unknown |  |
| validity_period_start_date | Unknown |  |

### filter_composite_tags

| Column | Type | Keys |
| --- | --- | --- |
| filter_composite_label | Unknown | PK, FK |
| label | Unknown | PK, FK |
| uuid | Unknown |  |

### filter_composite_response

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| filter_composite_label | Unknown | PK, FK |
| expression | Unknown |  |
| uuid | Unknown |  |

### filter_composite

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| region_name | Unknown | FK |
| created_at | Unknown |  |
| is_listed | Unknown |  |
| is_public | Unknown |  |
| resource_meta_author_email | Unknown |  |
| resource_meta_author_first_name | Unknown |  |
| resource_meta_author_last_name | Unknown |  |
| resource_meta_author_uuid | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |
| valid_in_sectors | Json |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| user_uuid | Unknown |  |
| uuid | Unknown |  |
| visualization_attributes | Json |  |

## Relationships

- analysis_report(analysis_id) → analysis(uuid)
- analysis_report(region) → region(name)
- analysis_report(query_id) → analysis_query(id)
- analysis_report(custom_sector_label) → custom_sector(label)
- analysis_report(brand_id) → region_sector_brand(id)
- analysis_report(metric) → metric(name)
- analysis_query(analysis_id) → analysis(id)
- analysis_query(entity_brand_id) → region_sector_brand(id)
- analysis_query(entity_region) → region(name)
- analysis_query(entity_sector_id) → region_sector(id)
- analysis_tags(label) → tags(label)
- analysis_tags(analysis_id) → analysis(id)
- event_tags(label) → tags(label)
- event_tags(event_label) → event(label)
- event_context(region) → region(name)
- event_context(sector_id) → region_sector(id)
- event_context(brand_id) → region_sector_brand(id)
- event_context(metric) → metric(name)
- event_context(event_label) → event(label)
- region_sector(region) → region(name)
- region_sector(industry_label) → industry_tree(label)
- custom_sector_brand(region_sector_brand_id) → region_sector_brand(id)
- custom_sector_brand(custom_sector_label) → custom_sector(label)
- custom_sector_tags(label) → tags(label)
- custom_sector_tags(custom_sector_label) → custom_sector(label)
- industry_tree_children_brand(id) → region_sector_brand(id)
- industry_tree_children_brand(industry_tree_label) → industry_tree(label)
- industry_tree_children_brand(industry_tree_children_label) → industry_tree_children(label)
- industry_tree_children(industry_tree_label) → industry_tree(label)
- industry_tree_brand(id) → region_sector_brand(id)
- industry_tree_brand(industry_tree_label) → industry_tree(label)
- industry_tree(parent_uuid) → industry_tree(uuid)
- industry_tree(region_name) → region(name)
- region_sector_brand(region) → region(name)
- region_sector_brand(sector_id) → region_sector(id)
- filter_composite_tags(label) → tags(label)
- filter_composite_tags(filter_composite_label) → filter_composite(label)
- filter_composite_response(filter_composite_label) → filter_composite(label)
- filter_composite(region_name) → region(name)