This table manages the session of various pervasive computing devices.
Column Description(s):
Column Name | Column Type | Description |
PVCSESSION_ID |
BIGINT NOT NULL |
Reference number of this record. |
TERMINAL |
VARCHAR(254) NOT NULL |
The terminal identifier related to this session. CONSTRAINT unique_session_devic UNIQUE(SESSION_TYPE, TERMINAL). |
REGISTER_ID |
BIGINT |
Reference number of a customer who is logging in. Or reference number of a customer who was previously logged in. This column is NULL if the pervasive computing customer has not registered by way of a registration command. |
LASTVISITED |
TIMESTAMP NOT NULL |
Last visited time. Will be updated on command execution while status is 1. |
STATUS |
INTEGER NOT NULL DEFAULT 0 |
Status of the customer whose reference number is same as SHOPPER_ID. Valid values are as follows:
|
GUEST_ID |
BIGINT |
Reference number of a guest customer. When the status value is 1, this column is set to NULL. |
SESSIONTYPE |
VARCHAR(32) NOT NULL |
This column identifies the type of pervasive computing device: either iMode or WAP. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000197 |
TERMINAL+SESSIONTYPE |
Unique Index |
SQL050212031300610 |
PVCSESSION_ID |
Primary Key |
I0000708 |
REGISTER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_639 |
REGISTER_ID |
USERS |
USERS_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_634 |
PVCSESSION_ID |
PVCBINDING |
PVCSESSION_ID |
Cascade |
F_890 |
PVCSESSION_ID |
USERPVCDEV |
PVCSESSION_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.