Avatarattachments
From OpenSimulator
 |
Languages: |
|
avatarattachments Records details of items attached to avatars (back to Database Documentation)
The current structure of the avatarattachments table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| UUID | char(36) | NO | NULL | |||
| attachpoint | integer | NULL | ||||
| item | char(36) | NO | NULL | |||
| asset | char(36) | NO | NULL | |||
(back to Database Documentation)
UUID
The UUID of the user holding the attachment. As a user can attach several items to different points and each attached item creates a new row in the table this is not a unique key.
Attachpoint
The point of the avatar to which the item is attached decoded as:
| Value | Attachment Point | |
| 1 | Chest | |
| 2 | Head | |
| 3 | Left Shoulder | |
| 4 | Right Shoulder | |
| 5 | Left Hand | |
| 6 | Right Hand | |
| 7 | Left Foot | |
| 8 | Right Foot | |
| 9 | Back | |
| 10 | Pelvis | |
| 11 | Mouth | |
| 12 | Chin | |
| 13 | Left Ear | |
| 14 | Right Ear | |
| 15 | Left Eye | |
| 16 | Right Eye | |
| 17 | Nose | |
| 18 | Right Upper Arm | |
| 19 | Right Forearm | |
| 20 | Left Upper Arm | |
| 21 | Left Forearm | |
| 22 | Right Hip | |
| 23 | Right Upper Leg | |
| 24 | Right Lower Leg | |
| 25 | Left Hip | |
| 26 | Left Upper Leg | |
| 27 | Left Lower Leg | |
| 28 | Stomach | |
| 29 | Right Pectoral | |
| 30 | Left Pectoral | |
| 31 | HUD Centre 2 | |
| 32 | HUD Top Right | |
| 33 | HUD Top | |
| 34 | HUD Top Left | |
| 35 | HUD Centre | |
| 36 | HUD Bottom Right | |
| 37 | HUD Bottom | |
| 38 | HUD Bottom Left |
Item
The UUID of the inventory item attached.
Asset
The UUID of the asset referenced by the "item".
(back to Database Documentation)
