Database Table: PVCSESSION

This table manages the session of various pervasive computing devices.

Column Name Column Type Column Description
GUEST_ID BIGINT
NULL
Reference number of a guest customer. When the status value is 1, this column is set to NULL.
LASTVISITED TIMESTAMP
NOT NULL
Last visited time. Will be updated on command execution while status is 1.
PVCSESSION_ID BIGINT
NOT NULL
Reference number of this record.
REGISTER_ID BIGINT
NULL
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.
SESSIONTYPE VARCHAR (32)
NOT NULL
This column identifies the type of pervasive computing device: either iMode or WAP.
STATUS INTEGER
NOT NULL, DEFAULT 0
Status of the customer whose reference number is same as SHOPPER_ID:
0 = logout,
1 = login.
TERMINAL VARCHAR (254)
NOT NULL
The terminal identifier related to this session. CONSTRAINT unique_session_devic UNIQUE(SESSION_TYPE, TERMINAL).
Indexes:
Index Name Indexed Column Names Index Type
I0000197 TERMINAL, SESSIONTYPE Unique Index
SQL030416035043880 PVCSESSION_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_639 REGISTER_ID USERS USERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_634 PVCSESSION_ID PVCBINDING PVCSESSION_ID Cascade
F_890 PVCSESSION_ID USERPVCDEV PVCSESSION_ID Cascade