Can you guys give my database design a quick look over? It's quite simple but I'm a beginner.
http://dl.dropbox.com/u/1735585/embeddeddatabase.png
It's for an embedded database in a game. It stores a complete list of game objects and all the sub-objects and components that make up these objects. An object can have many components of the same type, but they will have different positions (this is why I included position in the primary key).
This txt file contains a brief description of each table and some example data:
http://dl.dropbox.com/u/1735585/embeddeddatabase.txt
Thanks a lot