Table mangos.gameobject_template
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
entry mediumint unsigned 8 0
gameobject.id Defined in XML R
gameobject_involvedrelation.id Defined in XML R
gameobject_questrelation.id Defined in XML R
locales_gameobject.entry Defined in XML R
transports.entry Defined in XML R
type tinyint unsigned 3 0
displayId mediumint unsigned 8 0
name varchar 100
IconName varchar 100
castBarCaption varchar 100
unk1 varchar 100
faction smallint unsigned 5 0
factiontemplate_dbc.id Defined in XML R
flags int unsigned 10 0
size float 12 1
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
data0 int unsigned 10 0
data1 int unsigned 10 0
data2 int unsigned 10 0
data3 int unsigned 10 0
data4 int unsigned 10 0
data5 int unsigned 10 0
data6 int unsigned 10 0
data7 int unsigned 10 0
data8 int unsigned 10 0
data9 int unsigned 10 0
data10 int unsigned 10 0
data11 int unsigned 10 0
data12 int unsigned 10 0
data13 int unsigned 10 0
data14 int unsigned 10 0
data15 int unsigned 10 0
data16 int unsigned 10 0
data17 int unsigned 10 0
data18 int unsigned 10 0
data19 int unsigned 10 0
data20 int unsigned 10 0
data21 int unsigned 10 0
data22 int unsigned 10 0
data23 int unsigned 10 0
mingold mediumint unsigned 8 0
maxgold mediumint unsigned 8 0
ScriptName varchar 64

Table contained 18,898 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: