Database:Avatarappearance
From OpenSimulator
avatarappearance Records avatar appearance details (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
Serial
Visual_Params
Texture
Avatar_Height
Body_Item
Body_Asset
Skin_Item
Skin_Asset
Hair_Item
Hair_Asset
Eyes_Item
Eyes_Asset
Shirt_Item
Shirt_Asset
Pants_Item
Pants_Asset
Shoes_Item
Shoes_Asset
Socks_Item
Socks_Asset
Jacket_Item
Jacket_Asset
Gloves_Item
Gloves_Asset
Undershirt_Item
Undershirt_Asset
Underpants_Item
Skirt_Asset
Skirt_Item
(back to Database Documentation)