## Podcasters

id | name | email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com

## RadioStations

id | stationName | location
--- | --- | ---
1 | KQED FM | San Francisco
2 | WBEZ Chicago | Chicago
3 | WLRN Miami | Miami

## Shows

id | title | description | podcastOrRadio | averageEpisodeLength
--- | --- | --- | --- | ---
|  |  | (→ Podcasters.id) |
1 | The Daily | News podcast by The New York Times. | 1 | 45
2 | Hardcore History | History podcast featuring stories of war and violence. | 1 | 60
3 | This American Life | Weekly radio show featuring true stories. | 0 | 45
4 | Planet Money | Financial news podcast. | 0 | 60

## Episodes

id | showId | episodeNumber | releaseDate | duration
--- | --- | --- | --- | ---
| (→ Shows.id) |  |  |
1 | 1 | 1 | 2023-01-01 | 00:58:39
2 | 1 | 2 | 2023-01-07 | 01:32:35
3 | 0 | 1 | 2023-01-14 | 00:55:23
4 | 0 | 1 | 2023-01-21 | 01:02:35

## Hosts

id | name | occupation | podcasterID | radioStationID
--- | --- | --- | --- | ---
|  |  | (→ Podcasters.id) | (→ RadioStations.id)
1 | Jacey Stern | Journalist | None | None
2 | Dan Carlin | Historian | None | None
3 | Ira Glass | Producer | None | 3
4 | Adam Davidson | Reporter | None | 4

## Listeners

id | name | favoriteHostID | preferredFormat
--- | --- | --- | ---
|  | (→ Hosts.id) |
1 | Alice Smith | 1 | 1
2 | Bob Johnson | 2 | 0
3 | Carol Williams | 3 | 1
4 | Tom Brown | 4 | 0