I am creating a MYSQL database which keeps tabs on party game stats. in our family's biannual parties. All parties may have a flexible quantity of family people and that we play 7-10 different party games. Each game may have a flexible quantity of gamers, a flexible buy in (fake money), along with a variable quantity of those who win. Things I have to date appears excessively complicated. I must create multiple tables for every game we play. I want another perspective. Can there be an simpler way? Here's my database to date. I have only listed 3 games in order to save time.
tbl_players tbl_parties tbl_players_in_parties id id id name date parties_id name players_id tbl_teams_id_parties tbl_players_in_teams id id name players_id parties_id teams_in_parties_id
Game1 : Scavenger Search
tbl_game_scavenger tbl_scavenger_items tbl_scavenger_players id id id parties_id game_scavenger_id game_scavenger_id description item_name players_in_parties_id buyin tbl_scavenger_places tbl_scavenger_items_retrieved id id game_scavenger_id scavenger_players_id place_name scavenger_items_id value players_in_parties_id
Game2: Raffle Ticket
tbl_game_raffle tbl_raffle_prizes tbl_raffle_players id id id parties_id game_raffle_id game_raffle_id description prize_name players_in_parties_id buyin tbl_raffle_winners id game_raffle_id raffle_prizes_id raffle_players_id
Game3: Relay Race (Team)
tbl_game_relay tbl_relay_set tbl_relay_teams id id id parties_id game_relay_id game_relay_id description set_name teams_id_parties_id buyin tbl_relay_places tbl_relay_results id id game_relay_id relay_teams_id place_name time value relay_teams_id