What's the best SQL scheme for this project?

php, sql

Solution

Definitely not all in one. If you are uploading media then I would create a table of all media:

Media_table: ID | MediaPath | ETC

Photos_table : MediaID | Picture_Type | Picture_Width | Picture_height

Videos_table : MediaID | Duration | Codec

Sounds_table : MediaID | Bitrate | Duration | Codec

Look into database normalization.

Problem

i want to make a php app that let people submit photos/videos/sounds Now, everything uploaded a record will be added to SQL database with file infos in this way: ``` Photos_table : File_Name | Picture_Type | Picture_Width | Picture_height Videos_table : File_Name | Duration | Codec Sounds_table : File_Name | Bitrate | Duration | Codec ``` The App will displays all recent items of all kinds. Is it good to do like the previous scheme, or making all infos in ONE table like this : ``` File_Name | Picture_Type | Picture_Width | Picture_height | Duration | Codec | Bitrate ``` I mean what's the fastest way to gather the infos, i just think the first scheme is more organized than the last one. Thanks

Original source