Re: Re: Photo Album Schema

"Sheridan Saint-Michel" <webmaster@foxjet.com> wrote in message news:00f601c12ca3$8bb26420$d502a8c0@swbell.net... > From: "Hugh Bothwell" <hugh_bothwell@hotmail.com> > To: <php-db@lists.php.net> > > > > "Sheridan Saint-Michel" <webmaster@foxjet.com> wrote in message > > news:03a901c12c02$c60d4640$d502a8c0@swbell.net... > > > I don't know if having multiple users associated with a single image is > > > at all beneficial, and I can see where it might cause all sorts of > > problems. > > > > > > For example, you and I both have the same image in our album (we are > > > both assciated with it in the DB). What happens when I change the > > > description? Do you change the description field, thus changing the > > > description on both our pages? Do you now have to create another entry > > > in your Image table? > > > > Just to be nitpicky: I don't see where this would be > > useful - allowing users to share/transfer pictures? - but > > it's not overly difficult either. Just split the information > > between an Image table and an ImageOwner > > table. > > He suggested a DB redesign to allow a Many to > Many relationship between users and images. > I was trying to show that there was no reason to > do so and at least one good reason not to do so =) Yes, I followed that - I'm just playing Devil's Advocate here. I would rephrase your conclusion as 'no reason to do so, but no reason not to if you really feel the need'.