English (English) - Change language

Session

Purpose

Contains information about current work sessions of users. Also used for managing resources allocated for sessions and locks.

Diagram of relationships between lock tables

List 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.

9/25/2020 9:24:45 AM


Please leave your feedback about this article