Presence
From OpenSimulator
 |
Languages: |
|
The Presence table contains region and session information for currently logged in users. Used for IM routing amongst other things. (back to Database Documentation)
Presence Table Structure
The structure of the Presence table is as follows:
| Field | Type | Collation | Attributes | Null | Default | Extra |
|---|---|---|---|---|---|---|
| UserID | varchar(255) | utf8_general_ci | No | NULL | ||
| RegionID | char(36) | utf8_general_ci | No | 00000000-0000-0000-0000-000000000000 | ||
| SessionID | char(36) | utf8_general_ci | No | 00000000-0000-0000-0000-000000000000 | ||
| SecureSessionID | char(36) | utf8_general_ci | No | 00000000-0000-0000-0000-000000000000 | ||
| LastSeen | timestamp | utf8_general_ci | No | CURRENT_TIMESTAMP |
(back to Database Documentation)
Presence Fields
- UserID
- The UUID of an avatar
- RegionID
- The UUID of the region in which the avatar is currently located
- SessionID
- A UUID for the avatars current session
- LastSeen
- The last time the avatar was seen online
(back to Database Documentation)
