I'm not used to using this type of database, so I need some confirmation on the preferred structure.
Let's say you have the Universe, which consists of an number of galaxies, which consists of a number of solar systems, which consists of a number of planets, which are owned by players.
I could go the basic way with 4 different tables, like:
Universe
id_universe
Galaxy
id_galaxy
id_universe
SolarSystem
id_solarSystem
id_galaxy
Planet
id_planet
id_solarSystem
But considering this database can store objects and arrays, I could make it with 1 table (see image attachment):
Table Universe has an array called galaxies, which contains all its galaxies, which each contains an array called solarSystems, which contains all its solar systems, which each contains an array called planets, which contains all its planets. See attached image.
I would say it's better to split it up into multiple tables and use the ids, as you would in a normal database. But is my 2nd example a serious possibility? I would expect it to crash the server, or would it work just fine? And even if it would just work fine, what would you suggest?
(by the way, feel free to laugh, I know it looks ridiculous )