Presence
From OpenSimulator
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 |
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)