item_instance

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	bigint	unsigned	PRI	NO	0
itemEntry	int	unsigned		NO	0
owner_guid	bigint	unsigned	MUL	NO	0
creatorGuid	bigint	unsigned		NO	0
giftCreatorGuid	bigint	unsigned		NO	0
count	int	unsigned		NO	1
duration	int	signed		NO	0
charges	tinytext			YES	NULL
flags	int	unsigned		NO	0
enchantments	text			NO
randomBonusListId	int	unsigned		NO	0
durability	smallint	unsigned		NO	0
playedTime	int	unsigned		NO	0
createTime	bigint	signed		NO	0
text	text			YES	NULL
battlePetSpeciesId	int	unsigned		NO	0
battlePetBreedData	int	unsigned		NO	0
battlePetLevel	smallint	unsigned		NO	0
battlePetDisplayId	int	unsigned		NO	0
context	tinyint	unsigned		NO	0
bonusListIDs	text			YES	NULL

 

Description of fields

guid

- no description -
 

itemEntry

- no description -
 

owner_guid

- no description -
 

creatorGuid

- no description -
 

giftCreatorGuid

- no description -
 

count

- no description -
 

duration

- no description -
 

charges

- no description -
 

flags

- no description -
 

enchantments

- no description -
 

randomBonusListId

- no description -
 

durability

- no description -
 

playedTime

- no description -
 

createTime

- no description -
 

text

- no description -
 

battlePetSpeciesId

- no description -
 

battlePetBreedData

- no description -
 

battlePetLevel

- no description -
 

battlePetDisplayId

- no description -
 

context

- no description -
 

bonusListIDs

- no description -