Database Schema

TODO An ER diagram will be added in the near future.

The basic idea of the database is the following:

There are two main parts of the database.

The first one is the "admin" part. It is a series of a few tables which describe the roulettes in detail - the elements, the type of the elements, the coefitients and so on. This part of the database is relatively static in the sense that it should be updated when a player isn't active and that new games should come a lot less frequently than players should be playing.

The second part of the database is the part of the schema which deals with the players and the gameplay.

The central database here is account_transactions. All the notable actions of the player, all the bets and wins are there. Also, this is the table which enables certain behavior such as being able to save the game, being able to reverse turns and so on. The other tables of this section - accounts, wallets, currencies are just there to supply the needed information for the account_transactions.