title: Best way to store User points system in database
body: <p>I am currently working on a small app where users accrue points by completing tasks. What I would like is some advise on the best way to design my database tables. In some ways the system is similar to SO, users complete tasks (on SO thy answer questions) and then their point a balance is updated.</p>
  
  <p>I currently have a users table that stores the usual user information, but don't know how to take it forward. </p>
  
  <p>Am I best to have a points table  (user has many points) and then add user_id and points amount; then when querying a users points, pull out all points with a given user_id and sum them?</p>
  
  <p>Is there a more efficient way of doing this?</p>
  
  <p>Thanks,</p>
  
  <p>Jack</p>