Re: Design help and multiple values in a field

[Huu Da Tran]

I would start listing all things that can change.. like level, abilities, etc...

But for a starter, I would have:
- table `basicStats` with basic stats for each type of creature. The user would then choose what creature he wants and see what are the starting stats. This table could containt what stats changes with each level upgrade.
- table `basicAbilities` for abilities (don't know what you have in mind here).
- table `users` for users (creation date, name, etc...)
- table `userCreatures`: which user has what type creature, what level, all other stuff that changes in time.
- table `creatureAbilities` (id from `userCreatures`) and what ability it has (from `basicAbilities`) plus other stuff that changes in time.

But that is only what i understand from your description. You really need to start to write down what evolves and what should not, and al.

Hope this helps,
H.