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:[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]

Reply via email to