title: Foreign Key naming scheme
body: <p>I'm just getting started working with foreign keys for the first time and I'm wondering if there's a standard naming scheme to use for them?</p>
  
  <p>Given these tables:</p>
  
  <pre><code>task (id, userid, title)
  note (id, taskid, userid, note);
  user (id, name)
  </code></pre>
  
  <p>Where Tasks have Notes, Tasks are owned by Users, and Users author Notes.</p>
  
  <p>How would the three foreign keys be named in this situation? Or alternatively, <em>does it even matter at all</em>?</p>
  
  <p><em>Update</em>: This question is about foreign key names, not field names!</p>