Database:Avatarappearance

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(New page: '''avatarappearance''' ''Records avatar appearance details''      (back to Database Documentation)<br> <br><br> The current structure of the avatar appear...)
 
m (Robot: Cosmetic changes)
 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
'''avatarappearance''' ''Records avatar appearance details''&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>UUID</td><td>varchar(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>
−
<tr><td>sessionID</td><td>varchar(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
+
<tr><td>Serial</td><td>int(10) unsigned</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
−
<tr><td>secureSessionID</td><td>varchar(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
+
<tr><td>Visual_Params</td><td>blob</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
−
<tr><td>agentIP</td><td>varchar(16)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
+
<tr><td>Texture</td><td>blob</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
−
<tr><td>agentPort</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Avatar_Height</td><td>float</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
−
<tr><td>agentOnline</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Body_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
−
<tr><td>loginTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Body_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
−
<tr><td>logoutTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<tr><td>Skin_Item</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td></td></tr>
−
<tr><td>currentRegion</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></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>currentHandle</td><td>bigint(20) unsigned</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>currentPos</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></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_Asset</td><td>char(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
 +
<tr><td>Shirt_Item</td><td>char(36)</td><td>NO</td><td>UNI</td><td>NULL</td><td></td></tr>
 +
<tr><td>Shirt_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Pants_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Pants_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Shoes_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Shoes_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Socks_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Socks_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Jacket_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Jacket_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Gloves_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Gloves_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Undershirt_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Undershirt_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>Underpants_Item</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Underpants_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>Skirt_Asset</td><td>char(36)</td><td>NO</td><td></td><td>NULL</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>
+
----
−
'''UUID'''
+
 
−
<br>
+
'''Owner'''<br />
−
The UUID uniquely identifies the avatar associated with the user's account. This master ID 'number' is used for everything the avatar interacts with - it is used to determine permissions, identify belongings, and route messages to and from system and other avatars.
+
UUID of avatar's owner.
−
<br>
+
<br />
−
<br>
+
<br />
−
'''sessionID'''
+
'''Serial'''<br />
−
<br>
+
Monotonic counter gets incremented by 1 each time the avatar is updated.
−
For Future Use
+
<br /><br />
−
<br>
+
'''Visual_Params'''<br />
−
<br>
+
Byte array of some 240 or so numerically descriptive shape parameters describing the look of the avatar.
−
'''SecureSessionID'''
+
<br />
−
<br>
+
<br />
−
For Future Use
+
'''Texture'''<br />
−
<br>
+
The avatar's 'baked' texture.
−
<br>
+
<br />
−
'''agentIP'''
+
<br />
−
<br>
+
'''Avatar_Height'''<br />
−
IP address of logged-in agent?<br>
+
Height of the avatar in meters.
−
Does not appear to be updated at this time
+
<br />
−
<br>
+
<br />
−
<br>
+
'''Body_Item'''<br />
−
'''agentPort'''
+
Refers to inventory item for Body
−
Port the agent is connected on<br>
+
<br />
−
Does not appear to be updated at this time
+
<br />
−
<br>
+
'''Body_Asset'''<br />
−
<br>
+
Refers to item in assets for Body
−
'''agentOnLine'''
+
<br />
−
<br>
+
<br />
−
Status of agent (Online/Offline)
+
'''Skin_Item'''<br />
−
<br>
+
Refers to inventory item for Skin
−
<br>
+
<br />
−
'''loginTime'''
+
<br />
−
<br>
+
'''Skin_Asset'''<br />
−
Time the agent logged in at
+
Refers to item in assets for Skin
−
<br>
+
<br />
−
<br>
+
<br />
−
'''logoutTime'''
+
'''Hair_Item'''<br />
−
<br>
+
Refers to inventory item for Hair
−
Time the agent logged out at
+
<br />
−
<br>
+
<br />
−
<br>
+
'''Hair_Asset'''<br />
−
'''currentRegion'''
+
Refers to item in assets for Hair
−
<br>
+
<br />
−
Region UUID for the region the av is presently resident within
+
<br />
−
<br>
+
'''Eyes_Item'''<br />
−
<br>
+
Refers to inventory item for Eyes
−
'''currentHandle'''
+
<br />
−
<br>
+
<br />
−
Records the grid position of the region the av is presently resident within
+
'''Eyes_Asset'''<br />
−
<br>
+
Refers to item in assets for Eyes
−
<br>
+
<br />
−
'''currentPos'''
+
<br />
−
<br>
+
'''Shirt_Item'''<br />
−
Records the av's current position with the region in which it is currently resident
+
Refers to inventory item for Shirt
−
<br>
+
<br />
−
<br>
+
<br />
−
<hr>
+
'''Shirt_Asset'''<br />
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
Refers to item in assets for Shirt
 +
<br />
 +
<br />
 +
'''Pants_Item'''<br />
 +
Refers to inventory item for Pants
 +
<br />
 +
<br />
 +
'''Pants_Asset'''<br />
 +
Refers to item in assets for Pants
 +
<br />
 +
<br />
 +
'''Shoes_Item'''<br />
 +
Refers to inventory item for Shoes
 +
<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
 +
----
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
 
 +
[[Category:Database]]

Latest revision as of 18:55, 3 March 2012

Languages Languages: 

En.png English

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)

Retrieved from "http://opensimulator.org/index.php?title=Database:Avatarappearance&oldid=28063"
Personal tools
General
About This Wiki