Database table definitions

Description and definition of the database tables that hold data for remote control sessions with on-demand targets. The SESSIONS_DATA table hold the data that is submitted from the default web page that is used by the target user. The SESSIONS table holds session data.

Table 1. SESSION_DATA table
TABLE NAME COLUMN NAME TYPE NAME LENGTH NULLS
SESSION_DATA SESSIONKEY INTEGER 4 No
CUSTOM0 VARCHAR 128 Yes
CUSTOM1 VARCHAR 128 Yes
CUSTOM2 VARCHAR 128 Yes
CUSTOM3 VARCHAR 128 Yes
CUSTOM4 VARCHAR 128 Yes
CUSTOM5 VARCHAR 128 Yes
CUSTOM6 VARCHAR 128 Yes
CUSTOM7 VARCHAR 128 Yes
CUSTOM8 VARCHAR 128 Yes
CUSTOM9 VARCHAR 128 Yes
Table 2. SESSIONS table
TABLE NAME COLUMN NAME TYPE NAME LENGTH NULLS
SESSIONS SESSIONKEY INTEGER 4 No
USERKEY INTEGER 4 No
HWKEY INTEGER 4 No
REGISTERED_TARGET CHAR 1 No
REQUEST_TIME TIMESTAMP 10 Yes
START_TIME TIMESTAMP 10 Yes
END_TIME TIMESTAMP 10 Yes
DESCRIPTION VARCHAR 512 Yes
KNOWNUSERNAME VARCHAR 128 Yes
KNOWNCOMPUTERNAME VARCHAR 255 Yes
SESSION_TOKEN VARCHAR 256 Yes