In my eyes there are three things that need to be tracked.
Hands, which are a subset of Tables, which are a subset or Tournaments.
I've created the idea of a *tournament_registration* table that simply stores the *account_id* of the eager player and the *tournament_size* of the size of tournament they're after.
Whenever a new *account_id* is added to the *tournament_registration* table for a certain *tournament_size*, I query the table after the insert to determine if enough players have registered for a certain tournament size.
That setup seems fairly optimal.
But when it comes to seating players at a table... I am confusing myself (probably overthinking this) as to how exactly to keep track of hand progression at each table.
Any help/direction would be greatly appreciated.
Cheers!
I did try researching this of course, but any search for "poker database best practices" only turns up countless poker tracking softwares.
And unfortunately not many private poker websites talk at length about their setups.
When creating a new table randomise which Player sits where, with Dealer being a bot Player that has rules on how it plays its hand.
Keep an isActive on the Hands so you know who’s turn it is, and a sequential number so you know which order they sit in at the Table
If you focus on one Table and figure that out I think you’ll replicate it easily to a Tournament of Tables
Good luck! Sounds fun!
I made a pascal blackjack game in high school and this has brought back some fond memories of fun coding