Database:Avatarappearance

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
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><br>
+
<br>
Refers to item in assets for Body<br>
+
<br>
'''Skin_Item'''<br><br>
+
'''Body_Asset'''<br>
Refers to inventory item for Skin<br>
+
Refers to item in assets for Body
'''Skin_Asset'''<br><br>
+
<br>
Refers to item in assets for Skin<br>
+
<br>
'''Hair_Item'''<br><br>
+
'''Skin_Item'''<br>
Refers to inventory item for Hair<br>
+
Refers to inventory item for Skin
'''Hair_Asset'''<br><br>
+
<br>
Refers to item in assets for Hair<br>
+
<br>
'''Eyes_Item'''<br><br>
+
'''Skin_Asset'''<br>
Refers to inventory item for Eyes<br>
+
Refers to item in assets for Skin
'''Eyes_Asset'''<br><br>
+
<br>
Refers to item in assets for Eyes<br>
+
<br>
'''Shirt_Item'''<br><br>
+
'''Hair_Item'''<br>
Refers to inventory item for Shirt<br>
+
Refers to inventory item for Hair
'''Shirt_Asset'''<br><br>
+
<br>
Refers to item in assets for Shirt<br>
+
<br>
'''Pants_Item'''<br><br>
+
'''Hair_Asset'''<br>
Refers to inventory item for Pants<br>
+
Refers to item in assets for Hair
'''Pants_Asset'''<br><br>
+
<br>
Refers to item in assets for Pants<br>
+
<br>
'''Shoes_Item'''<br><br>
+
'''Eyes_Item'''<br>
Refers to inventory item for Shoes<br>
+
Refers to inventory item for Eyes
'''Shoes_Asset'''<br><br>
+
<br>
Refers to item in assets for Shoes<br>
+
<br>
'''Socks_Item'''<br><br>
+
'''Eyes_Asset'''<br>
Refers to inventory item for Socks<br>
+
Refers to item in assets for Eyes
'''Socks_Asset'''<br><br>
+
<br>
Refers to item in assets for Socks<br>
+
<br>
'''Jacket_Item'''<br><br>
+
'''Shirt_Item'''<br>
Refers to inventory item for Jacket<br>
+
Refers to inventory item for Shirt
'''Jacket_Asset'''<br><br>
+
<br>
Refers to item in assets for Jacket<br>
+
<br>
'''Gloves_Item'''<br><br>
+
'''Shirt_Asset'''<br>
Refers to inventory item for Gloves<br>
+
Refers to item in assets for Shirt
'''Gloves_Asset'''<br><br>
+
<br>
Refers to item in assets for Gloves<br>
+
<br>
'''Undershirt_Item'''<br><br>
+
'''Pants_Item'''<br>
Refers to inventory item for Undershirt<br>
+
Refers to inventory item for Pants
'''Undershirt_Asset'''<br><br>
+
<br>
Refers to item in assets for Undershirt<br>
+
<br>
'''Underpants_Item'''<br><br>
+
'''Pants_Asset'''<br>
Refers to inventory item for Underpants<br>
+
Refers to item in assets for Pants
'''Underpants_Asset'''<br><br>
+
<br>
Refers to item in assets for Underpants<br>
+
<br>
'''Skirt_Asset'''<br><br>
+
'''Shoes_Item'''<br>
Refers to item in assets for Skirt<br>
+
Refers to inventory item for Shoes
'''Skirt_Item'''<br><br>
+
<br>
Refers to inventory item for Skirt<br>
+
<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>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>

Revision as of 12: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
TypeNullKeyDefaultExtra
 
Ownerchar(36)NOPRINULL 
Serialint(10) unsignedNONULL
Visual_ParamsblobNONULL
TextureblobNONULL
Avatar_HeightfloatNONULL
Body_Itemchar(36)NONULL
Body_Assetchar(36)NONULL
Skin_Itemchar(36)NOPRINULL
Skin_Assetchar(36)NONULL
Hair_Itemchar(36)NONULL
Hair_Assetchar(36)NONULL
Eyes_Itemchar(36)NOPRINULL
Eyes_Assetchar(36)NOUNINULL
Shirt_Itemchar(36)NOUNINULL
Shirt_Assetchar(36)NONULL
Pants_Itemchar(36)NONULL
Pants_Assetchar(36)NONULL
Shoes_Itemchar(36)NONULL
Shoes_Assetchar(36)NONULL
Socks_Itemchar(36)NONULL
Socks_Assetchar(36)NONULL
Jacket_Itemchar(36)NONULL
Jacket_Assetchar(36)NONULL
Gloves_Itemchar(36)NONULL
Gloves_Assetchar(36)NONULL
Undershirt_Itemchar(36)NONULL
Undershirt_Assetchar(36)NONULL
Underpants_Itemchar(36)NONULL
Skirt_Assetchar(36)NONULL
Skirt_Itemchar(36)NONULL



      (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)

Personal tools
General
About This Wiki