Database:Avatarappearance
From OpenSimulator
(Difference between revisions)
m (Robot: Cosmetic changes) |
|||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | '''avatarappearance''' ''Records avatar appearance details, i.e., worn wearables'' (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'' (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> </td></tr> | <tr><td> </td></tr> | ||
<tr><td>Owner</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td> </td></tr> | <tr><td>Owner</td><td>char(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td> </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 34: | Line 37: | ||
<tr><td>Undershirt_Asset</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_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_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> | <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 /> |
| − | (back to [[Database Documentation]])<br> | + | (back to [[Database Documentation]])<br /> |
| − | < | + | ---- |
| + | |||
| + | '''Owner'''<br /> | ||
| + | UUID of avatar's owner. | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Serial'''<br /> | ||
| + | Monotonic counter gets incremented by 1 each time the avatar is updated. | ||
| + | <br /><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 /> | ||
| + | The avatar's 'baked' texture. | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Avatar_Height'''<br /> | ||
| + | Height of the avatar in meters. | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Body_Item'''<br /> | ||
| + | Refers to inventory item for Body | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Body_Asset'''<br /> | ||
| + | Refers to item in assets for Body | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Skin_Item'''<br /> | ||
| + | Refers to inventory item for Skin | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Skin_Asset'''<br /> | ||
| + | Refers to item in assets for Skin | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Hair_Item'''<br /> | ||
| + | Refers to inventory item for Hair | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Hair_Asset'''<br /> | ||
| + | Refers to item in assets for Hair | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Eyes_Item'''<br /> | ||
| + | Refers to inventory item for Eyes | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Eyes_Asset'''<br /> | ||
| + | Refers to item in assets for Eyes | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Shirt_Item'''<br /> | ||
| + | Refers to inventory item for Shirt | ||
| + | <br /> | ||
| + | <br /> | ||
| + | '''Shirt_Asset'''<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 | ||
| + | ---- | ||
| + | (back to [[Database Documentation]])<br /> | ||
| − | + | [[Category:Database]] | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Latest revision as of 19:55, 3 March 2012
 |
Languages: |
|
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)
