Skip to content



    character_corpses {
        intunsigned id
        intunsigned charid
        varchar charname
        smallintunsigned instance_id
        smallint zone_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    character_corpse_items {
        intunsigned corpse_id
        intunsigned item_id
        intunsigned aug_1
        intunsigned aug_2
        intunsigned aug_3
        intunsigned aug_4
        intunsigned aug_5
        int aug_6
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    character_corpses ||--o{ character_data : "One-to-One"
    character_corpses ||--o{ character_data : "One-to-One"
    character_corpses ||--o{ character_corpse_items : "Has-Many"
    character_corpses ||--o{ instance_list : "One-to-One"
    character_corpses ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One charid character_data id
One-to-One charname character_data name
Has-Many id character_corpse_items corpse_id
One-to-One instance_id instance_list id
One-to-One zone_id zone zoneidnumber


Column Data Type Description
id int Unique Corpse Identifier
charid int Character Identifier
charname varchar Character Name
zone_id smallint Zone Identifier
instance_id smallint Instance Identifier
x float X Coordinate
y float Y Coordinate
z float Z Coordinate
heading float Heading Coordinate
time_of_death datetime Time of Death
guild_consent_id int Guild Consent Identifier
is_rezzed tinyint Is Rezzed: 0 = False, 1 = True
is_buried tinyint Is Buried: 0 = False, 1 = True
was_at_graveyard tinyint Was At Graveyard: 0 = False, 1 = True
is_locked tinyint Is Locked: 0 = False, 1 = True
exp int Experience
size int Size
level int Level
race int Race
gender int Gender
class int Class
deity int Deity
texture int Texture
helm_texture int Helm Texture
copper int Copper
silver int Silver
gold int Gold
platinum int Platinum
hair_color int Hair Color
beard_color int Beard Color
eye_color_1 int Eye Color 1
eye_color_2 int Eye Color 2
hair_style int Hair Style
face int Face
beard int Beard
drakkin_heritage int Drakkin Heritage
drakkin_tattoo int Drakkin Tattoo
drakkin_details int Drakkin Details
wc_1 int Wear Change 1
wc_2 int Wear Change 2
wc_3 int Wear Change 3
wc_4 int Wear Change 4
wc_5 int Wear Change 5
wc_6 int Wear Change 6
wc_7 int Wear Change 7
wc_8 int Wear Change 8
wc_9 int Wear Change 9
rez_time int
gm_exp int
killed_by int
rezzable tinyint