KNTA_WEBSESSION_KEYS

This table stores web session keys that are generated each time a user attempts to login using a web browser. This table is periodically cleaned up by a service. The table is empty if this feature is turned off (default).

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

WEBSESSION_KEY_ID

NOT NULL

NUMBER

System-generated identifier

WEBSESSION_KEY

NOT NULL

NUMBER

Random number assigned to this web session

CREATION_DATE

NOT NULL

DATE

Date record was created

CLIENT_ADDRESS

NOT NULL

VARCHAR2(100)

Hostname or IP address of the user where web session is created

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_WEBSESSION_KEYS_N1

UNIQUE

1

WEBSESSION_KEY_ID

KNTA_WEBSESSION_KEYS_N2

NONUNIQUE

1

WEBSESSION_KEY

KNTA_WEBSESSION_KEYS_N2

NONUNIQUE

2

CLIENT_ADDRESS

Sequences

This table uses no sequences.