On Thursday 07 April 2005 14:48, rudy wrote: > > ... so all this is gonna sit on a shelf for a while... > > good thing i didn't jump in, eh > > > dave, your design was good except for this -- > > table interactions: > +-----+----------+----------+ > > | id | user_id | dept_id | > > +-----+----------+----------+ > > | 1 | 23 | 1 | > | 2 | 17 | 2 | > | 3 | 17 | 3 | > | 4 | 19 | 1 | > | 5 | 4 | 4 | > > +-----+----------+----------+ > > this table does not need and should not have its own id column
Ah - I've got myself into the habit of always having an id column for every table, so that I know I can always refer to each individual row easily. I guess in this case it's not particularly important. Glad the rest was OK though :-) Cheers Dave P ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
