Re: AW: [PHP-DB] Structure Question

Thanks for your advice. I think I'll go with that. Cheers, Jord On Tuesday 27 March 2001 15:10, you wrote: > I think you should store all files in a table with an extra table with the > filetypes (like you suggest in the end of your mail)!! In my opinion this > is a well designed database modell, 'cause you have only one table (instead > of 10 or twelve depending on the count of your datatypes), but you are able > to select over the filetyp criteria!! > > Stefan Siefert > > -----Ursprüngliche Nachricht----- > Von: Jordan Elver [mailto:jjelver@worldsites.net] > Gesendet: Dienstag, 27. März 2001 14:38 > An: PHP Database Mailing List > Betreff: [PHP-DB] Structure Question > > > Hi, > I want to keep filenames of different kinds of media(real sudio, qt, mp3) > for > articles in a db table. Would it be best to store each kind of media in a > different table like one table for real audio, one for quicktime, one for > mp3. Or, would it better to store them all in the same table but with > another > table telling me what kind of file it is? > > Like: > > media table > -------------------- > id | name | filename | type_id > > media types > -------------------- > type_id | name > > Any ideas folks? > > Cheers, > > Jord > > -- > 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