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