14.02.2015, 22:39
Second method completely defeats the purpose of relational databases.
It is true that it is rather annoying if each house can have multiple pieces of furniture and each piece of furniture can have multiple textures. You will need to join the tables regardless. In the loading code, you may check if the current furniture id equals the last one that was loaded. If it isn't, create the object. Then apply the textures.
It is true that it is rather annoying if each house can have multiple pieces of furniture and each piece of furniture can have multiple textures. You will need to join the tables regardless. In the loading code, you may check if the current furniture id equals the last one that was loaded. If it isn't, create the object. Then apply the textures.