Photo Album Schema
| From: | Jeff Oien | Date: | Tue, 21 Aug 2001 15:11:43 +0000 |
| Subject: | Photo Album Schema | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11604@lists.php.net to get a copy of this message | ||
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)