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 |
name |
---|
Sitcom |
Drama |
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 |
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 |