[firebird-support] How do you name your foreign key column?

Hi guys, 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.

Re: [firebird-support] How do you name your foreign key column?

On 18-12-2014 15:59, brucedickin...@wp.pl [firebird-support] wrote: Hi guys, 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.