I am building a simple browser-based text RPG (Role Playing Game) and my first step is to design the database. I have checked some samples and articles about the subject and I wanted to ask your opinions as well.
Basically, I will have the following tables:
Each character will have some skills and items in the game. I can think of two options for designing the database as below. Can you please tell me which one would you prefer and why?
1. Create separate tables such as character_items, character_skills?
2. Create a single column for items/skills in the character table and store the info by serializing it.