Re: Re: Photo Album Schema

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 =) Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com ----- Original Message ----- From: "Hugh Bothwell" <hugh_bothwell@hotmail.com> To: <php-db@lists.php.net> Sent: Thursday, August 23, 2001 8:02 PM Subject: Re: [PHP-DB] Re: Photo Album Schema > > "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. > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net