Table: dbo.User_Session_Override
This table holds updates to rows in dbo.User_Session that would have otherwise been blocked. It is important to NOT have a relationship to dbo.User_Session so that we avoid any blocking on enforcing DRI.
Columns
NameTypeConstraintsDescription
user_session_guiduniqueidentifier (16)NOT NULLKey to the User_Session table.
logout_datedatetime (8, 3)NOT NULLThe date and time that the user logged out, or that the session was deemed expired or killed.
last_access_datedatetime (8, 3)NOT NULLDate and time this session was last active.
user_session_status_KEYint (4)NOT NULLThe status of this session (1=Open, 2=Closed, 3=Expired, 4=Killed)
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Session_Override__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)
FK_User_Session_Override__User_Session_Status__user_session_status_KEYuser_session_status_KEYUser_Session_Status (user_session_status_KEY)

Schema diagram