Podcasters
id | name | location | years_experience |
1 | Alex Johnson | New York | 10 |
2 | Jane Doe | Los Angeles | 8 |
Shows
id | title | genre | network | audio_format | host |
| | | | | (→ Podcasters.name) |
1 | The Alex Johnson Show | Comedy | ABC | Podcast | Alex Johnson |
2 | Laughing Matters | Comedy | NBC | Podcast | Jane Doe |
3 | The Morning Rush | Talk Show | CBS Radio | Radio Show | Alex Johnson |
4 | Morning Coffee | Talk Show | Fox Radio | Radio Show | Jane Doe |
Episodes
id | show_id | episode_number | release_date | duration | description |
| (→ Shows.id) | | | | |
1 | 1 | 1 | 2023-01-01 | 60 | Episode about comedy. |
2 | 2 | 1 | 2023-01-08 | 60 | Episode about coffee. |
Guests
id | full_name | occupation | guest_on | appearance_episode_number |
| | | (→ Shows.title) | |
1 | John Smith | Actor | The Alex Johnson Show | 1 |
2 | Emily Davis | Author | Laughing Matters | 1 |
EpisodeGuests
id | episode_id | guest_id | role | appearance_duration |
| (→ Episodes.id) | (→ Guests.id) | | |
1 | 1 | 1 | Interviewee | 25 |
2 | 1 | 2 | Panelist | 25 |
Reviews
id | reviewer_name | rating | comments | show_id | review_date |
| | | | (→ Shows.id) | |
1 | Alice Brown | 5 | Great podcast! | 1 | 2024-03-07 21:13:47 |
2 | Bob White | 4 | Funny episodes. | 2 | 2024-03-07 21:13:47 |