DB/Item

≥ 

Structure

Column	Field	Type	Notes
0	itemID	Integer
1	ItemClass	iRefID
2	ItemSubClass	iRefID
3	sound_override_subclassid	Integer	-1 - 20, mostly -1, same as ItemCache.wdb column5
4	MaterialID	iRefID	-1 - 8
5	ItemDisplayInfo	iRefID
6	InventorySlotID	Integer	These inventory slot ID's are used to determine how an item may be equipped, see Inventory_Slots
7	SheathID	Integer	0 -4, mostly 0

Pre 3.*

Column	Field	Type	Notes
0	itemID	Integer
1	ItemDisplayInfo	iRefID
2	InventorySlotID	Integer	These inventory slot ID's are used to determine how an item may be equipped, see below
3	ItemClass	iRefID

Item.db2

new in cataclysm

https://github.com/Shauren/AdbToSqlConverter/blob/master/Formats/Item.cs

≥ 

Structure

Column	Field	Type	Notes
0	itemID	Integer
1	FileDataID	iRefID	Contain Icons Path Refer to FileData
2	ItemClass	iRefID
3	ItemSubClass	iRefID
4	sound_override_subclassid	Integer	-1 - 20, mostly -1, same as ItemCache.wdb column5
5	MaterialID	iRefID	-1 - 8
6	InventorySlotID	Integer	These inventory slot ID's are used to determine how an item may be equipped, see Inventory_Slots
7	SheathID	Integer	0 -4, mostly 0
8	GrouSoundsID	Integer	Moved from ItemDisplayInfo

• Note : Item DisplayID You may refer to ItemAppearance.db2 & ItemModifiedAppearance.db2 however for some they remain unfound.