Table mangos.creature_template
Creature 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.character_pet.entry Defined in XML R
achievement_reward.sender Defined in XML R
battlemaster_entry.entry Defined in XML R
creature.id Defined in XML R
creature_involvedrelation.id Defined in XML R
creature_onkill_reputation.creature_id Defined in XML R
creature_questrelation.id Defined in XML R
creature_template_addon.entry Defined in XML R
game_event_creature_quest.id Defined in XML R
locales_creature.entry Defined in XML R
npc_spellclick_spells.npc_entry Defined in XML R
npc_trainer.entry Defined in XML R
npc_vendor.entry Defined in XML R
pet_levelstats.creature_entry Defined in XML R
difficulty_entry_1 mediumint unsigned 8 0
difficulty_entry_2 mediumint unsigned 8 0
difficulty_entry_3 mediumint unsigned 8 0
KillCredit1 int unsigned 10 0
KillCredit2 int unsigned 10 0
modelid_1 mediumint unsigned 8 0
creature_model_info.modelid Defined in XML R
modelid_2 mediumint unsigned 8 0
creature_model_info.modelid Defined in XML R
modelid_3 mediumint unsigned 8 0
creature_model_info.modelid Defined in XML R
modelid_4 mediumint unsigned 8 0
creature_model_info.modelid Defined in XML R
name char 100 0
subname char 100  √  null
IconName char 100  √  null
gossip_menu_id mediumint unsigned 8 0
minlevel tinyint unsigned 3 1
maxlevel tinyint unsigned 3 1
minhealth int unsigned 10 0
maxhealth int unsigned 10 0
minmana int unsigned 10 0
maxmana int unsigned 10 0
armor mediumint unsigned 8 0
faction_A smallint unsigned 5 0
factiontemplate_dbc.id Defined in XML R
faction_H smallint unsigned 5 0
factiontemplate_dbc.id Defined in XML R
npcflag int unsigned 10 0
speed_walk float 12 1 Result of 2.5/2.5, most common value
speed_run float 12 1.14286 Result of 8.0/7.0, most common value
scale float 12 1
rank tinyint unsigned 3 0
mindmg float 12 0
maxdmg float 12 0
dmgschool tinyint 3 0
attackpower int unsigned 10 0
dmg_multiplier float 12 1
baseattacktime int unsigned 10 0
rangeattacktime int unsigned 10 0
unit_class tinyint unsigned 3 0
unit_flags int unsigned 10 0
dynamicflags int unsigned 10 0
family tinyint 3 0
trainer_type tinyint 3 0
trainer_spell mediumint unsigned 8 0
spell_dbc.id Defined in XML R
trainer_class tinyint unsigned 3 0
trainer_race tinyint unsigned 3 0
minrangedmg float 12 0
maxrangedmg float 12 0
rangedattackpower smallint unsigned 5 0
type tinyint unsigned 3 0
type_flags int unsigned 10 0
lootid mediumint unsigned 8 0
creature_loot_template.entry Defined in XML R
creature_loot_template.entry Defined in XML R
pickpocketloot mediumint unsigned 8 0
pickpocketing_loot_template.entry Defined in XML R
pickpocketing_loot_template.entry Defined in XML R
skinloot mediumint unsigned 8 0
skinning_loot_template.entry Defined in XML R
skinning_loot_template.entry Defined in XML R
resistance1 smallint 5 0
resistance2 smallint 5 0
resistance3 smallint 5 0
resistance4 smallint 5 0
resistance5 smallint 5 0
resistance6 smallint 5 0
spell1 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spell2 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spell3 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
spell4 mediumint unsigned 8 0
spell_dbc.id Defined in XML R
PetSpellDataId mediumint unsigned 8 0
spell_dbc.id Defined in XML R
mingold mediumint unsigned 8 0
maxgold mediumint unsigned 8 0
AIName char 64
MovementType tinyint unsigned 3 0
InhabitType tinyint unsigned 3 3
unk16 float 12 1
unk17 float 12 1
RacialLeader tinyint unsigned 3 0
questItem1 int unsigned 10 0
questItem2 int unsigned 10 0
questItem3 int unsigned 10 0
questItem4 int unsigned 10 0
questItem5 int unsigned 10 0
questItem6 int unsigned 10 0
movementId int unsigned 10 0
RegenHealth tinyint unsigned 3 1
equipment_id mediumint unsigned 8 0
creature_equip_template.entry Defined in XML R
mechanic_immune_mask int unsigned 10 0
flags_extra int unsigned 10 0
ScriptName char 64

Table contained 29,920 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

Close relationships  within of separation: