Database:Avatarappearance

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Robot: Cosmetic changes)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
'''avatarappearance''' ''Records avatar appearance details, i.e., worn wearables''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
__NOTOC__
<br><br>
+
{{Quicklinks}}
The current structure of the avatar appearance table is as follows:<br>
+
 
<br>
+
'''avatarappearance''' ''Records avatar appearance details, i.e., worn wearables''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
<br /><br />
 +
The current structure of the avatar appearance table is as follows:<br />
 +
<br />
 
<table>
 
<table>
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 
<tr><td>&nbsp;</td></tr>
 
<tr><td>&nbsp;</td></tr>
 
<tr><td>Owner</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td>&nbsp;</td></tr>
 
<tr><td>Owner</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td>&nbsp;</td></tr>
Line 16: Line 19:
 
<tr><td>Skin_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 
<tr><td>Skin_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 
<tr><td>Hair_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 
<tr><td>Hair_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>Hair_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><br>
+
<tr><td>Hair_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><br />
 
<tr><td>Eyes_Item</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td></td></tr>
 
<tr><td>Eyes_Item</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td></td></tr>
 
<tr><td>Eyes_Asset</td><td>char(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
 
<tr><td>Eyes_Asset</td><td>char(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
Line 38: Line 41:
 
<tr><td>Skirt_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
 
<tr><td>Skirt_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
 
</table>
 
</table>
<br>
+
<br />
<br>
+
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
<hr>
+
----
  
'''Owner'''<br>
+
'''Owner'''<br />
 
UUID of avatar's owner.
 
UUID of avatar's owner.
<br>
+
<br />
<br>
+
<br />
'''Serial'''<br>
+
'''Serial'''<br />
 
Monotonic counter gets incremented by 1 each time the avatar is updated.
 
Monotonic counter gets incremented by 1 each time the avatar is updated.
<br><br>
+
<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.
 
Byte array of some 240 or so numerically descriptive shape parameters describing the look of the avatar.
<br>
+
<br />
<br>
+
<br />
'''Texture'''<br>
+
'''Texture'''<br />
 
The avatar's 'baked' texture.
 
The avatar's 'baked' texture.
<br>
+
<br />
<br>
+
<br />
'''Avatar_Height'''<br>
+
'''Avatar_Height'''<br />
 
Height of the avatar in meters.
 
Height of the avatar in meters.
<br>
+
<br />
<br>
+
<br />
'''Body_Item'''<br>
+
'''Body_Item'''<br />
 
Refers to inventory item for Body
 
Refers to inventory item for Body
<br>
+
<br />
<br>
+
<br />
'''Body_Asset'''<br>
+
'''Body_Asset'''<br />
 
Refers to item in assets for Body
 
Refers to item in assets for Body
<br>
+
<br />
<br>
+
<br />
'''Skin_Item'''<br>
+
'''Skin_Item'''<br />
 
Refers to inventory item for Skin
 
Refers to inventory item for Skin
<br>
+
<br />
<br>
+
<br />
'''Skin_Asset'''<br>
+
'''Skin_Asset'''<br />
 
Refers to item in assets for Skin
 
Refers to item in assets for Skin
<br>
+
<br />
<br>
+
<br />
'''Hair_Item'''<br>
+
'''Hair_Item'''<br />
 
Refers to inventory item for Hair
 
Refers to inventory item for Hair
<br>
+
<br />
<br>
+
<br />
'''Hair_Asset'''<br>
+
'''Hair_Asset'''<br />
 
Refers to item in assets for Hair
 
Refers to item in assets for Hair
<br>
+
<br />
<br>
+
<br />
'''Eyes_Item'''<br>
+
'''Eyes_Item'''<br />
 
Refers to inventory item for Eyes
 
Refers to inventory item for Eyes
<br>
+
<br />
<br>
+
<br />
'''Eyes_Asset'''<br>
+
'''Eyes_Asset'''<br />
 
Refers to item in assets for Eyes
 
Refers to item in assets for Eyes
<br>
+
<br />
<br>
+
<br />
'''Shirt_Item'''<br>
+
'''Shirt_Item'''<br />
 
Refers to inventory item for Shirt
 
Refers to inventory item for Shirt
<br>
+
<br />
<br>
+
<br />
'''Shirt_Asset'''<br>
+
'''Shirt_Asset'''<br />
 
Refers to item in assets for Shirt
 
Refers to item in assets for Shirt
<br>
+
<br />
<br>
+
<br />
'''Pants_Item'''<br>
+
'''Pants_Item'''<br />
 
Refers to inventory item for Pants
 
Refers to inventory item for Pants
<br>
+
<br />
<br>
+
<br />
'''Pants_Asset'''<br>
+
'''Pants_Asset'''<br />
 
Refers to item in assets for Pants
 
Refers to item in assets for Pants
<br>
+
<br />
<br>
+
<br />
'''Shoes_Item'''<br>
+
'''Shoes_Item'''<br />
 
Refers to inventory item for Shoes
 
Refers to inventory item for Shoes
<br>
+
<br />
<br>
+
<br />
'''Shoes_Asset'''<br>
+
'''Shoes_Asset'''<br />
 
Refers to item in assets for Shoes
 
Refers to item in assets for Shoes
<br>
+
<br />
<br>
+
<br />
'''Socks_Item'''<br>
+
'''Socks_Item'''<br />
 
Refers to inventory item for Socks
 
Refers to inventory item for Socks
<br>
+
<br />
<br>
+
<br />
'''Socks_Asset'''<br>
+
'''Socks_Asset'''<br />
 
Refers to item in assets for Socks
 
Refers to item in assets for Socks
<br>
+
<br />
<br>
+
<br />
'''Jacket_Item'''<br>
+
'''Jacket_Item'''<br />
 
Refers to inventory item for Jacket
 
Refers to inventory item for Jacket
<br>
+
<br />
<br>
+
<br />
'''Jacket_Asset'''<br>
+
'''Jacket_Asset'''<br />
 
Refers to item in assets for Jacket
 
Refers to item in assets for Jacket
<br>
+
<br />
<br>
+
<br />
'''Gloves_Item'''<br>
+
'''Gloves_Item'''<br />
 
Refers to inventory item for Gloves
 
Refers to inventory item for Gloves
<br>
+
<br />
<br>
+
<br />
'''Gloves_Asset'''<br>
+
'''Gloves_Asset'''<br />
 
Refers to item in assets for Gloves
 
Refers to item in assets for Gloves
<br>
+
<br />
<br>
+
<br />
'''Undershirt_Item'''<br>
+
'''Undershirt_Item'''<br />
 
Refers to inventory item for Undershirt
 
Refers to inventory item for Undershirt
<br>
+
<br />
<br>
+
<br />
'''Undershirt_Asset'''<br>
+
'''Undershirt_Asset'''<br />
 
Refers to item in assets for Undershirt
 
Refers to item in assets for Undershirt
<br>
+
<br />
<br>
+
<br />
'''Underpants_Item'''<br>
+
'''Underpants_Item'''<br />
 
Refers to inventory item for Underpants
 
Refers to inventory item for Underpants
<br>
+
<br />
<br>
+
<br />
'''Underpants_Asset'''<br>
+
'''Underpants_Asset'''<br />
 
Refers to item in assets for Underpants
 
Refers to item in assets for Underpants
<br>
+
<br />
<br>
+
<br />
'''Skirt_Asset'''<br>
+
'''Skirt_Asset'''<br />
 
Refers to item in assets for Skirt
 
Refers to item in assets for Skirt
<br>
+
<br />
<br>
+
<br />
'''Skirt_Item'''<br>
+
'''Skirt_Item'''<br />
 
Refers to inventory item for Skirt
 
Refers to inventory item for Skirt
<hr>
+
----
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
 
 
[[Category:Database]]
 
[[Category:Database]]

Latest revision as of 19:55, 3 March 2012

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