# Megaphone schema ERD

Table and field reference for the Fivetran Megaphone connector.

## Table & Field Reference

### organization_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| label | Unknown |  |
| value | Unknown |  |

### region_country

| Column | Type | Keys |
| --- | --- | --- |
| geoname_id | Unknown | PK |
| label | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### promo_order_advertisement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promo_id | Unknown | PK, FK |
| audio_file | Unknown |  |
| audio_file_duration | Unknown |  |
| audio_file_processing | Unknown |  |
| audio_file_status | Unknown |  |
| created_at | Unknown |  |
| insertion_point | Unknown |  |
| origin_file_name | Unknown |  |
| position | Unknown |  |
| updated_at | Unknown |  |

### order_target

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| id | Unknown |  |
| type | Unknown |  |

### order_frequency_cap

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| day | Unknown |  |
| impression | Unknown |  |

### geo_name_id_inclusion

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| value | Unknown |  |

### geo_name_id_exclusion

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| value | Unknown |  |

### order_geo_target

| Column | Type | Keys |
| --- | --- | --- |
| orders_id | Unknown | PK, FK |
| target | Unknown | PK, FK |

### order_device_target

| Column | Type | Keys |
| --- | --- | --- |
| orders_id | Unknown | PK, FK |
| target | Unknown | PK, FK |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| ad_placement_type | Unknown |  |
| adhash | Unknown |  |
| audio_status | Unknown |  |
| copy_needed | Unknown |  |
| created_at | Unknown |  |
| end_at | Unknown |  |
| external_id | Unknown |  |
| flight_timezone | Unknown |  |
| geo_exclusion | Json |  |
| impressions_cap | Unknown |  |
| impressions_goal | Unknown |  |
| mtm_freeze_at | Unknown |  |
| notes | Unknown |  |
| pacing_type | Unknown |  |
| position | Unknown |  |
| price_type | Unknown |  |
| priority | Unknown |  |
| promo | Unknown |  |
| promo_code | Unknown |  |
| region | Unknown |  |
| revenue_cents | Unknown |  |
| revenue_currency | Unknown |  |
| scheduled_at | Unknown |  |
| start_at | Unknown |  |
| state | Unknown |  |
| targeted_segment | Unknown |  |
| title | Unknown |  |
| tracking_url | Json |  |
| updated_at | Unknown |  |
| vanity_url | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| created_at | Unknown |  |
| duration_in_seconds | Unknown |  |
| title | Unknown |  |
| total_budget_cents | Unknown |  |
| total_budget_currency | Unknown |  |
| total_revenue_cent | Unknown |  |
| total_revenue_currency | Unknown |  |
| updated_at | Instant |  |

### advertiser

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agency_id | Unknown |  |
| competitive_category | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### campaign_order_advertisement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| order_id | Unknown | FK |
| audio_file | Unknown |  |
| audio_file_duration | Unknown |  |
| audio_file_processing | Unknown |  |
| created_at | Unknown |  |
| insertion_point | Unknown |  |
| origin_file_name | Unknown |  |
| position | Unknown |  |
| updated_at | Unknown |  |

### nielsen_segment

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

### network

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

### episode_advertising_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| episode_id | Unknown | PK, FK |
| advertising_tag | Unknown |  |

### episode

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| network_id | Unknown | FK |
| podcast_id | Unknown | FK |
| audio_file | Unknown |  |
| audio_file_processing | Unknown |  |
| audio_file_status | Unknown |  |
| audio_file_updated_at | Unknown |  |
| author | Unknown |  |
| bit_rate | Unknown |  |
| channel_mode | Unknown |  |
| clean_title | Unknown |  |
| created_at | Unknown |  |
| custom_fields | Json |  |
| download_url | Unknown |  |
| draft | Unknown |  |
| duration | Unknown |  |
| episode_number | Unknown |  |
| episode_type | Unknown |  |
| expected_adhash | Unknown |  |
| external_id | Unknown |  |
| guid | Unknown |  |
| id_3_file | Unknown |  |
| id_3_file_processing | Unknown |  |
| id_3_file_size | Unknown |  |
| image_file | Unknown |  |
| insertion_point | Json |  |
| link | Unknown |  |
| original_filename | Unknown |  |
| original_url | Unknown |  |
| post_count | Unknown |  |
| post_offset | Unknown |  |
| pre_count | Unknown |  |
| pre_offset | Unknown |  |
| pubdate | Instant |  |
| pubdate_timezone | Unknown |  |
| sample_rate | Unknown |  |
| season_number | Unknown |  |
| size | Unknown |  |
| sound_cloud_identifier | Json |  |
| spotify_identifier | Unknown |  |
| status | Unknown |  |
| subtitle | Unknown |  |
| summary | Unknown |  |
| title | Unknown |  |
| uid | Unknown |  |
| updated_at | Unknown |  |
| vbr | Unknown |  |

### device

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| value | Unknown |  |

### agency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| billing_method | Unknown |  |
| city | Unknown |  |
| commission_percentage | Unknown |  |
| created_at | Unknown |  |
| ein | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| payement_type | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |
| zip_code | Unknown |  |

### advertiser_category_children

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK, FK |
| parent_label | Unknown | PK, FK |
| value | Unknown |  |

### advertiser_category

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| value | Unknown |  |

### podcast_itunes_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| podcast_id | Unknown | PK, FK |
| category | Unknown |  |

### podcast_excluded_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| podcast_id | Unknown | PK, FK |
| category | Unknown |  |

### podcast_advertising_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| podcast_id | Unknown | PK, FK |
| advertising_tag | Unknown |  |

### podcast_ad_free_feed_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| podcast_id | Unknown | PK, FK |
| url | Unknown |  |

### podcast_cloned_feed_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| podcast_id | Unknown | PK, FK |
| url | Unknown |  |

### podcast

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| network_id | Unknown | FK |
| ad_free | Unknown |  |
| author | Unknown |  |
| category | Unknown |  |
| copyright | Unknown |  |
| created_at | Unknown |  |
| default_ad_setting | Json |  |
| default_post_count | Unknown |  |
| default_pre_count | Unknown |  |
| episode_limit | Unknown |  |
| explicit_value | Unknown |  |
| external_id | Unknown |  |
| feed_url | Unknown |  |
| google_play_identifier | Unknown |  |
| google_podcasts_identifier | Unknown |  |
| iheart_identifier | Unknown |  |
| image_file | Unknown |  |
| itunes_active | Unknown |  |
| itunes_identifier | Unknown |  |
| itunes_rating | Unknown |  |
| languages | Unknown |  |
| link | Unknown |  |
| main_feed | Unknown |  |
| original_rss_url | Unknown |  |
| owner_email | Unknown |  |
| owner_name | Unknown |  |
| podcast_type | Unknown |  |
| podtrac_enabled | Unknown |  |
| recurring_import | Unknown |  |
| redirect_url | Unknown |  |
| redirected_at | Unknown |  |
| slug | Unknown |  |
| span_opt_in | Unknown |  |
| spotify_identifier | Unknown |  |
| stitcher_identifier | Unknown |  |
| subtitle | Unknown |  |
| summary | Unknown |  |
| title | Unknown |  |
| uid | Unknown |  |
| updated_at | Instant |  |

### d_m_a

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

## Relationships

- promo_order_advertisement(promo_id) → orders(id)
- order_target(orders_id) → orders(id)
- order_frequency_cap(orders_id) → orders(id)
- geo_name_id_inclusion(orders_id) → orders(id)
- geo_name_id_exclusion(orders_id) → orders(id)
- order_geo_target(target) → region_country(type)
- order_geo_target(orders_id) → orders(id)
- order_device_target(target) → device(label)
- order_device_target(orders_id) → orders(id)
- orders(campaign_id) → campaign(id)
- campaign(advertiser_id) → advertiser(id)
- campaign_order_advertisement(order_id) → orders(id)
- campaign_order_advertisement(campaign_id) → campaign(id)
- nielsen_segment(label) → orders(targeted_segment)
- episode_advertising_tag(episode_id) → episode(id)
- episode(network_id) → network(id)
- episode(podcast_id) → podcast(id)
- advertiser_category_children(label) → advertiser_category(label)
- advertiser_category_children(parent_label) → advertiser_category(label)
- podcast_itunes_category(podcast_id) → podcast(id)
- podcast_excluded_category(podcast_id) → podcast(id)
- podcast_advertising_tag(podcast_id) → podcast(id)
- podcast_ad_free_feed_url(podcast_id) → podcast(id)
- podcast_cloned_feed_url(podcast_id) → podcast(id)
- podcast(network_id) → network(id)
- d_m_a(label) → region_country(label)