Structure Question
| From: | Jordan Elver | Date: | Tue, 27 Mar 2001 12:37:54 +0000 |
| Subject: | Structure Question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7866@lists.php.net to get a copy of this message | ||
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