studio_id | name | founded_year |
---|---|---|
1 | Warner Bros. | 2017 |
2 | Disney | 1938 |
3 | Netflix | 1997 |
4 | Amazon Prime Video | 2006 |
5 | Hulu | 2007 |
address_id | street | city | state | country |
---|---|---|---|---|
1 | 123 Sunset Blvd | Los Angeles | CA | USA |
2 | 456 Central Ave | New York | NY | USA |
3 | 789 Ocean Dr | Miami Beach | FL | USA |
4 | 1314 S Michigan Ave | Chicago | IL | USA |
5 | 901 Main St | Kansas City | MO | USA |
podcast_id | title | description | release_date | studio_id | address_id |
---|---|---|---|---|---|
(→ Studio.studio_id) | (→ Address.address_id) | ||||
1 | The Morning Show | A daily news and talk show with interviews and reviews of movies, books, music, television shows, etc.. | 2021-01-01 | 1 | 1 |
2 | Tech Talk Today | Daily podcast about technology news and events | 2021-01-01 | 2 | 2 |
3 | Breaking Bad | TV series recap and discussion podcast | 2021-01-01 | 3 | 3 |
4 | Late Night With Stephen Colbert | Comedy commentary on current events and pop culture | 2021-01-01 | 4 | 4 |
5 | True Crime Garage | Investigating true crime stories from around the world | 2021-01-01 | 5 | 5 |
episode_id | number | duration | podcast_id |
---|---|---|---|
(→ Podcast.podcast_id) | |||
1 | 1 | 01:30:00 | 1 |
2 | 2 | 01:00:00 | 2 |
3 | 3 | 01:30:00 | 3 |
4 | 4 | 01:00:00 | 4 |
5 | 5 | 01:30:00 | 5 |
reviewer_id | username | |
---|---|---|
1 | JaneDoe | jane@example.com |
2 | JohnSmith | john@example.com |
3 | AliceBrown | alice@example.com |
4 | RobertWhite | robert@example.com |
5 | DavidBlack | david@example.com |
review_id | rating | comment | episode_id | reviewer_id |
---|---|---|---|---|
(→ Episode.episode_id) | (→ Reviewer.reviewer_id) | |||
1 | 5 | Great episode! Very informative and engaging. | 1 | 1 |
2 | 4 | Interesting topic but could have been better presented. | 2 | 2 |
3 | 5 | This is my favorite podcast so far. | 3 | 3 |
4 | 3 | Could be a bit longer to cover all topics. | 4 | 4 |
5 | 4 | Very interesting episodes, looking forward to next one. | 5 | 5 |