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). |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000197 | TERMINAL, SESSIONTYPE | Unique Index |
SQL030416035043880 | PVCSESSION_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_639 | REGISTER_ID | USERS | USERS_ID | Cascade |
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 |