Table mangos.item_template
Item System

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
entry mediumint unsigned 8 0
characters.auctionhouse.item_template Defined in XML R
characters.character_gifts.entry Defined in XML R
characters.character_inventory.item_template Defined in XML R
characters.character_spell_cooldown.item Defined in XML R
characters.guild_bank_item.item_entry Defined in XML R
characters.mail_items.item_template Defined in XML R
achievement_reward.item Defined in XML R
areatrigger_teleport.required_item Defined in XML R
creature_loot_template.item Defined in XML R
disenchant_loot_template.item Defined in XML R
fishing_loot_template.item Defined in XML R
gameobject_loot_template.item Defined in XML R
item_loot_template.entry Defined in XML R
item_loot_template.item Defined in XML R
locales_item.entry Defined in XML R
milling_loot_template.entry Defined in XML R
milling_loot_template.item Defined in XML R
npc_vendor.item Defined in XML R
pickpocketing_loot_template.item Defined in XML R
playercreateinfo_item.itemid Defined in XML R
prospecting_loot_template.entry Defined in XML R
prospecting_loot_template.item Defined in XML R
reference_loot_template.item Defined in XML R
skinning_loot_template.item Defined in XML R
spell_loot_template.item Defined in XML R
class tinyint unsigned 3 0
subclass tinyint unsigned 3 0
unk0 int 10 -1
name varchar 255
displayid mediumint unsigned 8 0
Quality tinyint unsigned 3 0
Flags int unsigned 10 0
Flags2 int unsigned 10 0
BuyCount tinyint unsigned 3 1
BuyPrice int unsigned 10 0
SellPrice int unsigned 10 0
InventoryType tinyint unsigned 3 0
AllowableClass mediumint 7 -1
AllowableRace mediumint 7 -1
ItemLevel smallint unsigned 5 0
RequiredLevel tinyint unsigned 3 0
RequiredSkill smallint unsigned 5 0
RequiredSkillRank smallint unsigned 5 0
requiredspell mediumint unsigned 8 0
spell_dbc.id Defined in XML R
requiredhonorrank mediumint unsigned 8 0
RequiredCityRank mediumint unsigned 8 0
RequiredReputationFaction smallint unsigned 5 0
faction_dbc.id Defined in XML R
RequiredReputationRank smallint unsigned 5 0
maxcount smallint 5 -1
stackable smallint 5 1
ContainerSlots tinyint unsigned 3 0
StatsCount tinyint unsigned 3 0
stat_type1 tinyint unsigned 3 0
stat_value1 smallint 5 0
stat_type2 tinyint unsigned 3 0
stat_value2 smallint 5 0
stat_type3 tinyint unsigned 3 0
stat_value3 smallint 5 0
stat_type4 tinyint unsigned 3 0
stat_value4 smallint 5 0
stat_type5 tinyint unsigned 3 0
stat_value5 smallint 5 0
stat_type6 tinyint unsigned 3 0
stat_value6 smallint 5 0
stat_type7 tinyint unsigned 3 0
stat_value7 smallint 5 0
stat_type8 tinyint unsigned 3 0
stat_value8 smallint 5 0
stat_type9 tinyint unsigned 3 0
stat_value9 smallint 5 0
stat_type10 tinyint unsigned 3 0
stat_value10 smallint 5 0
ScalingStatDistribution smallint 5 0
ScalingStatValue int unsigned 10 0
dmg_min1 float 12 0
dmg_max1 float 12 0
dmg_type1 tinyint unsigned 3 0
dmg_min2 float 12 0
dmg_max2 float 12 0
dmg_type2 tinyint unsigned 3 0
armor smallint unsigned 5 0
holy_res tinyint unsigned 3 0
fire_res tinyint unsigned 3 0
nature_res tinyint unsigned 3 0
frost_res tinyint unsigned 3 0
shadow_res tinyint unsigned 3 0
arcane_res tinyint unsigned 3 0
delay smallint unsigned 5 1000
ammo_type tinyint unsigned 3 0
RangedModRange float 12 0
spellid_1 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spelltrigger_1 tinyint unsigned 3 0
spellcharges_1 smallint 5 0
spellppmRate_1 float 12 0
spellcooldown_1 int 10 -1
spellcategory_1 smallint unsigned 5 0
spellcategorycooldown_1 int 10 -1
spellid_2 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spelltrigger_2 tinyint unsigned 3 0
spellcharges_2 smallint 5 0
spellppmRate_2 float 12 0
spellcooldown_2 int 10 -1
spellcategory_2 smallint unsigned 5 0
spellcategorycooldown_2 int 10 -1
spellid_3 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spelltrigger_3 tinyint unsigned 3 0
spellcharges_3 smallint 5 0
spellppmRate_3 float 12 0
spellcooldown_3 int 10 -1
spellcategory_3 smallint unsigned 5 0
spellcategorycooldown_3 int 10 -1
spellid_4 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spelltrigger_4 tinyint unsigned 3 0
spellcharges_4 smallint 5 0
spellppmRate_4 float 12 0
spellcooldown_4 int 10 -1
spellcategory_4 smallint unsigned 5 0
spellcategorycooldown_4 int 10 -1
spellid_5 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spelltrigger_5 tinyint unsigned 3 0
spellcharges_5 smallint 5 0
spellppmRate_5 float 12 0
spellcooldown_5 int 10 -1
spellcategory_5 smallint unsigned 5 0
spellcategorycooldown_5 int 10 -1
bonding tinyint unsigned 3 0
description varchar 255
PageText mediumint unsigned 8 0
page_text.entry Defined in XML R
LanguageID tinyint unsigned 3 0
PageMaterial tinyint unsigned 3 0
startquest mediumint unsigned 8 0
quest_template.entry Defined in XML R
lockid mediumint unsigned 8 0
Material tinyint 3 0
sheath tinyint unsigned 3 0
RandomProperty mediumint unsigned 8 0
RandomSuffix mediumint unsigned 8 0
block mediumint unsigned 8 0
itemset mediumint unsigned 8 0
itemset_dbc.id Defined in XML R
MaxDurability smallint unsigned 5 0
area mediumint unsigned 8 0
areatable_dbc.id Defined in XML R
Map smallint 5 0
maps_dbc.id Defined in XML R
BagFamily mediumint 7 0
TotemCategory mediumint 7 0
socketColor_1 tinyint 3 0
socketContent_1 mediumint 7 0
socketColor_2 tinyint 3 0
socketContent_2 mediumint 7 0
socketColor_3 tinyint 3 0
socketContent_3 mediumint 7 0
socketBonus mediumint 7 0
GemProperties mediumint 7 0
gemproperties_dbc.id Defined in XML R
RequiredDisenchantSkill smallint 5 -1
ArmorDamageModifier float 12 0
Duration int unsigned 10 0
ItemLimitCategory smallint 5 0
HolidayId int unsigned 10 0
ScriptName varchar 64
DisenchantID mediumint unsigned 8 0
disenchant_loot_template.entry Defined in XML R
disenchant_loot_template.entry Defined in XML R
FoodType tinyint unsigned 3 0
minMoneyLoot int unsigned 10 0
maxMoneyLoot int unsigned 10 0
ExtraFlags bit 0 0

Table contained 36,407 rows at Fri Feb 11 23:15 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
entry Primary key Asc PRIMARY
name Performance Asc idx_name
class Performance Asc items_index

Close relationships  within of separation: