Table characters.characters
Player System

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
guid int unsigned 10 0
arena_team.captainguid Defined in XML R
arena_team_member.guid Defined in XML R
auctionhouse.buyguid Defined in XML R
auctionhouse.itemowner Defined in XML R
character_achievement.guid Defined in XML R
character_achievement_progress.guid Defined in XML R
character_action.guid Defined in XML R
character_aura.caster_guid Defined in XML R
character_aura.guid Defined in XML R
character_declinedname.guid Defined in XML R
character_gifts.guid Defined in XML R
character_homebind.guid Defined in XML R
character_instance.guid Defined in XML R
character_inventory.guid Defined in XML R
character_pet.owner Defined in XML R
character_pet_declinedname.owner Defined in XML R
character_queststatus.guid Defined in XML R
character_queststatus_daily.guid Defined in XML R
character_reputation.guid Defined in XML R
character_social.friend Defined in XML R
character_social.guid Defined in XML R
character_spell.guid Defined in XML R
character_spell_cooldown.guid Defined in XML R
character_ticket.guid Defined in XML R
character_tutorial.guid Defined in XML R
corpse.guid Defined in XML R
group_member.memberGuid Defined in XML R
groups.leaderGuid Defined in XML R
groups.looterGuid Defined in XML R
groups.mainAssistant Defined in XML R
groups.mainTank Defined in XML R
guild.leaderguid Defined in XML R
guild_bank_eventlog.PlayerGuid Defined in XML R
guild_eventlog.PlayerGuid1 Defined in XML R
guild_eventlog.PlayerGuid2 Defined in XML R
guild_member.guid Defined in XML R
item_instance.owner_guid Defined in XML R
mail.receiver Defined in XML R
mail.sender Defined in XML R
mail_items.receiver Defined in XML R
pet_aura.caster_guid Defined in XML R
pet_aura.guid Defined in XML R
petition.ownerguid Defined in XML R
petition_sign.ownerguid Defined in XML R
petition_sign.playerguid Defined in XML R
Global Unique Identifier
account int unsigned 10 0
realmd.account.id Defined in XML R
Account Identifier
data longtext 2147483647  √  null
name varchar 12
race tinyint unsigned 3 0
class tinyint unsigned 3 0
position_x float 12 0
position_y float 12 0
position_z float 12 0
map int unsigned 10 0 Map Identifier
dungeon_difficulty bit 0 0
orientation float 12 0
taximask longtext 2147483647  √  null
online tinyint unsigned 3 0
cinematic tinyint unsigned 3 0
totaltime int unsigned 10 0
leveltime int unsigned 10 0
logout_time bigint unsigned 20 0
is_logout_resting tinyint unsigned 3 0
rest_bonus float 12 0
resettalents_cost int unsigned 10 0
resettalents_time bigint unsigned 20 0
trans_x float 12 0
trans_y float 12 0
trans_z float 12 0
trans_o float 12 0
transguid bigint unsigned 20 0
extra_flags int unsigned 10 0
stable_slots bit 0 0
at_login int unsigned 10 0
zone int unsigned 10 0
death_expire_time bigint unsigned 20 0
taxi_path text 65535  √  null
arena_pending_points int unsigned 10 0
bgid int unsigned 10 0
bgteam int unsigned 10 0
bgmap int unsigned 10 0
bgx float 12 0
bgy float 12 0
bgz float 12 0
bgo float 12 0

Table contained 0 rows at Fri Feb 11 23:13 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
guid Primary key Asc PRIMARY
account Performance Asc idx_account
name Performance Asc idx_name
online Performance Asc idx_online

Close relationships  within of separation: