I am struggling to find the best way to structure my data for a Fantasy Draft app. Here's an overview of what I'm trying to achieve;
- I want to create events based on real-life combat sports events. Each event should allow multiple games with different entry fees and prize values.
- The end user can join a game and draft 5 fighters who are competing at the event. Each fighter is given a mythical draft value and the user can not exceed their 'budget' across their 5 selections.
- I would also like to display individual fighter profiles, so users can view stats, record, etc.
- When users have entered a game, they will be added to a league table with other users in that game. Fighters are scored points based on real-life performance and users are ranked in the league based on the accumulated points of their 5 drafted fighters.
Any help would be much appreciated!