Re: Photo Album Schema
| From: | tatare | Date: | Tue, 21 Aug 2001 20:55:08 +0000 |
| Subject: | Re: Photo Album Schema | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11628@lists.php.net to get a copy of this message | ||
I'd rather do it like this (but I'm not sure it's ok...)
table 1
> -userid (primary key)
> -username
> -password
> -album_title
> -creation_date
table 2
> -photoid (primary key)
> -photo (jpg or gif)
> -date
> -photo_title
> -description (limited length)
table 3
> -userid (primary key)
> -photoid (primary key)
reguards.
tatare,
http://www.memoroo.fr.st
(not already available in english - could anyone help me to translate it ?)
Jeff Oien <jeff@webdesigns1.com> a écrit dans le message :
PGEBKOPJJHHICHGDKCCIOEPBDAAA.jeff@webdesigns1.com...
> I want to make a photo album that will have users who sign up
> to create an album and then have the albums open to the public.
> I was thinking of doing it like this but I've never done a relational
> database before so if anyone thinks of anything I should change
> please let me know. Thanks.
> Jeff Oien
>
> Table1:
> -username
> -password
> -album_title
> -creation_date
> -id
>
> Table2:
> -id (from Table1)
> -photo (jpg or gif)
> -date
> -photo_title
> -description (limited length)