# Browser Game Database structure

users
id
email
userlevel

characters
id
userid
level
strength
exp
max_exp

map
id
x
y


This is what I have so far. I want to be able to implement and put different NPC's on my map location. I am thinking of some npc_entities table, would that be a good approach? And then I would have a npc_list table with details as how much damage, level, etc the NPC is.

Give me some ideas with the map, map entities, npc how I can structure it?

• Are you starting your game with the DB-design? – bummzack Nov 14 '11 at 8:24
• Yeah, actually. – John Svensson Nov 14 '11 at 8:44
• @JohnSvensson you are not writing business software - you are writing a game; don't go schema-first. However, if you want a good example of a game DB look no further than the MangOS one. – Jonathan Dickinson Nov 14 '11 at 11:54