title: What is the best way to keep changes history to database fields?
body: <p>For example I have a table which stores details about properties. Which could have owners, value etc. </p>
  
  <p>Is there a good design to keep the history of every change to owner and value. I want to do this for many tables. Kind of like an audit of the table.</p>
  
  <p>What I thought was keeping a single table with fields </p>
  
  <p><code>table_name</code>, <code>field_name</code>, <code>prev_value</code>, <code>current_val</code>, <code>time</code>, <code>user</code>.</p>
  
  <p>But it looks kind of hacky and ugly. Is there a better design?</p>
  
  <p>Thanks.</p>