vdsPersistentCache
The vdsPersistentCache table contains data records that store session state information for various session types. This session state information is recorded to accomplish tasks that involve several steps and allow load-balancing and failover strategies in replicated environments.
It stores session state information for the following:
- Challenge data required for push notification–based authentication using the OneSpan Mobile Authenticator app.
- Registration information, used for online activation of OneSpan Mobile Authenticator app instances.
- Signature information used for Secure Channel signatures.
- Administrative session information that are used for administrative purposes.
Columns
Table: vdsPersistentCache table columns
| Column name |
Data type |
Primary key |
Nullable |
Description |
| vdsKey
|
varchar(255) |
Yes |
No |
The unique identifier of the session cache entry. |
| vdsCacheType
|
integer |
No |
No |
The cache type of this data record, e.g. challenge cache or registration cache. |
| vdsWorkflowStatus
|
integer |
No |
Yes |
The state in the workflow at which the data record has been created or modified. For instance, in case of an authentication using push notifications, this may indicate the notification has been sent, the authentication has been successful, etc. |
| vdsElement
|
varchar(32768) |
No |
No |
The BLOB storing the serialized cache record data. |
| vdsExpired
|
integer |
No |
Yes |
The expiration state of the data record. Expired data records are automatically cleaned up at regular intervals. |
| vdsVersion
|
integer |
No |
Yes |
The current data schema version of the data record. |
| vdsCreateTime
|
timestamp |
No |
No |
The date and time the data record was created. |
| vdsModifyTime
|
timestamp |
No |
No |
The date and time the data record was last modified. |
Keys
Primary key: (vdsKey)
Foreign keys: None.
Indexes
Table: vdsPersistentCache table indexes
| Index name |
Included fields |
| Level 0 (default) |
| vdspersistentcacheidx
|
vdsKey
|