On Thu, 29 Dec 2005, Jeff Schroeder wrote:
Personally, I always have a column in each table called "id", and then
if I'm using it as a foreign key in another table, I reference it as,
e.g., "client_id".
I do the same thing. I like it because in joins I can do:
SELECT * FROM client,foo WHERE client.id=foo.client_id
whereas
SELECT * FROM client,foo WHERE client.client_id=foo.client_id
just grates on my nerves. (I hate the "client.client_id". Yuck.)
~ Ross
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
