title: Tracking changed fields without maintaining history
body: <p>I have a table named Books which contains some columns.</p>
  
  <pre><code>ColumnNames: BookId, BookName, BookDesc, xxx
  </code></pre>
  
  <p>I want to track changes for certain columns. <strong>I don't have to maintain history of old value and new value. I just want to track that value is changed or not.</strong> </p>
  
  <p>What is the best way to achieve this?</p>
  
  <p>1) Create Books table as:</p>
  
  <pre><code>ColumnNames: BookId, BookName, BookName_Changed_Flag, BookDesc, BookDesc_Changed_Flag, 
  xxx, xxx_Changed_Flag?
  </code></pre>
  
  <p>2) Create a separate table Books_Change_Log exactly like Books table but only with track change columns as:</p>
  
  <pre><code>ColumnNames: BookId, BookName_Changed_Flag, BookDesc_Changed_Flag, xxx_Changed_Flag?
  </code></pre>
  
  <p>Please advise.</p>
  
  <p>--Update--</p>
  
  <p>There are more than 20 columns in each table. And each column represents a certain element in UI. If a column value is ever changed from its original record, i need to display the UI element that represents the column value in different style. Rest of the elements should appear normal.</p>