Table mangos.gameobject
Gameobject 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  √ 
game_event_gameobject.guid Defined in XML R
gameobject_respawn.guid Defined in XML R
gameobject_scripts.id Defined in XML R
pool_gameobject.guid Defined in XML R
Global Unique Identifier
id mediumint unsigned 8 0
gameobject_template.entry Defined in XML R
Gameobject 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
position_x float 12 0
position_y float 12 0
position_z float 12 0
orientation float 12 0
rotation0 float 12 0
rotation1 float 12 0
rotation2 float 12 0
rotation3 float 12 0
spawntimesecs int 10 0
animprogress tinyint unsigned 3 0
state tinyint unsigned 3 0

Table contained 90,565 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: