Diagrams


Table

Active Session

Fields

# Name Type
1 User SID GUID
2 Server Instance ID Integer
3 Session ID Integer
4 Server Instance Name Text250
5 Server Computer Name Text250
6 User ID Text132
7 Client Type Option
8 Client Computer Name Text250
9 Login Datetime DateTime
10 Database Name Text250
11 Session Unique ID GUID

Keys

# Fields
0 Server Instance ID,Session ID Clustered: Yes
1 Login Datetime
2 User SID,Client Type

Table Relations To Other Tables

Field Related Table Related Field
Server Instance ID Server Instance Server Instance ID 1..n
User SID User User Security ID 1..n

Table Relations From Other Tables

From Table From Field