Star Wars database

A compact English-language SQLite database containing people, films, planets, species, starships, and vehicles from the Star Wars universe. Four junction tables represent film appearances and pilot assignments. Primary and foreign keys make the schema useful for joins, grouping, and many-to-many query exercises.

Source and rights notice: The data comes from the SWAPI fixtures at commit 5413ffe; the relational model is based on starwarsdb v0.1.3. SWAPI material is redistributed under the BSD 3-Clause License and starwarsdb material under the MIT License. Star Wars and associated names are copyright Lucasfilm Ltd.; those rights are not covered by the open-source licenses. No affiliation with or endorsement by Lucasfilm, Disney, SWAPI, or starwarsdb is claimed.

Authors: Garrick Aden-Buie, Paul Hallett, Juriy Bura, SWAPI contributors