Im workin on a site where users are allowed to pick 3 classes and 3 sub classes for each. I currentl want them to be able to change at anytime. The problem with this is that there are over 60 classes. To store their skill level at each rank would require a ton of columns for a simple user. Now this leaves my with a few options of the top of my head.
- Create all 60+ columns for the user.
- Create a table for each class and hold user ranking in each.
- Create a single table to hold the user’s ranking for each class within it.
Which would be more effective?
