mysql primary key id debate

kirk kirk at
Thu Dec 29 16:10:26 MST 2005

Myself and three other programers have been arguing (for well over an hour) 
about naming the primary key in a mysql database table.
I was wondering what other people name it.

The argument is to name it "id" or another name like "client_id".
I like client_id because then the primary key name matches the foreign key 
in another table.
My coworker likes just the name id because then he can have a base class 
called getId()
that returns the value of the id column of that table.
- Kirk 

More information about the PLUG mailing list