Back-to:Characters
The `item_instance` table |
This table holds individual item instance information for all items currently equipped in some kind of character bag or bank, in auctionhouses, in guild banks or in mails.
Structure |
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned | PRI | NO | 0 |
|
| |
mediumint(8) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 1 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
tinytext | signed |
| YES |
|
|
| |
mediunint(8) | unsigned |
| NO | 0 |
|
| |
text | signed |
| NO |
|
|
| |
smallint(5) | signed |
| NO | 0 |
|
| |
smallint(5) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
text | signed |
| YES |
|
|
|
Description of the fields |
The GUID of the item. This number is unique for each item instance.
Item entry.
The GUID of the character who has ownership of this item. See characters.guid
GUID of character who created the item.
GUID of character who created the item.
Current number of item copies in the stack.
field-no-description|6
The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers.
field-no-description|8
Enchantments from SpellItemEnchantment.dbc
field-no-description|10
Current item durability.
Time in seconds
The text contained in that specific item.
data-anchor=