Editing OpenSimulator Internals/Databases (section)

=== prims ===

103 fields. One row per prim. The root prim of a linked object has UUID = SceneGroupID.

Key fields:

{| class="wikitable"
! Field !! Notes
|-
| UUID || Primary key -- prim UUID
|-
| SceneGroupID || UUID of the root prim of the linked object this prim belongs to
|-
| RegionUUID || Foreign key to regions table in osimdev_robust
|-
| Name || Prim name
|-
| OwnerID || Owner UUID
|-
| CreatorID || Creator UUID or HyperGrid URI (varchar 255)
|-
| LinkNumber || Position in linkset (1 = root, 2+ = children)
|-
| GroupPositionX/Y/Z || World position of the linkset root in region-local metres
|-
| PositionX/Y/Z || Position relative to the linkset root
|-
| RotationX/Y/Z/W || Quaternion rotation
|-
| ScaleX/Y/Z || Scale (in primshapes table)
|-
| ObjectFlags || Prim property flags bitmask
|-
| OwnerMask/NextOwnerMask/GroupMask/EveryoneMask/BaseMask || Permission bitmasks
|-
| Material || Material type (default 3 = wood)
|-
| PhysicsShapeType || Physics shape (0=prim, 1=none, 2=convex hull)
|-
| Density/Friction/Restitution/GravityModifier || Physics properties
|-
| SitTargetOffset/Orient || Sit target position and orientation
|-
| TextureAnimation || Blob -- animated texture data
|-
| ParticleSystem || Blob -- particle system data
|-
| KeyframeMotion || Blob -- keyframe animation path
|-
| Vehicle || Text -- vehicle parameters
|-
| DynAttrs || Text -- dynamic attributes (LSL)
|-
| sopanims || Blob -- object animation data
|-
| lnkstBinData || Blob -- linkset binary data
|-
| pseudocrc || Integer -- change detection checksum
|}

'''Important:''' When querying object names by SceneGroupID, use WHERE UUID = SceneGroupID to get the root prim name. Using MIN(Name) or similar aggregates will return a child prim name, not the object name.

Sample objects on osimdev T1 (472 prims across 8 linksets):

{| class="wikitable"
! Name !! Prims !! World Position
|-
| Athena Mesh Body Skin Applier (HUD) || 193 || 178, 264, 26
|-
| Brown House || 181 || 238, 255, 24
|-
| 4 Chair Set || 54 || 244, 266, 25
|-
| Athena Bento BoM Mesh Body 6.5 (worn attachment) || 36 || 181, 284, 24
|-
| Brown House Sculpts || 5 || 252, 255, 26
|-
| Sofa || 1 || 247, 272, 25
|-
| Object (cube) || 1 || 188, 275, 24
|-
| Box || 1 || 219, 281, 24
|}

----