## TelevisionShows

id | title | year | network | genre
--- | --- | --- | --- | ---
|  |  |  | (→ Genres.name)
1 | The Big Bang Theory | 2007 | CBS | Sitcom
2 | Friends | 1994 | NBC | Sitcom
3 | Breaking Bad | 2008 | AMC | Drama
4 | Game Of Thrones | 2011 | HBO | Drama

## Genres

name
Sitcom
Drama

## Seasons

id | show_id | number_of_seasons | release_year
--- | --- | --- | ---
| (→ TelevisionShows.id) |  |
1 | 1 | 5 | 2008
2 | 2 | 10 | 1994
3 | 3 | 5 | 2009
4 | 4 | 8 | 2011

## Episodes

id | season_id | episode_number | title | run_time | airdate
--- | --- | --- | --- | --- | ---
| (→ Seasons.id) |  |  |  |
1 | 1 | 1 | Pilot | 39mins | 2007-09-24
2 | 2 | 1 | The Pilot | 22mins | 1994-09-22
3 | 3 | 1 | Pilot | 46mins | 2009-01-20
4 | 4 | 1 | Winter Is Coming | 55mins | 2011-04-17