What is the best way of constructing the tables for this? (see post)
Posted on 2014-10-14
I have different kind of medias, video, picture, audio.
They all need diffrent kind of information about them, here is a data tree to represent what the diffrents of each media has:
I have different kind of Medias; video, picture, audio.
They all need different kind of information about them; here is a data tree to represent what the difference of each media:
• Picture (if not thumbnail)
• Picture (if thumbnail)
Above described 4 separate tables to store each media type, but I find that kind of messy and unprofessional.
So you see they all have different kind of fields, a second way I thought to store them was to make a table like this:
• Media (hold all media types described above)
o MediaType (0,1,2 - depending on if it is a picture, video or audio)
o MediaInformation (all the in information that differs from each media type) - XML
Do you guys have any other solution on how to construct the table/s to contain these infomations??
Note: There will of cause be a table to contain information of who uploaded it the media and so on, but not in the 'file database/media database' itself.
Thank you - I am not very experienced in the database construction area and want it done ‘right’ and not just ‘working’.