I am working on the Schema for an Online video game.
Among all the DB tables are two specific tables called: heroes and skills.
The Heroes table will contain the general make of a user's playable character.
Heroes will be something like:
The Skills table will contain the definitions for all possible skills in the game.
The Skills table will be something like:
Every character will have a max of 10 unqiue skill, and then a possible 10 common skills for a constant max of 20 skills per hero.
Would it be better to Store the hero skill information on the hero table like:
hero_skill_0, hero_skill_1, hero_skill_2, ..., hero_skill_9
hero_common_skill_0, hero_common_skill_1, hero_common_skill_2, ..., hero_common_skill_9
Have a third table called: HeroSkills which is simply something like:
I believe that having a 3rd table would be best practice... but my concern is in the 0.000001% chance the game gets big. With a lot of players the HeroSkills table will be 20 times larger then the heroes table, but will also be getting alot more transactions.