[eddyvlad]

Hi guys, I am designing a database. I've done numerous database designs by trial and error and frankly, most of them don't really work very well. This time I want to get feedback / recommendation from you guys who are smarter or more experience than me so that at least I can get close to perfection this time.

Attached is my current design done in phpmyadmin. A database abstraction layer will be develop in PHP 5 to accommodate the schema. The objective of the design is to ease development and have a more readable codes.

One question that always bugs me is do you think the 'media_' prefix in every field is necessary? I've never had a good experience with schema without the prefix. Kinda troublesome to relate. But the prefix can cause a mess in the future I guess.

Example coding style to achieve :

PHP Code:

$mediaObj = new Model('media');

if($thisCat = $mediaObj->findAll('WHERE ! = ?',array('category_id',$_POST['category_id']))){
    foreach($thisCat as $index=>$media){
        $html->table->addRow();
        $html->table->column($index,'title',$media->child('property')->title);
        $html->table->column($index,'categories',$media->childs('category')->getName()->implode("\n"));    // 1 media can have multiple categories
        $html->table->column($index,'audio',$media->child('audio')->filename);
    }
}