Skip to content

character_data

Info

This page was last generated 2022.09.16

Relationship Diagram(s)

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Relationships

Relationship Type Local Key Relates to Table Foreign Key
Has-Many id adventure_members charid
Has-Many id adventure_stats player_id
Has-Many id char_recipe_list char_id
Has-Many id character_pet_buffs char_id
Has-Many id character_pet_info char_id
Has-Many id character_pet_inventory char_id
Has-Many id faction_values char_id
Has-Many id guild_members char_id
Has-Many id keyring char_id
Has-Many id player_titlesets char_id
Has-Many id buyer charid
Has-Many id character_activities charid
Has-Many id character_alt_currency char_id
Has-Many id character_alternate_abilities id
Has-Many id character_auras id
Has-Many id character_bandolier id
Has-Many id character_bind id
Has-Many id character_buffs character_id
Has-Many id character_corpses charid
Has-Many id character_currency id
Has-Many id character_disciplines id
Has-Many id character_enabledtasks charid
Has-Many id character_exp_modifiers character_id
Has-Many id character_expedition_lockouts character_id
Has-Many id character_inspect_messages id
Has-Many id character_instance_safereturns character_id
Has-Many id character_item_recast id
Has-Many id character_languages id
Has-Many id character_leadership_abilities id
Has-Many id character_material id
Has-Many id character_memmed_spells id
Has-Many id character_peqzone_flags id
Has-Many id character_pet_buffs char_id
Has-Many id character_pet_info char_id
Has-Many id character_pet_inventory char_id
Has-Many id character_potionbelt id
Has-Many id character_skills id
Has-Many id character_spells id
Has-Many id character_task_timers character_id
Has-Many id character_tasks charid
Has-Many id character_tribute id
Has-Many id completed_shared_task_members character_id
Has-Many id completed_tasks charid
Has-Many id dynamic_zone_members character_id
Has-Many id faction_values char_id
Has-Many id friends charid
One-to-One id group_id charid
One-to-One id guild_members char_id
One-to-One id guilds leader
Has-Many id instance_list_player charid
Has-Many id inventory charid
Has-Many id inventory_snapshots charid
Has-Many id keyring char_id
Has-Many id mail charid
Has-Many id mercs OwnerCharacterID
Has-Many id player_titlesets char_id
Has-Many id qs_merchant_transaction_record char_id
Has-Many id qs_player_aa_rate_hourly char_id
Has-Many id qs_player_delete_record char_id
Has-Many id qs_player_events char_id
Has-Many id qs_player_handin_record char_id
Has-Many id qs_player_move_record char_id
Has-Many id qs_player_npc_kill_record_entries char_id
Has-Many id qs_player_speech from
Has-Many id qs_player_speech to
Has-Many id qs_player_trade_record char1_id
Has-Many id qs_player_trade_record char2_id
Has-Many id qs_player_trade_record_entries from_id
Has-Many id qs_player_trade_record_entries to_id
Has-Many id quest_globals charid
One-to-One id raid_members charid
One-to-One id shared_task_members character_id
Has-Many id timers char_id
Has-Many id titles char_id
Has-Many id trader char_id
Has-Many id zone_flags charID
Has-Many name character_corpses charname
Has-Many name discovered_items char_name
Has-Many name eventlog charname
Has-Many name group_leaders assist
Has-Many name group_leaders leadername
Has-Many name group_leaders maintank
Has-Many name group_leaders mentoree
Has-Many name group_leaders puller
One-to-One name guilds motd_setter
One-to-One name hackers name
One-to-One nane lfguild name
Has-Many name petitions charname
One-to-One name raid_members name
Has-Many name reports name
Has-Many name trader_audit buyer
Has-Many name trader_audit seller

Schema

Column Data Type Description
id int Unique Character Identifier
account_id int Account Identifier
name varchar Name
last_name varchar Last Name
title varchar Title
suffix varchar Suffix
zone_id int Zone Identifier
zone_instance int Zone Instance Identifier
y float Y Coordinate
x float X Coordinate
z float Z Coordinate
heading float Heading Coordinate
gender tinyint Gender
race smallint Race
class tinyint Class
level int Level
deity int Deity
birthday int UNIX Timestamp of Birthday
last_login int UNIX Timestamp of Last Login
time_played int Time Played
level2 tinyint Level 2
anon tinyint Anon: 0 = False, 1 = Anonymous, 2 = Roleplaying
gm tinyint GM: 0 = False, 1 = True
face int Face
hair_color tinyint Hair Color
hair_style tinyint Hair Style
beard tinyint Beard
beard_color tinyint Beard Color
eye_color_1 tinyint Eye Color 1
eye_color_2 tinyint Eye Color 2
drakkin_heritage int Drakkin Heritage
drakkin_tattoo int Drakkin Tattoo
drakkin_details int Drakkin Details
ability_time_seconds tinyint Ability Timer in Seconds
ability_number tinyint Ability Number
ability_time_minutes tinyint Ability Timer in Minutes
ability_time_hours tinyint Ability Timer in Hours
exp int Experience
aa_points_spent int AA Points Spent
aa_exp int AA Experience
aa_points int AA Points
group_leadership_exp int Group Leadership Experience
raid_leadership_exp int Raid Leadership Experience
group_leadership_points int Group Leadership Points
raid_leadership_points int Raid Leadership Points
points int Points
cur_hp int Health
mana int Mana
endurance int Endurance
intoxication int Intoxication
str int Strength
sta int Stamina
cha int Charisma
dex int Dexterity
int int Intelligence
agi int Agility
wis int Wisdom
zone_change_count int Zone Change Count
toxicity int Toxicity
hunger_level int Hunger Level
thirst_level int Thirst Level
ability_up int Ability Up
ldon_points_guk int LDoN Points - Deepest Guk
ldon_points_mir int LDoN Points - Miragul's Menagerie
ldon_points_mmc int LDoN Points - Mistmoore Catacombs
ldon_points_ruj int LDoN Points - Rujarkian Hills
ldon_points_tak int LDoN Points - Takish-Hiz
ldon_points_available int LDoN Points Available
tribute_time_remaining int Tribute Time Remaining
career_tribute_points int Career Tribute Points
tribute_points int Tribute Points
tribute_active int Tribute Active: 0 = False, 1 = True
pvp_status tinyint PVP Status: 0 = False, 1 = True
pvp_kills int PVP Kills
pvp_deaths int PVP Deaths
pvp_current_points int PVP Points
pvp_career_points int Career PVP Points
pvp_best_kill_streak int Best Kill Streak
pvp_worst_death_streak int Worse Death Streak
pvp_current_kill_streak int Current Kill Streak
pvp2 int PVP Status: 0 = False, 1 = True
pvp_type int PVP Type
show_helm int Show Helm: 0 = False, 1 = True
group_auto_consent tinyint Group Auto Consent: 0 = False, 1 = True
raid_auto_consent tinyint Raid Auto Consent: 0 = False, 1 = True
guild_auto_consent tinyint Guild Auto Consent: 0 = False, 1 = True
leadership_exp_on tinyint Leadership Experience On : 0 = False, 1 = True
RestTimer int Rest Timer
air_remaining int Air Remaining
autosplit_enabled int Autosplit Enabled: 0 = False, 1 = True
lfp tinyint Looking For Party: 0 = False, 1 = True
lfg tinyint Looking For Guild: 0 = False, 1 = True
mailkey char Mail Key
xtargets tinyint XTargets
firstlogon tinyint First Logon
e_aa_effects int Experience AA Effects
e_percent_to_aa int Experience Percentage to AA Points
e_expended_aa_spent int Expended AA Points Spent
aa_points_spent_old int AA Points Spent Old
aa_points_old int AA Points Old
e_last_invsnapshot int Last Inventory Snapshot
deleted_at datetime Deleted At Unix Timestamp