character_corpses

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

Relationships

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