law-and-order

Database Diagram for Law & Order Data

Person Person.person_id Person.name Person.birthdate Person.birth _name Person.birth_place Person.birth_region Person.birth_country Person.height_meters Person.nickname Credit Credit.episode_id Credit.person_id Credit.category Credit.Role Credit.Credited Award Award.award_id Award.organization Award.year Award.award_category Award.award Award.series Award.person_id Award.role Award.episode_id Award.result Vote Vote.episode_ID Vote.stars Vote.votes Vote.percent Keyword Keyword.episode_id Keyword.keyword Episode Episode.episode_id Episode.series Episode.season Episode.episode Episode.number_in_series Episode.title Episode.summary Episode.air_date Episode.episode_image Episode.rating Episode.votes Vote JOIN Episode ON Vote.episode_ID = Episode.episode_id Episode JOIN Credit ON Episode.episode_id = Credit.episode_id Episode JOIN Keyword ON Episode.episode_id = Keyword.episode_id Episode JOIN Award ON Episode.episode_id = Award.episode_id Credit JOIN Person ON Credit.person_id = Person.person_id Award JOIN Person ON Award.person_id = Person.person_id