AW: [PHP-DB] Structure Question

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