Database:Avatarappearance
From OpenSimulator
Line 43: | Line 43: | ||
'''Owner'''<br> | '''Owner'''<br> | ||
+ | UUID of avatar's owner. | ||
+ | <br> | ||
+ | <br> | ||
'''Serial'''<br> | '''Serial'''<br> | ||
+ | Monotonic counter gets incremented by 1 each time the avatar is updated. | ||
+ | <br><br> | ||
'''Visual_Params'''<br> | '''Visual_Params'''<br> | ||
+ | Byte array of some 240 or so numerically descriptive shape parameters describing the look of the avatar. | ||
+ | <br> | ||
+ | <br> | ||
'''Texture'''<br> | '''Texture'''<br> | ||
− | '''Avatar_Height'''<br> | + | The avatar's 'baked' texture. |
+ | <br> | ||
+ | <br> | ||
+ | '''Avatar_Height''' | ||
+ | Height of the avatar in meters.<br> | ||
+ | <br> | ||
+ | <br> | ||
'''Body_Item'''<br> | '''Body_Item'''<br> | ||
− | Refers to inventory item for Body<br> | + | Refers to inventory item for Body |
− | '''Body_Asset''' | + | <br> |
− | Refers to item in assets for Body<br> | + | <br> |
− | '''Skin_Item''' | + | '''Body_Asset'''<br> |
− | Refers to inventory item for Skin<br> | + | Refers to item in assets for Body |
− | '''Skin_Asset''' | + | <br> |
− | Refers to item in assets for Skin<br> | + | <br> |
− | '''Hair_Item''' | + | '''Skin_Item'''<br> |
− | Refers to inventory item for Hair<br> | + | Refers to inventory item for Skin |
− | '''Hair_Asset''' | + | <br> |
− | Refers to item in assets for Hair<br> | + | <br> |
− | '''Eyes_Item''' | + | '''Skin_Asset'''<br> |
− | Refers to inventory item for Eyes<br> | + | Refers to item in assets for Skin |
− | '''Eyes_Asset''' | + | <br> |
− | Refers to item in assets for Eyes<br> | + | <br> |
− | '''Shirt_Item''' | + | '''Hair_Item'''<br> |
− | Refers to inventory item for Shirt<br> | + | Refers to inventory item for Hair |
− | '''Shirt_Asset''' | + | <br> |
− | Refers to item in assets for Shirt<br> | + | <br> |
− | '''Pants_Item''' | + | '''Hair_Asset'''<br> |
− | Refers to inventory item for Pants<br> | + | Refers to item in assets for Hair |
− | '''Pants_Asset''' | + | <br> |
− | Refers to item in assets for Pants<br> | + | <br> |
− | '''Shoes_Item''' | + | '''Eyes_Item'''<br> |
− | Refers to inventory item for Shoes<br> | + | Refers to inventory item for Eyes |
− | '''Shoes_Asset''' | + | <br> |
− | Refers to item in assets for Shoes<br> | + | <br> |
− | '''Socks_Item''' | + | '''Eyes_Asset'''<br> |
− | Refers to inventory item for Socks<br> | + | Refers to item in assets for Eyes |
− | '''Socks_Asset''' | + | <br> |
− | Refers to item in assets for Socks<br> | + | <br> |
− | '''Jacket_Item''' | + | '''Shirt_Item'''<br> |
− | Refers to inventory item for Jacket<br> | + | Refers to inventory item for Shirt |
− | '''Jacket_Asset''' | + | <br> |
− | Refers to item in assets for Jacket<br> | + | <br> |
− | '''Gloves_Item''' | + | '''Shirt_Asset'''<br> |
− | Refers to inventory item for Gloves<br> | + | Refers to item in assets for Shirt |
− | '''Gloves_Asset''' | + | <br> |
− | Refers to item in assets for Gloves<br> | + | <br> |
− | '''Undershirt_Item''' | + | '''Pants_Item'''<br> |
− | Refers to inventory item for Undershirt<br> | + | Refers to inventory item for Pants |
− | '''Undershirt_Asset''' | + | <br> |
− | Refers to item in assets for Undershirt<br> | + | <br> |
− | '''Underpants_Item''' | + | '''Pants_Asset'''<br> |
− | Refers to inventory item for Underpants<br> | + | Refers to item in assets for Pants |
− | '''Underpants_Asset''' | + | <br> |
− | Refers to item in assets for Underpants<br> | + | <br> |
− | '''Skirt_Asset''' | + | '''Shoes_Item'''<br> |
− | Refers to item in assets for Skirt<br> | + | Refers to inventory item for Shoes |
− | '''Skirt_Item''' | + | <br> |
− | Refers to inventory item for Skirt | + | <br> |
+ | '''Shoes_Asset'''<br> | ||
+ | Refers to item in assets for Shoes | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Socks_Item'''<br> | ||
+ | Refers to inventory item for Socks | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Socks_Asset'''<br> | ||
+ | Refers to item in assets for Socks | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Jacket_Item'''<br> | ||
+ | Refers to inventory item for Jacket | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Jacket_Asset'''<br> | ||
+ | Refers to item in assets for Jacket | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Gloves_Item'''<br> | ||
+ | Refers to inventory item for Gloves | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Gloves_Asset'''<br> | ||
+ | Refers to item in assets for Gloves | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Undershirt_Item'''<br> | ||
+ | Refers to inventory item for Undershirt | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Undershirt_Asset'''<br> | ||
+ | Refers to item in assets for Undershirt | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Underpants_Item'''<br> | ||
+ | Refers to inventory item for Underpants | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Underpants_Asset'''<br> | ||
+ | Refers to item in assets for Underpants | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Skirt_Asset'''<br> | ||
+ | Refers to item in assets for Skirt | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Skirt_Item'''<br> | ||
+ | Refers to inventory item for Skirt | ||
<hr> | <hr> | ||
(back to [[Database Documentation]])<br> | (back to [[Database Documentation]])<br> |
Revision as of 11:17, 30 July 2008
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 | |||
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)