simpsons

Database Diagram for Simpsons Script Data

simpsons_characters simpsons_characters.id simpsons_characters.name simpsons_characters.normalized_name simpsons_characters.gender simpsons_script_lines simpsons_script_lines.id simpsons_script_lines.episode_id simpsons_script_lines.number simpsons_script_lines.raw_text simpsons_script_lines.timestamp_in_ms simpsons_script_lines.speaking_line simpsons_script_lines.character_id simpsons_script_lines.location_id simpsons_script_lines.raw_character_text simpsons_script_lines.raw_location_text simpsons_script_lines.spoken_words simpsons_script_lines.normalized_text simpsons_script_lines.word_count simpsons_Locations simpsons_Locations.id simpsons_Locations.name simpsons_Locations.normalized_name simpsons_Episodes simpsons_Episodes.id simpsons_Episodes.image_url simpsons_Episodes.imdb_rating simpsons_Episodes.imdb_votes simpsons_Episodes.number_in_season simpsons_Episodes.number_in_series simpsons_Episodes.original_air_date simpsons_Episodes.original_air_year simpsons_Episodes.production_code simpsons_Episodes.season simpsons_Episodes.title simpsons_Episodes.us_viewers_in_millions simpsons_Episodes.video_url simpsons_Episodes.views simpsons_characters JOIN simpsons_script_lines ON simpsons_characters.id = simpsons_script_lines.character_id simpsons_Locations JOIN simpsons_script_lines ON simpsons_Locations.id = simpsons_script_lines.location_id simpsons_Episodes JOIN simpsons_script_lines ON simpsons_Episodes.id = simpsons_script_lines.episode_id