Results 1 to 8 of 8
Thread: Serializing or separate tables?
Aug 16, 2012, 01:55 #1
- Join Date
- Nov 2009
- 0 Post(s)
- 0 Thread(s)
Serializing or separate tables?
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.