## 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