I have a quick question about table field separation (This is for a combat portion of a text based game). Currently I have a table for abilities, attacks, monsters, battles, and battle monsters (which stores the monsters for the specific battle the player is in). Since monsters may be able to have more than one special attack or ability, would it be best to create another table for the monsters in battle abilities (IE: battleID, monster, ability), or just comma separate the abilities they have in the battle monsters table( IE: abilities(1, 2, 3, ...)? I'm guessing best practice is a new table, but for something that may have few values, I wasn't sure if it would be necessary.
Thanks for your time, and nice to be back on here!