I want to create a system where the user can be ranked by several different factors.
For example, the user competes in the following categories
- Wins
- Points
I need to know what the position of the ranking in each category last week and today.
What is the best way to do this:
- Creating a table for each category (userWins and userPoints), and update as needed?
- Create a table with columns where I can tell that this line is part of a category?
On each approach, how do I update and sort the rank?
Imagine this scenario even though I may have 20 different categories.