Table characters.corpse
Death 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 0
characters.guid Defined in XML R
Global Unique Identifier
player int unsigned 10 0 Character Global Unique Identifier
position_x float 12 0
position_y float 12 0
position_z float 12 0
orientation float 12 0
zone int unsigned 10 38 Zone Identifier
map int unsigned 10 0 Map Identifier
phaseMask smallint unsigned 5 1
data longtext 2147483647  √  null
time bigint unsigned 20 0
corpse_type tinyint unsigned 3 0
instance int unsigned 10 0

Table contained 0 rows at Fri Feb 11 23:13 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
guid Primary key Asc PRIMARY
corpse_type Performance Asc idx_type
instance Performance Asc instance

Close relationships  within of separation: