simpsons-season-20

Database Diagram for Season 20 of The Simpsons

Episode Episode.episode_id Episode.season Episode.episode Episode.number_in_series Episode.title Episode.summary Episode.air_date Episode.episode_image Episode.rating Episode.votes Vote Vote.episode_id Vote.stars Vote.votes Vote.percent Keyword Keyword.episode_id Keyword.keyword Credit Credit.episode_id Credit.category Credit.person Credit.role Credit.credited Person Person.name Person.birthdate Person.birth_name Person.birth_place Person.birth_region Person.birth_country Person.height_meters Person.nickname Award Award.award_id Award.organization Award.year Award.award_category Award.award Award.episode_id Award.role Award.person Award.season Award.song Award.result Character_Award Character_Award.award_id Character_Award.character Episode JOIN Vote ON Episode.episode_id = Vote.episode_id Credit JOIN Episode ON Credit.episode_id = Episode.episode_id Credit JOIN Person ON Credit.person = Person.name Keyword JOIN Episode ON Keyword.episode_id = Episode.episode_id Award JOIN Episode ON Award.episode_id = Episode.episode_id Person JOIN Award ON Person.name = Award.person Award JOIN Character_Award ON Award.award_id = Character_Award.award_id