Thanks Rudy - I was hoping I had it set up right, I just wasn't sure. I really appreciate the input! Ann -------------------------------------------------- From: "r937" <rudy at r937.com> Sent: Wednesday, May 25, 2011 1:29 PM To: <thelist at lists.evolt.org> Subject: Re: [thelist] Photo Sharing Database > >> I am unsure of how to link the tables to ensure that >> each student is linked properly to their albums > > you're actually already doing it, it's done here -- > > FOREIGN KEY (album) REFERENCES Students (s_id) > >> and that the photos are linked properly to the student >> and the specific album. > > that's done here -- > > FOREIGN KEY (photo) REFERENCES Albums (a_id) > > each photo belongs to a specific album, and each album belongs to a > specific student > > >> Also, I would like to store the photos in the database, >> not a filing system. Will this create problems with archiving? > > most people advise against this because of performance issues and the > difficulty of serving the image as an image after retrieving it in your > SELECT query that pulls it out of the database > > you're actually all set up to do it -- > > image MEDIUMBLOB > > go ahead, give it a shot, there are some benefits to doing this > > -- > rudy > http://r937.com/ > > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !