Editing OpenSimulator Internals/Databases (section)

=== primitems ===

Inventory items inside prim contents. One row per item.

{| class="wikitable"
! Field !! Notes
|-
| itemID || Primary key
|-
| primID || Foreign key to prims.UUID -- which prim contains this item
|-
| assetID || Foreign key to osimdev_robust.assets.id -- cross-database reference
|-
| assetType || Asset type
|-
| invType || Inventory type
|-
| name || Item name
|-
| CreatorID || varchar(255) -- accommodates HyperGrid URIs
|-
| ownerID || Owner UUID
|-
| parentFolderID || Folder UUID (within prim inventory)
|-
| nextPermissions/currentPermissions/basePermissions/everyonePermissions/groupPermissions || Permission bitmasks
|-
| salePrice/saleType || Sale settings
|-
| creationDate || Bigint Unix timestamp
|}

The assetID field in primitems references osimdev_robust.assets -- a cross-database foreign key. The asset data lives in the grid database; only the inventory record lives in the region database.

Example: notecard "test note" (assetType 7) in the Box object, assetID 6f2d7ffb-99f4-431a-919e-eb8cd174a620 confirmed present in osimdev_robust.assets.

----