| id | name | |
|---|---|---|
| 1 | John Doe | john@example.com |
| 2 | Jane Smith | jane@example.com |
| id | stationName | location |
|---|---|---|
| 1 | KQED FM | San Francisco |
| 2 | WBEZ Chicago | Chicago |
| 3 | WLRN Miami | Miami |
| 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 |
| 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 |
| 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 |
| 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 |