Currently there need to be a lot of joins for relative simple things. For example when you want to get the user that created a certain character you need to join players on characters and users on players.
Some need even more joins. This will probably hurt performance and can easily be solved by adding a few more fields. For example an userId column in the character table that joins to users.id.
Currently there need to be a lot of joins for relative simple things. For example when you want to get the user that created a certain character you need to join players on characters and users on players.
Some need even more joins. This will probably hurt performance and can easily be solved by adding a few more fields. For example an userId column in the character table that joins to users.id.