Megaphone

Explore the interactive ERD

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	PKFK
`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	PKFK
`id`	Unknown
`type`	Unknown

order_frequency_cap

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	Unknown	PKFK
`day`	Unknown
`impression`	Unknown

geo_name_id_inclusion

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	Unknown	PKFK
`value`	Unknown

geo_name_id_exclusion

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	Unknown	PKFK
`value`	Unknown

order_geo_target

Column	Type	Keys
`orders_id`	Unknown	PKFK
`target`	Unknown	PKFK

order_device_target

Column	Type	Keys
`orders_id`	Unknown	PKFK
`target`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`parent_label`	Unknown	PKFK
`value`	Unknown

advertiser_category

Column	Type	Keys
`label`	Unknown	PK
`value`	Unknown

podcast_itunes_category

Column	Type	Keys
`index`	Unknown	PK
`podcast_id`	Unknown	PKFK
`category`	Unknown

podcast_excluded_category

Column	Type	Keys
`index`	Unknown	PK
`podcast_id`	Unknown	PKFK
`category`	Unknown

podcast_advertising_tag

Column	Type	Keys
`index`	Unknown	PK
`podcast_id`	Unknown	PKFK
`advertising_tag`	Unknown

podcast_ad_free_feed_url

Column	Type	Keys
`index`	Unknown	PK
`podcast_id`	Unknown	PKFK
`url`	Unknown

podcast_cloned_feed_url

Column	Type	Keys
`index`	Unknown	PK
`podcast_id`	Unknown	PKFK
`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	PKFK
`value`	Unknown