title: MySQL Foreign Key On Delete
body: <p>I am trying to figure out relationships and deletion options.</p>
  
  <p>I have two tables, <code>User</code> and <code>UserStaff</code>, with a 1:n relationship from <code>User</code> to <code>UserStaff</code> (a user can have multiple staff members). </p>
  
  <p>When my <code>User</code> is deleted, I want to delete all of the <code>UserStaff</code> tables associated with that <code>User</code>. When my <code>UserStaff</code> is deleted, I don't want anything to happen to <code>User</code>. I understand that this is a cascading relationship, but I'm not sure which way.</p>
  
  <p>i.e. Do I select the existing foreign key in my <code>UserStaff</code> table and make it cascading, or do I create a new foreign key in <code>User</code> and set that to cascading?</p>