- The GW universe consists of a large number of sun system.
- Every sun system has x,y,z-coordinates in the universe.
- Sun systems will be generated procedurally.
- id [INT, PRIMARY KEY, AUTO_INCREMENT]
- name [VARCHAR/20]
- x,y,z [INT]: 3d coordinates of the sun systems
- Number of planets: SELECT COUNT(id) FROM planets WHERE fk_sun_system = sun_system.id
- Number of planets for <Faction>: SELECT( SELECT winning_faction FROM battles WHERE fk_planet = planets.id ORDER BY ended_at DESC LIMIT 1 ) FROM planets WHERE fk_sun_system = sun_systems.id