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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
