# Buzzsprout schema ERD

Table and field reference for the Fivetran Buzzsprout connector.

## Table & Field Reference

### episode

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| podcast_id | Unknown | FK |
| artist | Unknown |  |
| artwork_url | Unknown |  |
| audio_url | Unknown |  |
| custom_url | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| episode_number | Unknown |  |
| episode_type | Unknown |  |
| explicit | Unknown |  |
| guid | Unknown |  |
| hq | Unknown |  |
| inactive_at | Unknown |  |
| magic_mastering | Unknown |  |
| private | Unknown |  |
| published_at | Unknown |  |
| season_number | Unknown |  |
| summary | Unknown |  |
| tag | Unknown |  |
| title | Unknown |  |
| total_plays | Unknown |  |

### podcast

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| artwork_url | Unknown |  |
| author | Unknown |  |
| background_url | Unknown |  |
| contact_email | Unknown |  |
| description | Unknown |  |
| explicit | Unknown |  |
| keyword | Unknown |  |
| language | Unknown |  |
| main_category | Unknown |  |
| main_category_2 | Unknown |  |
| main_category_3 | Unknown |  |
| sub_category | Unknown |  |
| sub_category_2 | Unknown |  |
| sub_category_3 | Unknown |  |
| timezone | Unknown |  |
| title | Unknown |  |
| website_address | Unknown |  |

## Relationships

- episode(podcast_id) → podcast(id)