Actors
id | firstName | lastName | birthDate |
1 | John | Doe | 1980-01-01 |
2 | Jane | Smith | 1978-02-02 |
Episodes
id | title | airdate | runtime | sitcom_id | drama_id |
| | | | (→ Sitcoms.id) | (→ Dramas.id) |
1 | The Big Episode | 2023-01-01 | 30 | 1 | NULL |
2 | Another Great Show | 2023-01-02 | 60 | 2 | NULL |
Ratings
id | score | episode_id |
| | (→ Episodes.id) |
1 | 8.5 | 1 |
2 | 7.5 | 2 |
Sitcoms
id | name | number_of_seasons | genre | network | start_year | end_year | creator | actor_id |
| | | | | | | | (→ Actors.id) |
1 | Friends | 5 | Comedy | NBC | 1994 | 2004 | Martin Scorsese | 1 |
2 | How I Met Your Mother | 9 | Comedy | CBS | 2005 | 2014 | Baz Luhrmann | 2 |
Dramas
id | name | number_of_seasons | genre | network | start_year | end_year | director | actor_id |
| | | | | | | | (→ Actors.id) |
1 | Breaking Bad | 5 | Crime | AMC | 2008 | 2013 | Vince Gilligan | 1 |
2 | Better Call Saul | 6 | Crime | AMC | 2015 | 2022 | Peter Gould | 2 |