database normalization

[Yeodan]

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

[fenway]

Seems ok.