title: storing weight in a database table
body: <p>I am playing around with learning MVC and want to create a recipe recorder application to store my recipes.</p>
  
  <p>I am using .net with Sql Server 2008 R2 however I don't think that really matters with what I am trying to do.</p>
  
  <p>I want to be able to record all of the measures I use. In my country we use metric however I want people to be able to use imperial with my application.</p>
  
  <p>How do I structure my table to cope with the differences, I was thinking of storing all of the measurements as ints and have a foreign key to store the kind of weight.</p>
  
  <p>Ideally I would like to be able to share the recipes between people and display the measurements in their preferred way. </p>
  
  <p>Is this the right kind of way</p>
  
  <pre><code>IngredientID PK
  Weight int
  TypeOfWeight int e.g. tsp=1,tbl=2,kilogram=3,pound=4,litre=5,ounce=6 etc
  UserID int 
  </code></pre>
  
  <p>Or is this way off track? Any suggestions would be great!</p>