Re: Stupid Database Tricks
Date: 22 May 2007 20:59:20 -0700
Message-ID: <1179892760.282700.315160_at_q66g2000hsg.googlegroups.com>
On May 22, 1:48 pm, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
>
> Every table will have a numeric id column, and this column will be the
> primary key.
I don't know why, exactly, since it's not like it's the worst one mentioned, but that one DRIVES ME CRAZY!
I hear people say this, and I want to say oh, I see: you're just the stupidest freaking idiot ever, is that it? Of course instead I say something about that being contraindicated.
My extra special favorite: there's a table that's *just* two foreign keys to two different tables; a basic join table. The pair (key1, key2) is unique of course. And oh yeah, we have to add an additional numeric primary key.
Grrrrr.....
> For performance, we enforce integrity in the application.
Aiiieeee!!!
Marshall Received on Wed May 23 2007 - 05:59:20 CEST