DB structure

[Xtremer360]

Curious to know if the following tables and the fields look okay. Everything I'm sure is self explained.

 

table: awards

fields: id, award_type, award_name, award_description, status_id, creator_id, date_created

 

table: awards_history

fields: id, award_id, winner_id, status_id

 

table: award_shows

fields: id, award_show_date, status_id, total_votes, date_voting_expires, is_voting_closed, creator_id, date_created

 

table: award_show_nominees

fields: id, award_show_id, award_id, nominee_id, nominee_votes

 

table: award_show_nominee_losers

fields: id, award_show_id, award_id,nominee_id

[gizmola]

I'd suggest you get http://www.mysql.com/products/workbench/ and use the designer to design your databases. 

 

I personally would not have a table for nominee losers.. just have a column that indicates won or lost in award_show_nominees.