title: Auto-increment ID column with natural primary key
body: <p>I am currently supplementing my table's natural primary key with a unique, auto-increment ID column.</p>
  
  <p><img src="https://i.stack.imgur.com/W0oPu.png" alt="enter image description here"></p>
  
  <p>This makes it easier to compare, update, and delete records from code (simpler WHERE clauses).</p>
  
  <p>How does this compare to using ID as the primary key with a unique key on Category/DisplayName?</p>
  
  <p>Are there any advantages to using one approach over the other?</p>