character_corpses¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
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 |