Table: visitor_session
Article Id:
TABLE: VISITOR_SESSION
Published:
21 Aug 2012, last updated 27 Nov 2013 16:01
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 |