Table mangos.item_template
Item System

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
entry mediumint unsigned 8 0
characters.auctionhouse
characters.character_gifts
characters.character_inventory
characters.character_spell_cooldown
characters.guild_bank_item
characters.mail_items
achievement_reward
areatrigger_teleport
creature_loot_template
disenchant_loot_template
fishing_loot_template
gameobject_loot_template
item_loot_template
item_loot_template
locales_item
milling_loot_template
milling_loot_template
npc_vendor
pickpocketing_loot_template
playercreateinfo_item
prospecting_loot_template
prospecting_loot_template
reference_loot_template
skinning_loot_template
spell_loot_template
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
requiredhonorrank mediumint unsigned 8 0
RequiredCityRank mediumint unsigned 8 0
RequiredReputationFaction smallint unsigned 5 0
faction_dbc
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
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
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
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
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
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
LanguageID tinyint unsigned 3 0
PageMaterial tinyint unsigned 3 0
startquest mediumint unsigned 8 0
quest_template
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
MaxDurability smallint unsigned 5 0
area mediumint unsigned 8 0
areatable_dbc
Map smallint 5 0
maps_dbc
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
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
disenchant_loot_template
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
entry Primary key Asc
name Performance Asc
class Performance Asc

Close relationships  within of separation: