I have to create a model that stores gameplay controls for games on several platforms. I am having trouble finding the right approach.

  1. Controller buttons are different on different systems (Wii, Xbox 360, PS3 have their own specific controller buttons.)
  2. Some games are actually several games packaged as one; this means a single product can have several controls depending on the game being played.
  3. Gameplay controls for many games change depending on your in-game activity (driving/walking/flying, etc...)
  4. It's not sufficient to just store button functions since most games have several special moves that require a combination of buttons.

How would you approach this problem? Honestly, I don't know where to start!

Update: Many thanks to everyone for your thoughtful, and very helpful input. I am yet to choose and answer because, in the end, it was decided that this feature is not worth the effort. Many thanks again.

sql database-design data-modeling
Edit
Report