SchemaSpy Analysis of characters - Columns UnifiedDB Character Database Generated by
SchemaSpy
Generated by SchemaSpy on Fri Feb 11 23:13 MST 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

characters contains 362 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
character_declinedname accusative varchar 15
character_pet_declinedname accusative varchar 12
bugreport content varchar 255
character_declinedname dative varchar 15
character_pet_declinedname dative varchar 12
character_declinedname genitive varchar 15
character_pet_declinedname genitive varchar 12
character_declinedname instrumental varchar 15
character_pet_declinedname instrumental varchar 12
guild motd varchar 255
characters name varchar 12
guild name varchar 255
petition name varchar 255
character_social note varchar 48 Friend Note
guild_member offnote varchar 255
guild_member pnote varchar 255
character_declinedname prepositional varchar 15
character_pet_declinedname prepositional varchar 12
guild_rank rname varchar 255
guild_bank_tab TabIcon varchar 100
guild_bank_tab TabName varchar 100
bugreport type varchar 255
account_data account int unsigned 10 0
characters account int unsigned 10 0 Account Identifier
character_action action smallint unsigned 5 0
pet_spell active int unsigned 10 0
character_aura amount int 10 0
pet_aura amount int 10 0
characters arena_pending_points int unsigned 10 0
arena_team arenateamid int unsigned 10 0
arena_team_member arenateamid int unsigned 10 0
arena_team_stats arenateamid int unsigned 10 0
characters at_login int unsigned 10 0
auctionhouse auctioneerguid int unsigned 10 0
arena_team BackgroundColor int unsigned 10 0
guild BackgroundColor int 10 0
character_inventory bag int unsigned 10 0
guild BankMoney bigint 19 0
guild_rank BankMoneyPerDay int unsigned 10 0
guild_member BankRemMoney int unsigned 10 0
guild_member BankRemSlotsTab0 int unsigned 10 0
guild_member BankRemSlotsTab1 int unsigned 10 0
guild_member BankRemSlotsTab2 int unsigned 10 0
guild_member BankRemSlotsTab3 int unsigned 10 0
guild_member BankRemSlotsTab4 int unsigned 10 0
guild_member BankRemSlotsTab5 int unsigned 10 0
guild_member BankResetTimeMoney int unsigned 10 0
guild_member BankResetTimeTab0 int unsigned 10 0
guild_member BankResetTimeTab1 int unsigned 10 0
guild_member BankResetTimeTab2 int unsigned 10 0
guild_member BankResetTimeTab3 int unsigned 10 0
guild_member BankResetTimeTab4 int unsigned 10 0
guild_member BankResetTimeTab5 int unsigned 10 0
characters bgid int unsigned 10 0
characters bgmap int unsigned 10 0
characters bgo float 12 0
characters bgteam int unsigned 10 0
characters bgx float 12 0
characters bgy float 12 0
characters bgz float 12 0
arena_team BorderColor int unsigned 10 0
guild BorderColor int 10 0
arena_team BorderStyle int unsigned 10 0
guild BorderStyle int 10 0
character_action button tinyint unsigned 3 0
auctionhouse buyguid int unsigned 10 0
auctionhouse buyoutprice int 10 0
arena_team captainguid int unsigned 10 0
character_aura caster_guid bigint unsigned 20 0 Full Global Unique Identifier
pet_aura caster_guid bigint unsigned 20 0 Full Global Unique Identifier
mail checked tinyint unsigned 3 0
characters cinematic tinyint unsigned 3 0
characters class tinyint unsigned 3 0
mail cod int unsigned 10 0
corpse corpse_type tinyint unsigned 3 0
character_pet CreatedBySpell int unsigned 10 0
character_pet curhappiness int unsigned 10 0
character_pet curmana int unsigned 10 0
characters death_expire_time bigint unsigned 20 0
mail deliver_time bigint 19 0
auctionhouse deposit int 10 0
guild_bank_eventlog DestTabId bit 0 0
groups difficulty tinyint unsigned 3 0
instance difficulty bit 0 0
character_spell disabled tinyint unsigned 3 0
characters dungeon_difficulty bit 0 0
character_aura effect_index int unsigned 10 0
pet_aura effect_index int unsigned 10 0
arena_team EmblemColor int unsigned 10 0
guild EmblemColor int 10 0
arena_team EmblemStyle int unsigned 10 0
guild EmblemStyle int 10 0
character_gifts entry int unsigned 10 0
character_pet entry int unsigned 10 0
character_pet exp int unsigned 10 0
mail expire_time bigint 19 0
character_queststatus explored bit 0 0
characters extra_flags int unsigned 10 0
character_reputation faction int unsigned 10 0
character_gifts flags int unsigned 10 0
character_reputation flags int 10 0
character_social flags bit 0 0 Friend Flags
character_social friend int unsigned 10 0 Friend Global Unique Identifier
arena_team_stats games int unsigned 10 0
guild_bank_right gbright tinyint unsigned 3 0
arena_team_member guid int unsigned 10 0
character_action guid int unsigned 10 0 Global Unique Identifier
character_aura guid int unsigned 10 0 Global Unique Identifier
character_declinedname guid int unsigned 10 0 Global Unique Identifier
character_gifts guid int unsigned 10 0
character_homebind guid int unsigned 10 0 Global Unique Identifier
character_instance guid int unsigned 10 0
character_inventory guid int unsigned 10 0 Global Unique Identifier
character_queststatus guid int unsigned 10 0 Global Unique Identifier
character_queststatus_daily guid int unsigned 10 0 Global Unique Identifier
character_reputation guid int unsigned 10 0 Global Unique Identifier
character_social guid int unsigned 10 0 Character Global Unique Identifier
character_spell guid int unsigned 10 0 Global Unique Identifier
character_spell_cooldown guid int unsigned 10 0 Global Unique Identifier, Low part
character_ticket guid int unsigned 10 0
characters guid int unsigned 10 0 Global Unique Identifier
corpse guid int unsigned 10 0 Global Unique Identifier
guild_member guid int unsigned 10 0
item_instance guid int unsigned 10 0
pet_aura guid int unsigned 10 0 Global Unique Identifier
pet_spell guid int unsigned 10 0 Global Unique Identifier
pet_spell_cooldown guid int unsigned 10 0 Global Unique Identifier, Low part
guild guildid int unsigned 10 0
guild_bank_eventlog guildid int unsigned 10 0
guild_bank_item guildid int unsigned 10 0
guild_bank_right guildid int unsigned 10 0
guild_bank_tab guildid int unsigned 10 0
guild_member guildid int unsigned 10 0
guild_rank guildid int unsigned 10 0
mail has_items tinyint unsigned 3 0
auctionhouse id int unsigned 10 0
character_pet id int unsigned 10 0
character_pet_declinedname id int unsigned 10 0
instance id int unsigned 10 0
item_text id int unsigned 10 0
mail id int unsigned 10 0 Identifier
character_instance instance int unsigned 10 0
corpse instance int unsigned 10 0
group_instance instance int unsigned 10 0
characters is_logout_resting tinyint unsigned 3 0
character_inventory item int unsigned 10 0 Item Global Unique Identifier
character_spell_cooldown item int unsigned 10 0 Item Identifier
guild_bank_item item_entry int unsigned 10 0
character_gifts item_guid int unsigned 10 0
guild_bank_item item_guid int unsigned 10 0
mail_items item_guid int 10 0
auctionhouse item_template int unsigned 10 0 Item Identifier
character_inventory item_template int unsigned 10 0 Item Identifier
mail_items item_template int 10 0
character_queststatus itemcount1 int unsigned 10 0
character_queststatus itemcount2 int unsigned 10 0
character_queststatus itemcount3 int unsigned 10 0
character_queststatus itemcount4 int unsigned 10 0
auctionhouse itemguid int unsigned 10 0
guild_bank_eventlog ItemOrMoney int unsigned 10 0
auctionhouse itemowner int unsigned 10 0
guild_bank_eventlog ItemStackCount tinyint unsigned 3 0
mail itemTextId int unsigned 10 0
auctionhouse lastbid int 10 0
group_instance leaderGuid int unsigned 10 0
guild leaderguid int unsigned 10 0
characters leveltime int unsigned 10 0
guild_bank_eventlog LogEntry bit 0 0
guild_bank_eventlog LogGuid int unsigned 10 0
characters logout_time bigint unsigned 20 0
mail_items mail_id int 10 0
mail mailTemplateId mediumint unsigned 8 0
character_homebind map int unsigned 10 0 Map Identifier
characters map int unsigned 10 0 Map Identifier
corpse map int unsigned 10 0 Map Identifier
instance map int unsigned 10 0
instance_reset mapid int unsigned 10 0
character_aura maxduration int 10 0
pet_aura maxduration int 10 0
mail messageType tinyint unsigned 3 0
character_action misc tinyint unsigned 3 0
character_queststatus mobcount1 int unsigned 10 0
character_queststatus mobcount2 int unsigned 10 0
character_queststatus mobcount3 int unsigned 10 0
character_queststatus mobcount4 int unsigned 10 0
character_pet modelid int unsigned 10  √  0
mail money int unsigned 10 0
saved_variables NextArenaPointDistributionTime bigint unsigned 20 0
characters online tinyint unsigned 3 0
characters orientation float 12 0
corpse orientation float 12 0
character_pet owner int unsigned 10 0
character_pet_declinedname owner int unsigned 10 0
item_instance owner_guid int unsigned 10 0
character_instance permanent bit 0 0
group_instance permanent bit 0 0
arena_team_member personal_rating int unsigned 10 0
petition petitionguid int unsigned 10  √  0
petition_sign petitionguid int unsigned 10 0
character_pet PetType tinyint unsigned 3 0
arena_team_stats played int unsigned 10 0
arena_team_member played_season int unsigned 10 0
arena_team_member played_week int unsigned 10 0
corpse player int unsigned 10 0 Character Global Unique Identifier
petition_sign player_account int unsigned 10 0
guild_bank_eventlog PlayerGuid int unsigned 10 0
petition_sign playerguid int unsigned 10 0
character_homebind position_x float 12 0
characters position_x float 12 0
corpse position_x float 12 0
character_homebind position_y float 12 0
characters position_y float 12 0
corpse position_y float 12 0
character_homebind position_z float 12 0
characters position_z float 12 0
corpse position_z float 12 0
character_queststatus quest int unsigned 10 0 Quest Identifier
character_queststatus_daily quest int unsigned 10 0 Quest Identifier
characters race tinyint unsigned 3 0
arena_team_stats rank int unsigned 10 0
guild_member rank tinyint unsigned 3 0
arena_team_stats rating int unsigned 10 0
character_pet Reactstate bit 0 0
character_tutorial realmid int unsigned 10 0 Realm Identifier
mail receiver int unsigned 10 0 Character Global Unique Identifier
mail_items receiver int unsigned 10 0 Character Global Unique Identifier
character_aura remaincharges int 10 0
pet_aura remaincharges int 10 0
character_aura remaintime int 10 0
pet_aura remaintime int 10 0
character_pet renamed bit 0 0
character_pet resettalents_cost int unsigned 10 0
characters resettalents_cost int unsigned 10 0
character_pet resettalents_time bigint unsigned 20 0
characters resettalents_time bigint unsigned 20 0
instance resettime bigint 19 0
instance_reset resettime bigint 19 0
characters rest_bonus float 12 0
character_queststatus rewarded bit 0 0
guild_bank_right rid int unsigned 10 0
guild_rank rights int unsigned 10 0
character_pet savetime bigint unsigned 20 0
mail sender int unsigned 10 0 Character Global Unique Identifier
character_inventory slot tinyint unsigned 3 0
character_pet slot int unsigned 10 0
guild_bank_item SlotId tinyint unsigned 3 0
guild_bank_right SlotPerDay int unsigned 10 0
character_aura spell int unsigned 10 0
character_spell spell int unsigned 10 0 Spell Identifier
character_spell_cooldown spell int unsigned 10 0 Spell Identifier
pet_aura spell int unsigned 10 0
pet_spell spell int unsigned 10 0 Spell Identifier
pet_spell_cooldown spell int unsigned 10 0 Spell Identifier
characters stable_slots bit 0 0
character_reputation standing int 10 0
auctionhouse startbid int 10 0
character_queststatus status int unsigned 10 0
guild_bank_eventlog TabId bit 0 0
guild_bank_item TabId bit 0 0
guild_bank_right TabId bit 0 0
guild_bank_tab TabId bit 0 0
character_pet talentpoints int unsigned 10 0
account_data time bigint unsigned 20 0
auctionhouse time bigint 19 0
character_queststatus_daily time bigint unsigned 20 0
character_spell_cooldown time bigint unsigned 20 0
corpse time bigint unsigned 20 0
pet_spell_cooldown time bigint unsigned 20 0
character_queststatus timer bigint unsigned 20 0
guild_bank_eventlog TimeStamp bigint unsigned 20 0
characters totaltime int unsigned 10 0
characters trans_o float 12 0
characters trans_x float 12 0
characters trans_y float 12 0
characters trans_z float 12 0
characters transguid bigint unsigned 20 0
character_tutorial tut0 int unsigned 10 0
character_tutorial tut1 int unsigned 10 0
character_tutorial tut2 int unsigned 10 0
character_tutorial tut3 int unsigned 10 0
character_tutorial tut4 int unsigned 10 0
character_tutorial tut5 int unsigned 10 0
character_tutorial tut6 int unsigned 10 0
character_tutorial tut7 int unsigned 10 0
account_data type int unsigned 10 0
arena_team type tinyint unsigned 3 0
character_action type tinyint unsigned 3 0
petition type int unsigned 10 0
petition_sign type int unsigned 10 0
arena_team_stats wins int unsigned 10 0
arena_team_stats wins2 int unsigned 10 0
arena_team_member wons_season int unsigned 10 0
arena_team_member wons_week int unsigned 10 0
character_homebind zone int unsigned 10 0 Zone Identifier
characters zone int unsigned 10 0
character_spell active tinyint unsigned 3 1
character_pet curhealth int unsigned 10 1
character_pet level int unsigned 10 1
corpse phaseMask smallint unsigned 5 1
character_aura stackcount int 10 1
pet_aura stackcount int 10 1
corpse zone int unsigned 10 38 Zone Identifier
mail stationery tinyint 3 41
character_ticket ticket_lastchange timestamp 19 CURRENT_TIMESTAMP
character_pet abdata longtext 2147483647  √  null
character_tutorial account bigint unsigned 20  √  Account Identifier
character_achievement achievement int 10
group_member assistant bit 0
character_achievement_progress counter int 10
guild createdate datetime 19  √  null
character_achievement_progress criteria int 10
account_data data longtext 2147483647
characters data longtext 2147483647  √  null
corpse data longtext 2147483647  √  null
instance data longtext 2147483647  √  null
item_instance data longtext 2147483647  √  null
character_achievement date int 10
character_achievement_progress date int 10
guild_eventlog EventType bit 0 Event type
character_achievement guid int 10
character_achievement_progress guid int 10
character_tutorial guid unknown 0
guild_eventlog guildid int 10 Guild Identificator
groups icon1 int unsigned 10
groups icon2 int unsigned 10
groups icon3 int unsigned 10
groups icon4 int unsigned 10
groups icon5 int unsigned 10
groups icon6 int unsigned 10
groups icon7 int unsigned 10
groups icon8 int unsigned 10
bugreport id int 10  √  Identifier
guild info text 65535
groups isRaid bit 0
group_member leaderGuid int unsigned 10
groups leaderGuid int unsigned 10
guild_eventlog LogGuid int 10 Log entry identificator
groups looterGuid int unsigned 10
groups lootMethod tinyint unsigned 3
groups lootThreshold tinyint unsigned 3
groups mainAssistant int unsigned 10
groups mainTank int unsigned 10
group_member memberGuid int unsigned 10
arena_team name char 255
guild_eventlog NewRank tinyint 3 New rank(in case promotion/demotion)
petition ownerguid int unsigned 10
petition_sign ownerguid int unsigned 10
guild_eventlog PlayerGuid1 int 10 Player 1
guild_eventlog PlayerGuid2 int 10 Player 2
character_db_version required_7644_01_characters_character_pet bit 1  √  null
guild_rank rid int unsigned 10
group_member subgroup smallint unsigned 5
mail subject longtext 2147483647  √  null
guild_bank_tab TabText text 65535  √  null
characters taxi_path text 65535  √  null
characters taximask longtext 2147483647  √  null
character_pet teachspelldata longtext 2147483647  √  null
item_text text longtext 2147483647  √  null
character_ticket ticket_id int unsigned 10  √ 
character_ticket ticket_text text 65535  √  null
guild_eventlog TimeStamp bigint 19 Event UNIX time
character_pet name varchar 100  √  Pet