item_sparse

Field	Type	Attributes	Key	Null	Default
ID	int	unsigned	PRI	NO	0
AllowableRace	bigint	signed		NO	0
Description	text			YES	NULL
Display3	text			YES	NULL
Display2	text			YES	NULL
Display1	text			YES	NULL
Display	text			YES	NULL
ExpansionID	int	signed		NO	0
DmgVariance	float			NO	0
LimitCategory	int	signed		NO	0
DurationInInventory	int	unsigned		NO	0
QualityModifier	float			NO	0
BagFamily	int	unsigned		NO	0
StartQuestID	int	signed		NO	0
LanguageID	int	signed		NO	0
ItemRange	float			NO	0
StatPercentageOfSocket1	float			NO	0
StatPercentageOfSocket2	float			NO	0
StatPercentageOfSocket3	float			NO	0
StatPercentageOfSocket4	float			NO	0
StatPercentageOfSocket5	float			NO	0
StatPercentageOfSocket6	float			NO	0
StatPercentageOfSocket7	float			NO	0
StatPercentageOfSocket8	float			NO	0
StatPercentageOfSocket9	float			NO	0
StatPercentageOfSocket10	float			NO	0
StatPercentEditor1	int	signed		NO	0
StatPercentEditor2	int	signed		NO	0
StatPercentEditor3	int	signed		NO	0
StatPercentEditor4	int	signed		NO	0
StatPercentEditor5	int	signed		NO	0
StatPercentEditor6	int	signed		NO	0
StatPercentEditor7	int	signed		NO	0
StatPercentEditor8	int	signed		NO	0
StatPercentEditor9	int	signed		NO	0
StatPercentEditor10	int	signed		NO	0
StatModifierBonusStat1	int	signed		NO	0
StatModifierBonusStat2	int	signed		NO	0
StatModifierBonusStat3	int	signed		NO	0
StatModifierBonusStat4	int	signed		NO	0
StatModifierBonusStat5	int	signed		NO	0
StatModifierBonusStat6	int	signed		NO	0
StatModifierBonusStat7	int	signed		NO	0
StatModifierBonusStat8	int	signed		NO	0
StatModifierBonusStat9	int	signed		NO	0
StatModifierBonusStat10	int	signed		NO	0
Stackable	int	signed		NO	0
MaxCount	int	signed		NO	0
MinReputation	int	signed		NO	0
RequiredAbility	int	unsigned		NO	0
SellPrice	int	unsigned		NO	0
BuyPrice	int	unsigned		NO	0
VendorStackCount	int	unsigned		NO	0
PriceVariance	float			NO	0
PriceRandomValue	float			NO	0
Flags1	int	signed		NO	0
Flags2	int	signed		NO	0
Flags3	int	signed		NO	0
Flags4	int	signed		NO	0
Flags5	int	signed		NO	0
FactionRelated	int	signed		NO	0
ModifiedCraftingReagentItemID	int	signed		NO	0
ContentTuningID	int	signed		NO	0
PlayerLevelToItemLevelCurveID	int	signed		NO	0
ItemNameDescriptionID	smallint	unsigned		NO	0
RequiredTransmogHoliday	smallint	unsigned		NO	0
RequiredHoliday	smallint	unsigned		NO	0
GemProperties	smallint	unsigned		NO	0
SocketMatchEnchantmentId	smallint	unsigned		NO	0
TotemCategoryID	smallint	unsigned		NO	0
InstanceBound	smallint	unsigned		NO	0
ZoneBound1	smallint	unsigned		NO	0
ZoneBound2	smallint	unsigned		NO	0
ItemSet	smallint	unsigned		NO	0
LockID	smallint	unsigned		NO	0
PageID	smallint	unsigned		NO	0
ItemDelay	smallint	unsigned		NO	0
MinFactionID	smallint	unsigned		NO	0
RequiredSkillRank	smallint	unsigned		NO	0
RequiredSkill	smallint	unsigned		NO	0
ItemLevel	smallint	unsigned		NO	0
AllowableClass	smallint	signed		NO	0
ArtifactID	tinyint	unsigned		NO	0
SpellWeight	tinyint	unsigned		NO	0
SpellWeightCategory	tinyint	unsigned		NO	0
SocketType1	tinyint	unsigned		NO	0
SocketType2	tinyint	unsigned		NO	0
SocketType3	tinyint	unsigned		NO	0
SheatheType	tinyint	unsigned		NO	0
Material	tinyint	unsigned		NO	0
PageMaterialID	tinyint	unsigned		NO	0
Bonding	tinyint	unsigned		NO	0
DamageDamageType	tinyint	unsigned		NO	0
ContainerSlots	tinyint	unsigned		NO	0
RequiredPVPMedal	tinyint	unsigned		NO	0
RequiredPVPRank	tinyint	unsigned		NO	0
RequiredLevel	tinyint	signed		NO	0
InventoryType	tinyint	signed		NO	0
OverallQualityID	tinyint	signed		NO	0
VerifiedBuild	int	signed	PRI	NO	0

¶ Structure

¶ Description of fields

¶ ID

¶ AllowableRace

¶ Description

¶ Display3

¶ Display2

¶ Display1

¶ Display

¶ ExpansionID

¶ DmgVariance

¶ LimitCategory

¶ DurationInInventory

¶ QualityModifier

¶ BagFamily

¶ StartQuestID

¶ LanguageID

¶ ItemRange

¶ StatPercentageOfSocket1

¶ StatPercentageOfSocket2

¶ StatPercentageOfSocket3

¶ StatPercentageOfSocket4

¶ StatPercentageOfSocket5

¶ StatPercentageOfSocket6

¶ StatPercentageOfSocket7

¶ StatPercentageOfSocket8

¶ StatPercentageOfSocket9

¶ StatPercentageOfSocket10

¶ StatPercentEditor1

¶ StatPercentEditor2

¶ StatPercentEditor3

¶ StatPercentEditor4

¶ StatPercentEditor5

¶ StatPercentEditor6

¶ StatPercentEditor7

¶ StatPercentEditor8

¶ StatPercentEditor9

¶ StatPercentEditor10

¶ StatModifierBonusStat1

¶ StatModifierBonusStat2

¶ StatModifierBonusStat3

¶ StatModifierBonusStat4

¶ StatModifierBonusStat5

¶ StatModifierBonusStat6

¶ StatModifierBonusStat7

¶ StatModifierBonusStat8

¶ StatModifierBonusStat9

¶ StatModifierBonusStat10

¶ Stackable

¶ MaxCount

¶ MinReputation

¶ RequiredAbility

¶ SellPrice

¶ BuyPrice

¶ VendorStackCount

¶ PriceVariance

¶ PriceRandomValue

¶ Flags1

¶ Flags2

¶ Flags3

¶ Flags4

¶ Flags5

¶ FactionRelated

¶ ModifiedCraftingReagentItemID

¶ ContentTuningID

¶ PlayerLevelToItemLevelCurveID

¶ ItemNameDescriptionID

¶ RequiredTransmogHoliday

¶ RequiredHoliday

¶ GemProperties

¶ SocketMatchEnchantmentId

¶ TotemCategoryID

¶ InstanceBound

¶ ZoneBound1

¶ ZoneBound2

¶ ItemSet

¶ LockID

¶ PageID

¶ ItemDelay

¶ MinFactionID