| Subject | How do you name your foreign key column? |
|---|---|
| Author | |
| Post date | 2014-12-18T14:59:38Z |
Hi guys,
in our database I see two naming conventions for foreign key columns:
1.
<SOMETHING>_ID
2.
ID_<SOMETHING>
in our database I see two naming conventions for foreign key columns:
1.
<SOMETHING>_ID
2.
ID_<SOMETHING>
which one do you use and why?
I see that in system tables the first convention is used (f.e. MON$TRANSACTION_ID, MON$ATTACHMENT_ID)
Thanks for your opinion.