Table mangos.creature_template
Creature 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 Comments
entry mediumint unsigned 8 0
characters.character_pet
achievement_reward
battlemaster_entry
creature
creature_involvedrelation
creature_onkill_reputation
creature_questrelation
creature_template_addon
game_event_creature_quest
locales_creature
npc_spellclick_spells
npc_trainer
npc_vendor
pet_levelstats
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_2 mediumint unsigned 8 0
creature_model_info
modelid_3 mediumint unsigned 8 0
creature_model_info
modelid_4 mediumint unsigned 8 0
creature_model_info
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
faction_H smallint unsigned 5 0
factiontemplate_dbc
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
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
creature_loot_template
pickpocketloot mediumint unsigned 8 0
pickpocketing_loot_template
pickpocketing_loot_template
skinloot mediumint unsigned 8 0
skinning_loot_template
skinning_loot_template
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
spell2 mediumint unsigned 8 0
spell_dbc
spell3 mediumint unsigned 8 0
spell_dbc
spell4 mediumint unsigned 8 0
spell_dbc
PetSpellDataId mediumint unsigned 8 0
spell_dbc
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
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
entry Primary key Asc
name Performance Asc

Close relationships  within of separation: