YouGov BrandIndex
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
label | Unknown | PKFK |
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 | PKFK |
label | Unknown | PKFK |
uuid | Unknown |
event_context
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_label | Unknown | PKFK |
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 | PKFK |
industry_label | Unknown | FK |
is_active | Unknown | |
is_market_scanner | Unknown | |
label | Unknown |
custom_sector_brand
| Column | Type | Keys |
|---|---|---|
custom_sector_label | Unknown | PKFK |
region_sector_brand_id | Unknown | PKFK |
custom_sector_tags
| Column | Type | Keys |
|---|---|---|
custom_sector_label | Unknown | PKFK |
label | Unknown | PKFK |
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 | PKFK |
industry_tree_children_label | Unknown | PKFK |
industry_tree_label | Unknown | PKFK |
industry_tree_children
| Column | Type | Keys |
|---|---|---|
label | Unknown | PK |
industry_tree_label | Unknown | PKFK |
children | Json | |
created_at | Unknown | |
parent_uuid | Unknown | |
updated_at | Unknown | |
uuid | Unknown |
industry_tree_brand
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
industry_tree_label | Unknown | PKFK |
industry_tree
| Column | Type | Keys |
|---|---|---|
label | Unknown | PK |
region_name | Unknown | PKFK |
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 | PKFK |
sector_id | Unknown | PKFK |
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 | PKFK |
label | Unknown | PKFK |
uuid | Unknown |
filter_composite_response
| Column | Type | Keys |
|---|---|---|
label | Unknown | PK |
filter_composite_label | Unknown | PKFK |
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 |