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 |