I have been at this for a while now and still can’t seem to get my head wrapped around the best way to build the database for my site.
I am building a tournament bracket site.
64 Team bracket Double elimination = 127 games
Each game can have 15 plus fields of data = 1905+ total fields in Data Table
- View Tournament
- Run/Edit tournament in progress
- Search/display for data by (Player/tournament)
I’m a little numb thinking I need to create almost 2000 fields of data and then correctly place them on a page where I view and run tournaments. Not to mention pull that data out to search and display like #3 above
Any guidance or source I can read about this type of structure.
These type of site exist to run tournaments, so I know it is possible. I just need help figuring out the most efficient way to build the Database so I don’t go creating 2000 plus Fields and then find out there is a better way.
Possible Fields for 1 Game
Player 1 (user)
Player 2 (user)
Player 1 Race (#)
Player 2 Race (#)
Player 1 Score (#)
Player 2 Score (#)
Game 1 Winner (User)
Game 1 Loser (User)
Game 1 Lag Winner
Game 1 Start time
Game 1 End time
Game 1 Table #
Game 1 Scheduled Time
Wondering if there is a way to use the New Options Sets to make more efficient