Purpose
Contains information about current work sessions of users. Also used for managing resources allocated for sessions and locks. Diagram of relationships between lock tablesList of columns
Key | Name | Type | Required | Description |
PK | Id | int | yes | Identifier of a connection session. |
CreationDate | datetime | yes | Date and time of the creation of a session. | |
CurrentEditSessionId | int | no | Identifier of the current editing session from the EditSession table | |
CurrentTaskId | int | no | Identifier of the current task. | |
CurrentTaskStartTime | datetime | no | Date and time when processing of the current task was started. | |
InstanceId | int | yes | Identifier of the process to which a session belongs. | |
LastAccess | datetime | yes | Date and time of the last query to the server. | |
RoleId | int | no | User role type. Possible values are listed in the User Role Types table. | |
TimeoutMinutes | int | no | The time a session can remain inactive before it is closed, in minutes. | |
UserId | int | yes | Identifier of the user that created the session. Corresponds to the identifier in the Principal table. | |
WorkStation | nvarchar | yes | Name of the computer from which the session was created. | |
WorkstationType | int | no | Type of workstation from which the session was created. Standard values are listed in the Station Types table. |