character_corpses

Relationships

erDiagram
    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

Schema

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