Portal relies on its own session object, rather than an HttpSession object created by the web container. The Portal session is used as an authorization token that identifies an authenticated user. Portal sessions are created when a user logs into the portal and cleaned up every minute by a background process.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| sid | nvarchar(100) | not null | Unique identifier for this session. |
| enteredpw | nvarchar(100) | with null | The Base64 encoded password the user entered. |
| ipaddr | nvarchar(40) | with null | The IP address of the client machine that this session was created for. |
| locale | nvarchar(40) | with null | The locale of the client. This is used for translation and template selection. |
| useragent | integer | with null | The user-agent of the client which this session was created for. |
| templatekey | integer | with null | Unique ID of this template. |
| usermsg | nvarchar(255) | with null | A string message for this client to be displayed on almost all Portal responses. |
| username | nvarchar(100) | with null | The username of the client that this session was created for. |
| userkey | integer | with null | The userkey of the client this session was created for. |
| lastaccesstime | integer | with null | The seconds since the epoch that this session was last accessed. This is used to determine session expiration. |
Product Name: Portal
Table Type: Table