title: Should I be linking these tables together?
body: <p>I am not sure what to do for these 2 tables. One is a notes table at the "company" level.</p>
  
  <p>However one of the fields is to specify which Employee you talked to. I am not sure if this Notes table should have reference back to the Employee or if it should just be a text field with their name in it.</p>
  
  <pre><code>NotesTable
  id - pk
  notes - nvarchar(max)
  EmployeeId 
  or
  (EmployeeName) - nvarchar(200)
  
  EmployeeTable
  id - pk
  firstname 
  lastname
  etc
  </code></pre>
  
  <p>The reason why I am not sure is if, I would put a hard delete(ie they can remove employees from their company). This relationship would be lost.</p>
  
  <p>The only way around that would be to do a soft delete. </p>
  
  <p>Is soft deletes the better way to go? </p>