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