Simplecast
Explore the interactive ERD
Table & Field Reference
location
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
episode_id | Unknown | FK |
rank | Unknown | |
starts_percent | Unknown | |
starts_total | Unknown | |
url | Unknown |
browser
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
application
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
author
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_author_id | Unknown | FK |
email | Unknown | |
facebook_handle | Unknown | |
facebook_link | Unknown | |
href | Unknown | |
instagram_handle | Unknown | |
instagram_link | Unknown | |
name | Unknown | |
remove | Unknown | |
twitter_handle | Unknown | |
twitter_link | Unknown | |
update | Unknown | |
updated_at | Unknown | |
user_id | Unknown | |
website_domain | Unknown | |
website_link | Unknown | |
youtube_handle | Unknown | |
youtube_link | Unknown |
last_seven
| Column | Type | Keys |
|---|---|---|
podcast_id | Unknown | PKFK |
href | Unknown | |
total | Unknown |
speed
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
episode_id | Unknown | FK |
percentage | Unknown | |
speed | Unknown |
hours_listened
| Column | Type | Keys |
|---|---|---|
podcast_id | Unknown | PKFK |
href | Unknown | |
total | Unknown |
listener_analytics
| Column | Type | Keys |
|---|---|---|
interval | Unknown | PK |
podcast_id | Unknown | PKFK |
percents | Unknown | |
total | Unknown |
time_of_week
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
count | Unknown | |
day_of_week | Unknown | |
hour_of_day | Unknown | |
hour_of_week | Unknown | |
rank | Unknown |
listener
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
href | Unknown | |
listeners_total | Unknown | |
number | Unknown | |
published_at | Unknown | |
season_href | Unknown | |
season_number | Unknown | |
title | Unknown | |
type | Unknown |
category_subcategories_collection
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
label | Unknown | |
rss_label | Unknown | |
value | Unknown |
category
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
label | Unknown | |
rss_label | Unknown | |
value | Unknown |
listening_method
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
analytics_download
| Column | Type | Keys |
|---|---|---|
interval | Unknown | PK |
podcast_episode_id | Unknown | PK |
downloads_percent | Unknown | |
downloads_total | Unknown |
analytics_download_collection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_episode_id | Unknown | PK |
is_primary | Unknown | |
name | Unknown | |
published_at | Unknown | |
scheduled_for | Unknown | |
status | Unknown |
podcast_keyword
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
delete | Unknown | |
href | Unknown | |
value | Unknown |
operating_system
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
listen
| Column | Type | Keys |
|---|---|---|
episode_id | Unknown | PK |
interval | Unknown | PK |
downloads_percent | Unknown | |
downloads_total | Unknown |
timezone
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
common | Unknown | |
label | Unknown | |
offsets | Unknown | |
value | Unknown |
average_completion
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
episode_id | Unknown | FK |
avg_completion | Unknown | |
href | Unknown | |
seconds_played | Unknown |
top_ten
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
season_id | Unknown | FK |
count | Unknown | |
legacy_id | Unknown | |
number | Unknown | |
published_at | Unknown | |
rank | Unknown | |
season_number | Unknown | |
title | Unknown | |
type | Unknown |
podcast_category_collection
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_category_id | Unknown | FK |
href | Unknown | |
label | Unknown | |
value | Unknown |
podcast_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
created_at | Unknown | |
href | Unknown | |
label | Unknown | |
value | Unknown |
device_class
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
podcast_season
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
href | Unknown | |
number | Unknown |
listener_podcast
| Column | Type | Keys |
|---|---|---|
end_date | Unknown | PK |
start_date | Unknown | PK |
podcast_id | Unknown | PKFK |
href | Unknown | |
total | Unknown |
marker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
episode_id | Unknown | FK |
ad_limit | Unknown | |
ad_type | Unknown | |
href | Unknown | |
max_duration_millisecond | Unknown | |
name | Unknown | |
offset_millisecond | Unknown | |
offset_second | Unknown |
episode_keyword
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
episode_id | Unknown | FK |
delete | Unknown | |
href | Unknown | |
value | Unknown |
episode_feed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
episode_id | Unknown | FK |
ad_free_feed_url | Unknown | |
delete | Unknown | |
description | Unknown | |
enable_episode_number | Unknown | |
enabled | Unknown | |
enclosure_url | Unknown | |
expires_at | Unknown | |
external_feed_url | Unknown | |
feed_url | Unknown | |
has_ad_free_variant | Unknown | |
href | Unknown | |
image_url | Unknown | |
is_ad_free | Unknown | |
is_explicit | Unknown | |
is_primary | Unknown | |
name | Unknown | |
no_index | Unknown | |
preferred_bitrate | Unknown | |
publish | Unknown | |
published_at | Unknown | |
redirect_url | Unknown | |
regenerate_ad_free | Unknown | |
reimport | Unknown | |
rss_limit | Unknown | |
schedule | Unknown | |
scheduled_for | Unknown | |
status | Unknown | |
title | Unknown | |
unexpire | Unknown | |
unpublish | Unknown | |
unschedule | Unknown | |
update | Unknown |
episode_marker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
episode_id | Unknown | FK |
ad_limit | Unknown | |
ad_type | Unknown | |
href | Unknown | |
max_duration_millisecond | Unknown | |
name | Unknown | |
offset_millisecond | Unknown |
episode_author
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
episode_id | Unknown | FK |
href | Unknown | |
name | Unknown | |
remove | Unknown |
episode
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
ad_free_audio_file_url | Unknown | |
analytics_href | Unknown | |
audio_content_type | Unknown | |
audio_file_ad_free_url | Unknown | |
audio_file_delete | Unknown | |
audio_file_href | Unknown | |
audio_file_name | Unknown | |
audio_file_path | Unknown | |
audio_file_path_tc | Unknown | |
audio_file_size | Unknown | |
audio_file_url | Unknown | |
audio_href | Unknown | |
audio_status | Unknown | |
campaign_preview_href | Unknown | |
created_at | Unknown | |
custom_url | Unknown | |
dashboard_link | Unknown | |
days_since_release | Unknown | |
delete | Unknown | |
description | Unknown | |
duration | Unknown | |
enclosure_url | Unknown | |
episode_url | Unknown | |
guid | Unknown | |
href | Unknown | |
image_path | Unknown | |
image_url | Unknown | |
is_explicit | Unknown | |
is_hidden | Unknown | |
is_published | Unknown | |
long_description | Unknown | |
number | Unknown | |
publish | Unknown | |
published_at | Unknown | |
recast_color | Unknown | |
recast_image | Unknown | |
recast_image_url | Unknown | |
schedule | Unknown | |
scheduled_for | Unknown | |
season_href | Unknown | |
season_number | Unknown | |
sign_url | Unknown | |
slug | Unknown | |
sponsor_href | Unknown | |
status | Unknown | |
title | Unknown | |
token | Unknown | |
transcription | Unknown | |
type | Unknown | |
unschedule | Unknown | |
update | Unknown | |
updated_at | Unknown | |
upload_complete | Unknown | |
warning | Json | |
waveform_json | Unknown | |
waveform_pack | Unknown |
device
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
location_analytics
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
name | Unknown | |
rank | Unknown | |
state | Unknown | |
states_href | Unknown |
embed_episode
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
avg_completion_href | Unknown | |
href | Unknown | |
number | Unknown | |
published_at | Unknown | |
rank | Unknown | |
season_href | Unknown | |
season_number | Unknown | |
start | Unknown | |
stream | Unknown | |
title | Unknown | |
type | Unknown |
average_download
| Column | Type | Keys |
|---|---|---|
podcast_id | Unknown | PKFK |
href | Unknown | |
total | Unknown |
network_type
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
podcast_distribution_channel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
distribution_channel_href | Unknown | |
distribution_channel_id | Unknown | |
distribution_channel_name | Unknown | |
href | Unknown | |
url | Unknown |
podcast_author
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | FK |
href | Unknown | |
name | Unknown | |
remove | Unknown |
provider
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
end_date | Unknown | |
name | Unknown | |
rank | Unknown | |
start_date | Unknown |
web_player
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
podcast_id | Unknown | FK |
downloads_percent | Unknown | |
downloads_total | Unknown | |
name | Unknown | |
rank | Unknown |
podcast_current_user_permission_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
podcast_id | Unknown | PKFK |
label_name | Unknown |
podcast_current_user_permission_app_key
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
podcast_id | Unknown | PKFK |
app_key_name | Unknown |
podcast_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
podcast_id | Unknown | PKFK |
podcast_account_id | Unknown | FK |
account_owner_email | Unknown | |
account_owner_id | Unknown | |
account_owner_image_url | Unknown | |
account_owner_name | Unknown | |
href | Unknown | |
is_custom_plan | Unknown | |
is_default | Unknown | |
name | Unknown |
podcast
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | |
current_user_permission_app_key | Unknown | |
current_user_permission_can_create_episode | Unknown | |
current_user_permission_can_delete | Unknown | |
current_user_permission_can_edit | Unknown | |
current_user_permission_can_edit_ad_creative | Unknown | |
current_user_permission_can_edit_admin_permission | Unknown | |
current_user_permission_can_edit_advanced | Unknown | |
current_user_permission_can_edit_marker | Unknown | |
current_user_permission_can_edit_permission | Unknown | |
current_user_permission_can_publish | Unknown | |
current_user_permission_can_upload | Unknown | |
current_user_permission_can_view | Unknown | |
current_user_permission_can_view_ad_creative | Unknown | |
current_user_permission_can_view_analytics | Unknown | |
current_user_permission_can_view_episode | Unknown | |
current_user_permission_label | Unknown | |
current_user_permission_name | Unknown | |
current_user_permission_rank | Unknown | |
display_owner_email | Unknown | |
episode_count | Unknown | |
href | Unknown | |
image_url | Unknown | |
import | Unknown | |
is_migration | Unknown | |
is_pending_invitation | Unknown | |
permission_app_key | Unknown | |
permission_app_keys | Json | |
permission_can_create_episode | Unknown | |
permission_can_delete | Unknown | |
permission_can_edit | Unknown | |
permission_can_edit_ad_creative | Unknown | |
permission_can_edit_admin_permission | Unknown | |
permission_can_edit_advanced | Unknown | |
permission_can_edit_marker | Unknown | |
permission_can_edit_permission | Unknown | |
permission_can_publish | Unknown | |
permission_can_upload | Unknown | |
permission_can_view | Unknown | |
permission_can_view_ad_creative | Unknown | |
permission_can_view_analytics | Unknown | |
permission_can_view_episode | Unknown | |
permission_id | Unknown | |
permission_label | Unknown | |
permission_labels | Json | |
permission_name | Unknown | |
permission_rank | Unknown | |
status | Unknown | |
title | Unknown |