Primary Key Naming

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.

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

+ Is easier to find the field names in code.

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

---