My focus this week is on the ship's cargo hold. I'm still relatively inexperienced at database design, so I originally had a table that consisted only of the asset ID and the cargo ID. This was a waste of course, so that table had now been dropped and items will be installed on an asset (ship, colony, ground party), or assigned as cargo to assets.
In other news, Jake the wonder artist has sent over the Water planet tile sets and it looks insanely great, just like the others he's done so far. Next up he's working on the asteroid tile set and I'm anxiously awaiting the outcome. The great thing about Jake's artwork is that it gives me other ideas for the game, and has directly influenced the game design already.
Once I get the cargo areas set up, I'll add the ability for ships to transfer cargo between ships and colonies owned by the same player. This will set things up so that I can add the Scoop Gas Giant action for ships, and will take me one step closer to implementing mining deposits on planets and asteroids.