# YouGov Sport schema ERD

Table and field reference for the Fivetran YouGov Sport connector.

## Table & Field Reference

### online_press

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| event_id | Unknown | PK, FK |
| correct_mention | Unknown |  |
| count | Unknown |  |
| date_formatted | Unknown |  |
| event_name | Unknown |  |
| exp_count | Unknown |  |
| gross | Unknown |  |
| image_mention | Unknown |  |
| incorrect_mention | Unknown |  |
| net | Unknown |  |
| other_mention | Unknown |  |
| readership | Unknown |  |

### social_media

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| event_id | Unknown | PK, FK |
| comments | Unknown |  |
| count | Unknown |  |
| date_formatted | Unknown |  |
| dislikes | Unknown |  |
| event_name | Unknown |  |
| expcount | Unknown |  |
| gross | Unknown |  |
| image_mention | Unknown |  |
| impression | Unknown |  |
| likes | Unknown |  |
| net | Unknown |  |
| other_mention | Unknown |  |
| shares | Unknown |  |
| total_engagement | Unknown |  |
| views | Unknown |  |

### linear_tv

| Column | Type | Keys |
| --- | --- | --- |
| broadcaster_id | Unknown | PK |
| country_id | Unknown | PK |
| date | Unknown | PK |
| event_id | Unknown | PK, FK |
| audience | Unknown |  |
| brand_exposure | Unknown |  |
| brand_exposure_per_hour | Unknown |  |
| brand_impact_score | Unknown |  |
| broadcaster | Unknown |  |
| count | Unknown |  |
| country | Unknown |  |
| dateformatted | Unknown |  |
| discount_percentage | Unknown |  |
| duration | Unknown |  |
| event_name | Unknown |  |
| gross | Unknown |  |
| net | Unknown |  |
| number_of_seconds | Unknown |  |
| sport_id | Unknown |  |
| sport_name | Unknown |  |

### digital_streaming

| Column | Type | Keys |
| --- | --- | --- |
| broadcaster_id | Unknown | PK |
| country_id | Unknown | PK |
| date | Unknown | PK |
| event_id | Unknown | PK, FK |
| audience | Unknown |  |
| brand_exposure | Unknown |  |
| brand_exposure_per_hour | Unknown |  |
| brand_impact_score | Unknown |  |
| broadcaster_name | Unknown |  |
| country_name | Unknown |  |
| date_formatted | Unknown |  |
| duration | Unknown |  |
| event_name | Unknown |  |
| gross | Unknown |  |
| net | Unknown |  |
| sport_id | Unknown |  |
| sport_name | Unknown |  |

### event

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

### social_media_video

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| event_id | Unknown | PK, FK |
| brand_exposure | Unknown |  |
| brand_exposure_per_hour | Unknown |  |
| brand_impact_score | Unknown |  |
| comments | Unknown |  |
| count | Unknown |  |
| date_formatted | Unknown |  |
| dislikes | Unknown |  |
| duration | Unknown |  |
| event_name | Unknown |  |
| gross | Unknown |  |
| likes | Unknown |  |
| net | Unknown |  |
| shares | Unknown |  |
| total_engagement | Unknown |  |
| views | Unknown |  |

## Relationships

- online_press(event_id) → event(id)
- social_media(event_id) → event(id)
- linear_tv(event_id) → event(id)
- digital_streaming(event_id) → event(id)
- social_media_video(event_id) → event(id)