Table: User_Session
Columns
Name | Type | Constraints | Description
user_session_guid | uniqueidentifier | NOT NULL | A database generated unique key for this table.
staff_KEY | int | NOT NULL | Key to the Staff that this session is for.
login_date | datetime | NOT NULL | The date and time the session was opened in UTC.
logout_date | datetime | NOT NULL | The date and time that the user logged out, or that the session was deemed expired or killed, in UTC.
user_session_pattern_guid | uniqueidentifier | NOT NULL | Key to the User_Session_Pattern table.
expiration_date | datetime | NOT NULL | The date and time that this session will expire in UTC.
last_access_date | datetime | NOT NULL | Date and time this session was last active in UTC.
user_session_status_KEY | int | NOT NULL | The status of this session (1=Open, 2=Closed, 3=Expired, 4=Killed)

Primary key
Name | Columns | Description
PK_User_Session$user_session_guid | user_session_guid | CLUSTERED
Indexes
Name | Columns | Description
IX_User_Session$staff_KEY | staff_KEY | Index supports foreign key FK_User_Session__Staff__staff_KEY
IX_User_Session$user_session_pattern_guid | user_session_pattern_guid | Index supports foreign key FK_User_Session__User_Session_Pattern__user_session_pattern_guid
IX_User_Session$user_session_status_KEY | user_session_status_KEY | Index supports foreign key FK_User_Session__User_Session_Status__user_session_status_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_User_Session__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;
FK_User_Session__User_Session_Pattern__user_session_pattern_guid | user_session_pattern_guid | User_Session_Pattern |