Table mangos.creature
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
guid int unsigned 10  √ 
characters.auctionhouse.auctioneerguid Defined in XML R
creature_addon.guid Defined in XML R
creature_battleground.guid Defined in XML R
creature_movement.id Defined in XML R
creature_respawn.guid Defined in XML R
game_event_creature.guid Defined in XML R
game_event_model_equip.guid Defined in XML R
npc_gossip.npc_guid Defined in XML R
pool_creature.guid Defined in XML R
Global Unique Identifier
id mediumint unsigned 8 0
creature_template.entry Defined in XML R
Creature Identifier
map smallint unsigned 5 0
maps_dbc.id Defined in XML R
Map Identifier
spawnMask tinyint unsigned 3 1
phaseMask smallint unsigned 5 1
modelid mediumint unsigned 8 0
creature_model_info.modelid Defined in XML R
equipment_id mediumint 7 0
creature_equip_template.entry Defined in XML R
position_x float 12 0
position_y float 12 0
position_z float 12 0
orientation float 12 0
spawntimesecs int unsigned 10 120
spawndist float 12 5
currentwaypoint mediumint unsigned 8 0
creature_movement.point Defined in XML R
curhealth int unsigned 10 1
curmana int unsigned 10 0
DeathState tinyint unsigned 3 0
MovementType tinyint unsigned 3 0

Table contained 138,708 rows at Fri Feb 11 23:15 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
guid Primary key Asc PRIMARY
id Performance Asc idx_id
map Performance Asc idx_map

Close relationships  within of separation: