PVCSESSION

This table manages the session of various pervasive computing devices.

Column Descriptions:

Name	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_device 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: 0=logout 1=login
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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PVCSESSION_ID	Primary Key
I0000197	TERMINAL+SESSIONTYPE	Unique Index
I0000708	REGISTER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_639	REGISTER_ID	USERS	USERS_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_634	PVCSESSION_ID	PVCBINDING	PVCSESSION_ID	Cascade
F_890	PVCSESSION_ID	USERPVCDEV	PVCSESSION_ID	Cascade

Related reference
Mobile device data model