--- kirk <[EMAIL PROTECTED]> wrote: > 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.
I prefer client_id, both because the name matches when I use the key as a foreign key in another table, and because there are frequently multiple $x_id fields in a table, and it's useful to distinguish between them. As for having a base getID function, why not have one that knows that the primary key field is always $tablename_id? /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
