Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


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