Table: visitor_session

Article Id
kb66
Published
21 Aug 2012 at 14:41
Last Updated
27 Nov 2013 at 16:01
CalzadaMedia.Common.AppFoundation.WebApp.UI.WebComponent.WebComponentOutputStringBuilder

Stores temporary visitor/user session data. This table should be cleared regularly to avoid unnecessary database bloat.

Field Type Null Key Default Description
session_id int(10) No Primary
session_webserversessionid varchar(255) Yes session_webserversessionid The Web server Session ID
user_id int(10) No 0 The ID of the user account to whom the session data belongs
session_ipaddress varchar(255) Yes The IPv4, or more typically, the IPv6 address of the client
session_data varchar(4000) Yes The encrypted session data
session_expirydate datetime No session_expirydate The MySQL timestamp after which the record is deemed to have been expired and may be deleted

Indexes

Keyname Type Cardinality Field(s) Description
PRIMARY PRIMARY 0 session_id
session_webserversessionid Index session_webserversessionid Used to identity session
session_expirydate Index session_expirydate Used in expired session removal
     
Copyright © 2011 - 2025 Calzada Media Limited. All Rights Reserved