There are to opposing ways to name the primary key of any table.

1) Use "ID" as primary key name and table + "_ID" as foreign keys

+ Is easier to use.

2) Use table+"_ID" both in primary keys and foreign keys

+ Is easier to find the field names in code.

3) Use only table name as primary key name

- I don't think this is a good idea!

----

Maybe two patterns NoTableNameInPrimaryKeyNamePattern and TableNameInPrimaryKeyNamePattern should be
added and discussed..

----