I'm having some trouble normalizing my database.
I think everything is where it's supposed to be, but I'm not entirely sure.
I'm making a MMORPG browser game. Meaning I will have a lot of players.
There will be diffrent places in my game, a player can have a storage in each location. In that storage a player can store items, a player can also have items in his backback or items equipped. Items can also be moved between location or equipped/unequipped, stored/unstored, ...
Each location has a limited capacity of items it can hold.
There are 3 main diffrent types of items, weapons, armor and other items.
Weapons have 2 types, 1 hand and 2 handed.
Armor has quite a few types, head, body, hands, feet, ...
other items don't have types, just names
So this is what I have:
table Items
itemNumber (unique value and primary key)
playerNumber (the unique number of the player)
itemName (the name of the item)
itemType (weapon+type/armor+type/other)
itemPlace (backpack/equipped/location)
itemSize (the size of the item)
itemQuantity (how many of the item the player has)
table Armor
itemNumber
itemDefense
table Weapons
itemNumber
itemMinimumDamage
itemMaximumDamage
itemSpeed
itemRange
itemLevel