characters contains 362 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
character_pet	abdata	longtext	2147483647	√		null
guild	createdate	datetime	19	√		null
characters	data	longtext	2147483647	√		null
corpse	data	longtext	2147483647	√		null
instance	data	longtext	2147483647	√		null
item_instance	data	longtext	2147483647	√		null
character_pet	modelid	int unsigned	10	√		0
character_pet	name	varchar	100	√		Pet
petition	petitionguid	int unsigned	10	√		0
character_db_version	required_7644_01_characters_character_pet	bit	1	√		null
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_text	text	65535	√		null
account_data	account	int unsigned	10			0
character_tutorial	account	bigint unsigned	20		√		Account Identifier
characters	account	int unsigned	10			0	Account Identifier
character_declinedname	accusative	varchar	15
character_pet_declinedname	accusative	varchar	12
character_achievement	achievement	int	10
character_action	action	smallint unsigned	5			0
character_spell	active	tinyint unsigned	3			1
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
group_member	assistant	bit	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
bugreport	content	varchar	255
corpse	corpse_type	tinyint unsigned	3			0
character_achievement_progress	counter	int	10
character_pet	CreatedBySpell	int unsigned	10			0
character_achievement_progress	criteria	int	10
character_pet	curhappiness	int unsigned	10			0
character_pet	curhealth	int unsigned	10			1
character_pet	curmana	int unsigned	10			0
account_data	data	longtext	2147483647
character_achievement	date	int	10
character_achievement_progress	date	int	10
character_declinedname	dative	varchar	15
character_pet_declinedname	dative	varchar	12
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
guild_eventlog	EventType	bit	0				Event type
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
character_declinedname	genitive	varchar	15
character_pet_declinedname	genitive	varchar	12
arena_team_member	guid	int unsigned	10			0
character_achievement	guid	int	10
character_achievement_progress	guid	int	10
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
character_tutorial	guid	unknown	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_eventlog	guildid	int	10				Guild Identificator
guild_member	guildid	int unsigned	10			0
guild_rank	guildid	int unsigned	10			0
mail	has_items	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
auctionhouse	id	int unsigned	10			0
bugreport	id	int	10		√		Identifier
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
guild	info	text	65535
character_instance	instance	int unsigned	10			0
corpse	instance	int unsigned	10			0
group_instance	instance	int unsigned	10			0
character_declinedname	instrumental	varchar	15
character_pet_declinedname	instrumental	varchar	12
characters	is_logout_resting	tinyint unsigned	3			0
groups	isRaid	bit	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
group_member	leaderGuid	int unsigned	10
groups	leaderGuid	int unsigned	10
guild	leaderguid	int unsigned	10			0
character_pet	level	int unsigned	10			1
characters	leveltime	int unsigned	10			0
guild_bank_eventlog	LogEntry	bit	0			0
guild_bank_eventlog	LogGuid	int unsigned	10			0
guild_eventlog	LogGuid	int	10				Log entry identificator
characters	logout_time	bigint unsigned	20			0
groups	looterGuid	int unsigned	10
groups	lootMethod	tinyint unsigned	3
groups	lootThreshold	tinyint unsigned	3
mail_items	mail_id	int	10			0
mail	mailTemplateId	mediumint unsigned	8			0
groups	mainAssistant	int unsigned	10
groups	mainTank	int unsigned	10
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
group_member	memberGuid	int unsigned	10
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
mail	money	int unsigned	10			0
guild	motd	varchar	255
arena_team	name	char	255
characters	name	varchar	12
guild	name	varchar	255
petition	name	varchar	255
guild_eventlog	NewRank	tinyint	3				New rank(in case promotion/demotion)
saved_variables	NextArenaPointDistributionTime	bigint unsigned	20			0
character_social	note	varchar	48				Friend Note
guild_member	offnote	varchar	255
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
petition	ownerguid	int unsigned	10
petition_sign	ownerguid	int unsigned	10
character_instance	permanent	bit	0			0
group_instance	permanent	bit	0			0
arena_team_member	personal_rating	int unsigned	10			0
petition_sign	petitionguid	int unsigned	10			0
character_pet	PetType	tinyint unsigned	3			0
corpse	phaseMask	smallint unsigned	5			1
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
guild_eventlog	PlayerGuid1	int	10				Player 1
guild_eventlog	PlayerGuid2	int	10				Player 2
guild_member	pnote	varchar	255
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_declinedname	prepositional	varchar	15
character_pet_declinedname	prepositional	varchar	12
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	rid	int unsigned	10
guild_rank	rights	int unsigned	10			0
guild_rank	rname	varchar	255
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_aura	stackcount	int	10			1
pet_aura	stackcount	int	10			1
character_reputation	standing	int	10			0
auctionhouse	startbid	int	10			0
mail	stationery	tinyint	3			41
character_queststatus	status	int unsigned	10			0
group_member	subgroup	smallint unsigned	5
guild_bank_tab	TabIcon	varchar	100
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
guild_bank_tab	TabName	varchar	100
character_pet	talentpoints	int unsigned	10			0
character_ticket	ticket_id	int unsigned	10		√
character_ticket	ticket_lastchange	timestamp	19			CURRENT_TIMESTAMP
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
guild_eventlog	TimeStamp	bigint	19				Event UNIX time
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
bugreport	type	varchar	255
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
corpse	zone	int unsigned	10			38	Zone Identifier