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