Database:Inventoryitems

The inventoryitems records details with respect to the avatar's personal property (assets)''     (back to Database Documentation)

inventoryitems Table Structure
The structure of the inventoryitems table is as follows:

Note: When assetType is 24, the item is a link. In this case, assetID is not the id of the asset. It is instead the inventoryID of another inventory item, whose assetID points to the target asset.

(back to Database Documentation)

inventoryitems Fields
assetID Refers to the related row in the assets table.

Calling Cards do not create assets so if assetType=2 (see next field) this field should be "00000000-0000-0000-0000-000000000000".

assetType Type of asset (e.g., script, texture, or shape - asset type list)

inventoryName Text of the name of the inventory item as it appears in the client inventory interface.

inventoryDescription Text of the description of the inventory item as it appears in the client inventory interface.

inventoryNextPermissions Permissions that will be applied to the item if/when it is transferred to another avatar. Permission values can be found at OpenSim:Permissions

inventoryCurrentPermissions Permissions on the the item for the current posessor of the item. Permission values can be found at OpenSim:Permissions

invType Type of inventory item. This is a subset of enum InventoryType for items only.

Subtype for wearable (assets type 5 and 13).

The subtype is contained inside the asset data (LLSD format). It does not appear in the table.

It is encoded in the lower part of the 'flags' column'.

creatorID UUID of the item's original creator.

inventoryBasePermissions Base permissions of the object. Permission values can be found at OpenSim:Permissions

inventoryEveryOnePermissions Permissions with respect to everyone but the owner of the item. Permission values can be found at OpenSim:Permissions

salePrice Sale price of the item.

saleType presently unknown

creationDate Date the item was created

groupID UUID of the group that the items is 'deeded' to

groupOwned group ownership flags

flags

inventoryID UUID of inventory item

avatarID UUID of item's owner

parentFolderID UUID of the folder that contains the item. This must match the folderID of an inventory folders table entry.

inventoryGroupPermissions Permissions with respect to the owner group of the item. Permission values can be found at OpenSim:Permissions

(back to Database Documentation)