Re: Re: Photo Album Schema
| From: | Hugh Bothwell | Date: | Fri, 24 Aug 2001 01:02:05 +0000 |
| Subject: | Re: Re: Photo Album Schema | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11763@lists.php.net to get a copy of this message | ||
"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.