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
account_data account int unsigned 10 0
account_data data longtext 2147483647
account_data time bigint unsigned 20 0
account_data type int unsigned 10 0
arena_team arenateamid int unsigned 10 0
arena_team BackgroundColor int unsigned 10 0
arena_team BorderColor int unsigned 10 0
arena_team BorderStyle int unsigned 10 0
arena_team captainguid int unsigned 10 0
arena_team EmblemColor int unsigned 10 0
arena_team EmblemStyle int unsigned 10 0
arena_team name char 255
arena_team type tinyint unsigned 3 0
arena_team_member arenateamid int unsigned 10 0
arena_team_member guid int unsigned 10 0
arena_team_member personal_rating int unsigned 10 0
arena_team_member played_season int unsigned 10 0
arena_team_member played_week int unsigned 10 0
arena_team_member wons_season int unsigned 10 0
arena_team_member wons_week int unsigned 10 0
arena_team_stats arenateamid int unsigned 10 0
arena_team_stats games int unsigned 10 0
arena_team_stats played int unsigned 10 0
arena_team_stats rank int unsigned 10 0
arena_team_stats rating int unsigned 10 0
arena_team_stats wins int unsigned 10 0
arena_team_stats wins2 int unsigned 10 0
auctionhouse auctioneerguid int unsigned 10 0
auctionhouse buyguid int unsigned 10 0
auctionhouse buyoutprice int 10 0
auctionhouse deposit int 10 0
auctionhouse id int unsigned 10 0
auctionhouse item_template int unsigned 10 0 Item Identifier
auctionhouse itemguid int unsigned 10 0
auctionhouse itemowner int unsigned 10 0
auctionhouse lastbid int 10 0
auctionhouse startbid int 10 0
auctionhouse time bigint 19 0
bugreport content varchar 255
bugreport id int 10  √  Identifier
bugreport type varchar 255
character_achievement achievement int 10
character_achievement date int 10
character_achievement guid int 10
character_achievement_progress counter int 10
character_achievement_progress criteria int 10
character_achievement_progress date int 10
character_achievement_progress guid int 10
character_action action smallint unsigned 5 0
character_action button tinyint unsigned 3 0
character_action guid int unsigned 10 0 Global Unique Identifier
character_action misc tinyint unsigned 3 0
character_action type tinyint unsigned 3 0
character_aura amount int 10 0
character_aura caster_guid bigint unsigned 20 0 Full Global Unique Identifier
character_aura effect_index int unsigned 10 0
character_aura guid int unsigned 10 0 Global Unique Identifier
character_aura maxduration int 10 0
character_aura remaincharges int 10 0
character_aura remaintime int 10 0
character_aura spell int unsigned 10 0
character_aura stackcount int 10 1
character_db_version required_7644_01_characters_character_pet bit 1  √  null
character_declinedname accusative varchar 15
character_declinedname dative varchar 15
character_declinedname genitive varchar 15
character_declinedname guid int unsigned 10 0 Global Unique Identifier
character_declinedname instrumental varchar 15
character_declinedname prepositional varchar 15
character_gifts entry int unsigned 10 0
character_gifts flags int unsigned 10 0
character_gifts guid int unsigned 10 0
character_gifts item_guid int unsigned 10 0
character_homebind guid int unsigned 10 0 Global Unique Identifier
character_homebind map int unsigned 10 0 Map Identifier
character_homebind position_x float 12 0
character_homebind position_y float 12 0
character_homebind position_z float 12 0
character_homebind zone int unsigned 10 0 Zone Identifier
character_instance guid int unsigned 10 0
character_instance instance int unsigned 10 0
character_instance permanent bit 0 0
character_inventory bag int unsigned 10 0
character_inventory guid int unsigned 10 0 Global Unique Identifier
character_inventory item int unsigned 10 0 Item Global Unique Identifier
character_inventory item_template int unsigned 10 0 Item Identifier
character_inventory slot tinyint unsigned 3 0
character_pet abdata longtext 2147483647  √  null
character_pet CreatedBySpell int unsigned 10 0
character_pet curhappiness int unsigned 10 0
character_pet curhealth int unsigned 10 1
character_pet curmana int unsigned 10 0
character_pet entry int unsigned 10 0
character_pet exp int unsigned 10 0
character_pet id int unsigned 10 0
character_pet level int unsigned 10 1
character_pet modelid int unsigned 10  √  0
character_pet name varchar 100  √  Pet
character_pet owner int unsigned 10 0
character_pet PetType tinyint unsigned 3 0
character_pet Reactstate bit 0 0
character_pet renamed bit 0 0
character_pet resettalents_cost int unsigned 10 0
character_pet resettalents_time bigint unsigned 20 0
character_pet savetime bigint unsigned 20 0
character_pet slot int unsigned 10 0
character_pet talentpoints int unsigned 10 0
character_pet teachspelldata longtext 2147483647  √  null
character_pet_declinedname accusative varchar 12
character_pet_declinedname dative varchar 12
character_pet_declinedname genitive varchar 12
character_pet_declinedname id int unsigned 10 0
character_pet_declinedname instrumental varchar 12
character_pet_declinedname owner int unsigned 10 0
character_pet_declinedname prepositional varchar 12
character_queststatus explored bit 0 0
character_queststatus guid int unsigned 10 0 Global Unique Identifier
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
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_queststatus quest int unsigned 10 0 Quest Identifier
character_queststatus rewarded bit 0 0
character_queststatus status int unsigned 10 0
character_queststatus timer bigint unsigned 20 0
character_queststatus_daily guid int unsigned 10 0 Global Unique Identifier
character_queststatus_daily quest int unsigned 10 0 Quest Identifier
character_queststatus_daily time bigint unsigned 20 0
character_reputation faction int unsigned 10 0
character_reputation flags int 10 0
character_reputation guid int unsigned 10 0 Global Unique Identifier
character_reputation standing int 10 0
character_social flags bit 0 0 Friend Flags
character_social friend int unsigned 10 0 Friend Global Unique Identifier
character_social guid int unsigned 10 0 Character Global Unique Identifier
character_social note varchar 48 Friend Note
character_spell active tinyint unsigned 3 1
character_spell disabled tinyint unsigned 3 0
character_spell guid int unsigned 10 0 Global Unique Identifier
character_spell spell int unsigned 10 0 Spell Identifier
character_spell_cooldown guid int unsigned 10 0 Global Unique Identifier, Low part
character_spell_cooldown item int unsigned 10 0 Item Identifier
character_spell_cooldown spell int unsigned 10 0 Spell Identifier
character_spell_cooldown time bigint unsigned 20 0
character_ticket guid int unsigned 10 0
character_ticket ticket_id int unsigned 10  √ 
character_ticket ticket_lastchange timestamp 19 CURRENT_TIMESTAMP
character_ticket ticket_text text 65535  √  null
character_tutorial account bigint unsigned 20  √  Account Identifier
character_tutorial guid unknown 0
character_tutorial realmid int unsigned 10 0 Realm Identifier
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
characters account int unsigned 10 0 Account Identifier
characters arena_pending_points int unsigned 10 0
characters at_login 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
characters cinematic tinyint unsigned 3 0
characters class tinyint unsigned 3 0
characters data longtext 2147483647  √  null
characters death_expire_time bigint unsigned 20 0
characters dungeon_difficulty bit 0 0
characters extra_flags int unsigned 10 0
characters guid int unsigned 10 0 Global Unique Identifier
characters is_logout_resting tinyint unsigned 3 0
characters leveltime int unsigned 10 0
characters logout_time bigint unsigned 20 0
characters map int unsigned 10 0 Map Identifier
characters name varchar 12
characters online tinyint unsigned 3 0
characters orientation float 12 0
characters position_x float 12 0
characters position_y float 12 0
characters position_z float 12 0
characters race tinyint unsigned 3 0
characters resettalents_cost int unsigned 10 0
characters resettalents_time bigint unsigned 20 0
characters rest_bonus float 12 0
characters stable_slots bit 0 0
characters taxi_path text 65535  √  null
characters taximask longtext 2147483647  √  null
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
characters zone int unsigned 10 0
corpse corpse_type tinyint unsigned 3 0
corpse data longtext 2147483647  √  null
corpse guid int unsigned 10 0 Global Unique Identifier
corpse instance int unsigned 10 0
corpse map int unsigned 10 0 Map Identifier
corpse orientation float 12 0
corpse phaseMask smallint unsigned 5 1
corpse player int unsigned 10 0 Character Global Unique Identifier
corpse position_x float 12 0
corpse position_y float 12 0
corpse position_z float 12 0
corpse time bigint unsigned 20 0
corpse zone int unsigned 10 38 Zone Identifier
group_instance instance int unsigned 10 0
group_instance leaderGuid int unsigned 10 0
group_instance permanent bit 0 0
group_member assistant bit 0
group_member leaderGuid int unsigned 10
group_member memberGuid int unsigned 10
group_member subgroup smallint unsigned 5
groups difficulty tinyint unsigned 3 0
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
groups isRaid bit 0
groups leaderGuid int unsigned 10
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
guild BackgroundColor int 10 0
guild BankMoney bigint 19 0
guild BorderColor int 10 0
guild BorderStyle int 10 0
guild createdate datetime 19  √  null
guild EmblemColor int 10 0
guild EmblemStyle int 10 0
guild guildid int unsigned 10 0
guild info text 65535
guild leaderguid int unsigned 10 0
guild motd varchar 255
guild name varchar 255
guild_bank_eventlog DestTabId bit 0 0
guild_bank_eventlog guildid int unsigned 10 0
guild_bank_eventlog ItemOrMoney int unsigned 10 0
guild_bank_eventlog ItemStackCount tinyint unsigned 3 0
guild_bank_eventlog LogEntry bit 0 0
guild_bank_eventlog LogGuid int unsigned 10 0
guild_bank_eventlog PlayerGuid int unsigned 10 0
guild_bank_eventlog TabId bit 0 0
guild_bank_eventlog TimeStamp bigint unsigned 20 0
guild_bank_item guildid int unsigned 10 0
guild_bank_item item_entry int unsigned 10 0
guild_bank_item item_guid int unsigned 10 0
guild_bank_item SlotId tinyint unsigned 3 0
guild_bank_item TabId bit 0 0
guild_bank_right gbright tinyint unsigned 3 0
guild_bank_right guildid int unsigned 10 0
guild_bank_right rid int unsigned 10 0
guild_bank_right SlotPerDay int unsigned 10 0
guild_bank_right TabId bit 0 0
guild_bank_tab guildid int unsigned 10 0
guild_bank_tab TabIcon varchar 100
guild_bank_tab TabId bit 0 0
guild_bank_tab TabName varchar 100
guild_bank_tab TabText text 65535  √  null
guild_eventlog EventType bit 0 Event type
guild_eventlog guildid int 10 Guild Identificator
guild_eventlog LogGuid int 10 Log entry identificator
guild_eventlog NewRank tinyint 3 New rank(in case promotion/demotion)
guild_eventlog PlayerGuid1 int 10 Player 1
guild_eventlog PlayerGuid2 int 10 Player 2
guild_eventlog TimeStamp bigint 19 Event UNIX time
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
guild_member guid int unsigned 10 0
guild_member guildid int unsigned 10 0
guild_member offnote varchar 255
guild_member pnote varchar 255
guild_member rank tinyint unsigned 3 0
guild_rank BankMoneyPerDay int unsigned 10 0
guild_rank guildid int unsigned 10 0
guild_rank rid int unsigned 10
guild_rank rights int unsigned 10 0
guild_rank rname varchar 255
instance data longtext 2147483647  √  null
instance difficulty bit 0 0
instance id int unsigned 10 0
instance map int unsigned 10 0
instance resettime bigint 19 0
instance_reset mapid int unsigned 10 0
instance_reset resettime bigint 19 0
item_instance data longtext 2147483647  √  null
item_instance guid int unsigned 10 0
item_instance owner_guid int unsigned 10 0
item_text id int unsigned 10 0
item_text text longtext 2147483647  √  null
mail checked tinyint unsigned 3 0
mail cod int unsigned 10 0
mail deliver_time bigint 19 0
mail expire_time bigint 19 0
mail has_items tinyint unsigned 3 0
mail id int unsigned 10 0 Identifier
mail itemTextId int unsigned 10 0
mail mailTemplateId mediumint unsigned 8 0
mail messageType tinyint unsigned 3 0
mail money int unsigned 10 0
mail receiver int unsigned 10 0 Character Global Unique Identifier
mail sender int unsigned 10 0 Character Global Unique Identifier
mail stationery tinyint 3 41
mail subject longtext 2147483647  √  null
mail_items item_guid int 10 0
mail_items item_template int 10 0
mail_items mail_id int 10 0
mail_items receiver int unsigned 10 0 Character Global Unique Identifier
pet_aura amount int 10 0
pet_aura caster_guid bigint unsigned 20 0 Full Global Unique Identifier
pet_aura effect_index int unsigned 10 0
pet_aura guid int unsigned 10 0 Global Unique Identifier
pet_aura maxduration int 10 0
pet_aura remaincharges int 10 0
pet_aura remaintime int 10 0
pet_aura spell int unsigned 10 0
pet_aura stackcount int 10 1
pet_spell active int unsigned 10 0
pet_spell guid int unsigned 10 0 Global Unique Identifier
pet_spell spell int unsigned 10 0 Spell Identifier
pet_spell_cooldown guid int unsigned 10 0 Global Unique Identifier, Low part
pet_spell_cooldown spell int unsigned 10 0 Spell Identifier
pet_spell_cooldown time bigint unsigned 20 0
petition name varchar 255
petition ownerguid int unsigned 10
petition petitionguid int unsigned 10  √  0
petition type int unsigned 10 0
petition_sign ownerguid int unsigned 10
petition_sign petitionguid int unsigned 10 0
petition_sign player_account int unsigned 10 0
petition_sign playerguid int unsigned 10 0
petition_sign type int unsigned 10 0
saved_variables NextArenaPointDistributionTime bigint unsigned 20 0