Xtremer360 Posted May 20, 2011 Share Posted May 20, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/237016-db-structure/ Share on other sites More sharing options...
gizmola Posted May 20, 2011 Share Posted May 20, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/237016-db-structure/#findComment-1218280 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.