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 |