<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>

How about
```
FK_TABLENAME_COLUMNNAME
```
?
K
eep
I
t
S
imple
S
tupid whenever possible.