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