id | showName | hostName | network | duration |
---|---|---|---|---|
1 | MasterChef | Gordon Ramsay | FOX | 60.0 |
2 | Great British Bake Off | Mary Berry | BBC One | 60.0 |
3 | Chopped | Ted Allen | Food Network | 30.0 |
4 | Top Chef | Padma Lakshmi | Bravo | 42.0 |
5 | Hell's Kitchen | Gordon Ramsay | FOX | 45.0 |
id | showName | hostName | network | seasonCount |
---|---|---|---|---|
1 | Survivor | Jeff Probst | CBS | 41 |
2 | American Idol | Ryan Seacrest | ABC | 19 |
3 | The Voice | Carson Daly | NBC | 21 |
4 | Big Brother | Julie Chen | CBS | 23 |
5 | Dancing With The Stars | Tom Bergeron | ABC | 29 |
id | showId | score |
---|---|---|
(→ CookingShows.id) | ||
1 | 1 | 7.5 |
2 | 2 | 8.2 |
3 | 3 | 7.5 |
4 | 4 | 8.0 |
id | firstName | lastName | birthDate | nationality |
---|---|---|---|---|
1 | Gordon | Ramsay | 1966-10-08 | Scotland |
2 | Mary | Berry | 1950-04-05 | England |
3 | Ted | Allen | 1970-06-26 | United States |
4 | Padma | Lakshmi | 1970-09-01 | India |
5 | Jeff | Probst | 1961-04-13 | United States |
id | cookingShowId | realityTVShowId | actorProfileId | role |
---|---|---|---|---|
(→ CookingShows.id) | (→ RealityTVShows.id) | (→ ActorProfiles.id) | ||
1 | 1 | None | 1 | Host |
2 | None | 3 | 2 | Host |
3 | 2 | None | 3 | Co-host |
4 | None | 4 | 4 | Host |
5 | 1 | None | 5 | Guest Judge |
id | cookingShowId | realityTVShowId | episodeNumber | releaseDate | description | director | writer |
---|---|---|---|---|---|---|---|
(→ CookingShows.id) | (→ RealityTVShows.id) | ||||||
1 | 1 | None | 1 | 2021-09-20 | First episode of MasterChef Season 9. | John Smith | Jane Doe |
2 | None | 3 | 1 | 2021-09-21 | Premiere episode of Survivor Season 41. | Jim Johnson | Mike Miller |
3 | 2 | None | 1 | 2021-09-23 | Inaugural episode of Great British Bake Off Season 11. | Emily Brown | David Wilson |
4 | None | 4 | 1 | 2021-09-22 | Season opener of Big Brother Season 23. | Karen Lee | Mark Thompson |
5 | 1 | None | 1 | 2021-09-22 | Introducing contestants and challenges on Hell's Kitchen Season 20. | Paul Williams | Steve Stark |