Hello! There are things (Sword, Shield, Glove), for example, one sword can give a block, but not the other, and the shield does not cause damage at all. How, for speed reasons, to break this data in a table: Like this:

Table of things-> id | name | damage | armor | block | .... | .....

Or so

Table of things-> id | name

Table of characteristics-> id | id_things | action | value

Please advise

  • The second option is useful if the characteristics are constantly added. if the list of characteristics is fixed, then one table is more convenient. - Yura Ivanov

1 answer 1

id stackable , dmg_min1 , spellcategorycooldown_1 spellcategorycooldown_1 , spellid_2 , spelltrigger_2 , spellcharges_2 , spellppmRate_2 , spellcooldown_2 , spellcategory_2 , spellcategorycooldown_2 , spellid_3 , spelltrigger_3 , spellcharges_3 , spellppmRate_3 , spellcooldown_3 , spellcategory_3 , spellcategorycooldown_3 , spellid_4 , spelltrigger_4 , spellcharges_4 , spellppmRate_4 , spellcooldown_4 , spellcategory_4 , spellcategorycooldown_4 , spellid_5 , spelltrigger_5 , spellcharges_5 , spellppmRate_5 , spellppmRate_5 , spellcooldown_5 , spellcategory_5 , spellcategorycooldown_5 , description , PageText , LanguageID , PageMaterial , startquest , lockid , Material , sheath , RandomProperty , RandomSuffix , block , itemset , MaxDurability , area , BagFamily , and TotemCategory to socketColor_1 , socketContent_1 , socketColor_2 , socketColor_1 , socketContent_1 , socketColor_2 socketContent_2 , socketColor_3 , socketContent_3 , socketBonus , GemProperties , RequiredDisenchantSkill , ArmorDamageModifier , Duration , ItemLimitCategory , HolidayId , ScriptName , DisenchantID , FoodType , minMoneyLoot minMoneyLoot , maxMoneyLoot , WDBVerified

For example. The data stored in the table of game servers WoW. Use the first option, do not pervert over the data.