title: Simple database considerations and CakePHP
body: <p>I'm thinking of creating a simple game in order to help get my head around database design and CakePHP. The reasoning is that the game should ultimately be extendable, something that should be provided by MVC.</p>
  
  <p>I'm struggling to get my head around a correct database design however, for example:</p>
  
  <p>I have a table for users, just containing the usual details etc. </p>
  
  <p>Each user in the game will have an armoury (storing weapons) and so my understanding is that a User and Armoury tables share a 'has' relationship. </p>
  
  <p>My question is where should the foreign key be placed? If at all? Should I have a Armoury foreign key in the User table or a User foreign key in the Armoury table. Or should I have an entirely different table for the relationship between the two?</p>
  
  <p>Also, regardless of approach, how do I then relate the structure of the database within CakePHP?</p>