Database:Avatarappearance
From OpenSimulator
avatarappearance Records avatar appearance details, i.e., worn wearables (back to Database Documentation)
The current structure of the avatar appearance table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| Owner | char(36) | NO | PRI | NULL | ||
| Serial | int(10) unsigned | NO | NULL | |||
| Visual_Params | blob | NO | NULL | |||
| Texture | blob | NO | NULL | |||
| Avatar_Height | float | NO | NULL | |||
| Body_Item | char(36) | NO | NULL | |||
| Body_Asset | char(36) | NO | NULL | |||
| Skin_Item | char(36) | NO | PRI | NULL | ||
| Skin_Asset | char(36) | NO | NULL | |||
| Hair_Item | char(36) | NO | NULL | |||
| Hair_Asset | char(36) | NO | NULL | |||
| Eyes_Item | char(36) | NO | PRI | NULL | ||
| Eyes_Asset | char(36) | NO | UNI | NULL | ||
| Shirt_Item | char(36) | NO | UNI | NULL | ||
| Shirt_Asset | char(36) | NO | NULL | |||
| Pants_Item | char(36) | NO | NULL | |||
| Pants_Asset | char(36) | NO | NULL | |||
| Shoes_Item | char(36) | NO | NULL | |||
| Shoes_Asset | char(36) | NO | NULL | |||
| Socks_Item | char(36) | NO | NULL | |||
| Socks_Asset | char(36) | NO | NULL | |||
| Jacket_Item | char(36) | NO | NULL | |||
| Jacket_Asset | char(36) | NO | NULL | |||
| Gloves_Item | char(36) | NO | NULL | |||
| Gloves_Asset | char(36) | NO | NULL | |||
| Undershirt_Item | char(36) | NO | NULL | |||
| Undershirt_Asset | char(36) | NO | NULL | |||
| Underpants_Item | char(36) | NO | NULL | |||
| Underpants_Asset | char(36) | NO | NULL | |||
| Skirt_Asset | char(36) | NO | NULL | |||
| Skirt_Item | char(36) | NO | NULL | |||
(back to Database Documentation)
Owner
UUID of avatar's owner.
Serial
Monotonic counter gets incremented by 1 each time the avatar is updated.
Visual_Params
Byte array of some 240 or so numerically descriptive shape parameters describing the look of the avatar.
Texture
The avatar's 'baked' texture.
Avatar_Height
Height of the avatar in meters.
Body_Item
Refers to inventory item for Body
Body_Asset
Refers to item in assets for Body
Skin_Item
Refers to inventory item for Skin
Skin_Asset
Refers to item in assets for Skin
Hair_Item
Refers to inventory item for Hair
Hair_Asset
Refers to item in assets for Hair
Eyes_Item
Refers to inventory item for Eyes
Eyes_Asset
Refers to item in assets for Eyes
Shirt_Item
Refers to inventory item for Shirt
Shirt_Asset
Refers to item in assets for Shirt
Pants_Item
Refers to inventory item for Pants
Pants_Asset
Refers to item in assets for Pants
Shoes_Item
Refers to inventory item for Shoes
Shoes_Asset
Refers to item in assets for Shoes
Socks_Item
Refers to inventory item for Socks
Socks_Asset
Refers to item in assets for Socks
Jacket_Item
Refers to inventory item for Jacket
Jacket_Asset
Refers to item in assets for Jacket
Gloves_Item
Refers to inventory item for Gloves
Gloves_Asset
Refers to item in assets for Gloves
Undershirt_Item
Refers to inventory item for Undershirt
Undershirt_Asset
Refers to item in assets for Undershirt
Underpants_Item
Refers to inventory item for Underpants
Underpants_Asset
Refers to item in assets for Underpants
Skirt_Asset
Refers to item in assets for Skirt
Skirt_Item
Refers to inventory item for Skirt
(back to Database Documentation)
