# Simplecast schema ERD

Table and field reference for the Fivetran Simplecast connector.

## 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 | PK, FK |
| 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 | PK, FK |
| href | Unknown |  |
| total | Unknown |  |

### listener_analytics

| Column | Type | Keys |
| --- | --- | --- |
| interval | Unknown | PK |
| podcast_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| label_name | Unknown |  |

### podcast_current_user_permission_app_key

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

### podcast_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| podcast_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- location(episode_id) → episode(id)
- browser(podcast_id) → podcast(id)
- application(podcast_id) → podcast(id)
- author(podcast_author_id) → podcast_author(id)
- last_seven(podcast_id) → podcast(id)
- speed(episode_id) → episode(id)
- hours_listened(podcast_id) → podcast(id)
- listener_analytics(podcast_id) → podcast(id)
- time_of_week(podcast_id) → podcast(id)
- listener(podcast_id) → podcast(id)
- category_subcategories_collection(_fivetran_id) → category(_fivetran_id)
- listening_method(podcast_id) → podcast(id)
- podcast_keyword(podcast_id) → podcast(id)
- operating_system(podcast_id) → podcast(id)
- average_completion(episode_id) → episode(id)
- top_ten(season_id) → podcast_season(number)
- top_ten(podcast_id) → podcast(id)
- podcast_category_collection(podcast_category_id) → podcast_category(id)
- podcast_category(podcast_id) → podcast(id)
- device_class(podcast_id) → podcast(id)
- podcast_season(podcast_id) → podcast(id)
- listener_podcast(podcast_id) → podcast(id)
- marker(episode_id) → episode(id)
- episode_keyword(episode_id) → episode(id)
- episode_feed(episode_id) → episode(id)
- episode_marker(episode_id) → episode(id)
- episode_author(episode_id) → episode(id)
- episode(podcast_id) → podcast(id)
- device(podcast_id) → podcast(id)
- location_analytics(podcast_id) → podcast(id)
- embed_episode(podcast_id) → podcast(id)
- average_download(podcast_id) → podcast(id)
- network_type(podcast_id) → podcast(id)
- podcast_distribution_channel(podcast_id) → podcast(id)
- podcast_author(podcast_id) → podcast(id)
- provider(podcast_id) → podcast(id)
- web_player(podcast_id) → podcast(id)
- podcast_current_user_permission_label(podcast_id) → podcast(id)
- podcast_current_user_permission_app_key(podcast_id) → podcast(id)
- podcast_account(podcast_id) → podcast(id)
- podcast_account(podcast_account_id) → podcast(account_id)