I want to build a fantasy football league or something alike,
Each week, the user selects a group of 15 players. Then, these players, once the week’s matches end, receive certain points according to certain rules (e.g. +1 point if the player scored a goal, etc.). These points are then accumulated for each player, whom are then ranked according to their total points.
Basically this is the hierarchy of the data:
User → Week → Players → Point rules
My idea would be a Bubble table with the columns User, Week, Players, (various) Point Rules. Each week, 15 new rows are created for each user (or maybe these rows are immediately created at the time the users signs in). The user selects the 15 players (one per row), and the point rules points are calculated automatically for each player through an API.
What do you think? Is this idea scalable or is there any other way to deal with this problem?