Inventory Items Table (MSSQL)

Names of all in-game items.

Inventory Items

  • Table Name: invItems
  • Description: Basic attributes of all static items.

Columns

Column Type Default Xrefs Description
itemID PK NN bigint invNames.itemID
invPositions.itemID
invUniqueNames.itemID
mapDenormalize.itemID
In-game item ID.
typeID NN int crpNPCCorporationTrades.typeID
dgmTypeAttributes.typeID
dgmTypeEffects.typeID
invTypeMaterials.typeID
invTypeReactions.typeID
typeIDs
mapDenormalize.typeID
Type of in-game item.
ownerID NN int ramAssemblyLineStations.ownerID Item owner ID.
locationID NN bigint agtAgents.locationID
mapLandmarks.locationID
mapLocationScenes.locationID
mapLocationWormholeClasses.locationID
Item location ID.
flagID NN smallint invFlags.flagID Item flags.
quantity NN int Item quantity.