Game Database design help

[thorus]

Yeah I know there are plenty out there already but I'm starting one that will use a database to store all of the data relating to different components (systems, emulators, roms).  This front end will not need to read the directory every time it needs to refresh data instead relying on the database to keep the front end up to date.  That is just a two sentence idea of what I want to do with my new front end, but right now I'm working on the database structure and was hoping to get some feedback from the community about what I'm missing or implimenting wrong (database wise) with my current database design.  To take a look at the current database design you can find it at the database page at the EmuFE website.

I hope to put up a wiki type settup to allow for population of game data such as images, videos, publisher, year produced and so on.  But before I can do that I need to make the database design solid and pretty final (I don't want to have to convert data too much). 

[thorus]

Sorry about that guys as soon as press post my web host's power goes out and their generator catches on fire.  The page is back up so if you want to check it out take a look.

[thorus]

I have updated the database design again and hope to have alpha version of the GameWiki available by the end of the holiday season.  I didn't get much response last time posting but I'm still gonna try again.  What I'm looking for is a critique of the database design and volunteers to moderate systems for the gamewiki.

The changes to the database design modified the way that metadata is stored allowing for simpler queries and view. Also titles have lost their association with a system, to instead be assigned to the roms (although I didn't notice until after posting that I hadn't set up that new link, so it will be shown in the next version). This new structure will allow for titles to span systems, such as Super Street Fighter would be for Super Nintendo, Sega Genesis and Arcade (MAME). But this database is definitely not final so Please do let me know of any suggestions. For instance I haven't even begun the design for the controller layout (this is primarily for arcade games but can be very useful for front ends and for re-assigning keys permanently by game).  If you are confused by the ER diagram ask questions I'd be more then happy to clarify it.