How do I update a column based on other columns in the same row <p>Lets say I have a table called User. It has three columns called <code>Score1</code>, <code>Score2</code> and <code>Score3</code>.</p> <p><code>Score1</code> and <code>Score2</code> rely on the user inputting data but I want <code>Score3</code> to be the sum of <code>Score1</code> and <code>Score2</code>. How do I implement this? Is the logic for this rendered in the model. If so what does it look like? Or is it something that gets set up in during a migration when specifying the database structure?</p>