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.
Every database that I have ever created has had more than one ID
(client ID, employee ID, product ID, group ID, etc). I would find it
very confusing to not have unique keys across the entire database.
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
