WebSphere Commerce database table: USERPVCDEV

USERPVCDEV

This table contains information for pervasive computing devices used by WebSphere Commerce registered users.

Column Descriptions:

Name Type Description
USERPVCDEV_ID BIGINT NOT NULL Primary key, internally generated.
DEVICEIDENTIFIER VARCHAR (254) The terminal identifier of the pervasive computing device. This column is deprecated and is provided for backward compatibility only.
PVCSESSION_ID BIGINT NOT NULL Reference to the pervasive computing device which the user uses to log in. Foreign key to PVCSESSION_ID in PVCSESSION table.
USERS_ID BIGINT NOT NULL Foreign key to the USERS table for the registered user who owns this PVC device.
ADDRESS1 VARCHAR (254) The primary address of the user of the pervasive computing device.
ADDRESS1TYPE CHAR (3) The type of address for ADDRESS1. Valid values are E (e-mail) or P (phone).
ADDRESS2 VARCHAR (254) A secondary address for the user of the pervasive computing device.
ADDRESS2TYPE CHAR (3) The type of address for ADDRESS2. Valid values are E (e-mail) or P (phone).
TRANSPORT_ID INTEGER Foreign key to the TRANSPORT table.
DEVICEFMT_ID INTEGER Foreign key to the DEVICEFMT table.
PREFERREDTIMEOUT INTEGER Time that the session should expire.
PROTECT INTEGER Protect commands which are listed in URLREG table. Valid values are 1 (yes) or 0 (no). If not provided, 1 is used as the default.
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> USERPVCDEV_ID Primary Key
I761149 PVCSESSION_ID+USERS_ID Unique Index
I0000824 USERS_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_890 PVCSESSION_ID PVCSESSION PVCSESSION_ID Cascade
F_891 USERS_ID USERS USERS_ID Cascade
F_892 DEVICEFMT_ID DEVICEFMT DEVICEFMT_ID Cascade
F_893 TRANSPORT_ID TRANSPORT TRANSPORT_ID Cascade

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_455 USERPVCDEV_ID MBRVIEWPRF PREFERENCE Cascade

Related reference
Member data model
Mobile device data model

Name	Type	Description
USERPVCDEV_ID	BIGINT NOT NULL	Primary key, internally generated.
DEVICEIDENTIFIER	VARCHAR (254)	The terminal identifier of the pervasive computing device. This column is deprecated and is provided for backward compatibility only.
PVCSESSION_ID	BIGINT NOT NULL	Reference to the pervasive computing device which the user uses to log in. Foreign key to PVCSESSION_ID in PVCSESSION table.
USERS_ID	BIGINT NOT NULL	Foreign key to the USERS table for the registered user who owns this PVC device.
ADDRESS1	VARCHAR (254)	The primary address of the user of the pervasive computing device.
ADDRESS1TYPE	CHAR (3)	The type of address for ADDRESS1. Valid values are E (e-mail) or P (phone).
ADDRESS2	VARCHAR (254)	A secondary address for the user of the pervasive computing device.
ADDRESS2TYPE	CHAR (3)	The type of address for ADDRESS2. Valid values are E (e-mail) or P (phone).
TRANSPORT_ID	INTEGER	Foreign key to the TRANSPORT table.
DEVICEFMT_ID	INTEGER	Foreign key to the DEVICEFMT table.
PREFERREDTIMEOUT	INTEGER	Time that the session should expire.
PROTECT	INTEGER	Protect commands which are listed in URLREG table. Valid values are 1 (yes) or 0 (no). If not provided, 1 is used as the default.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	USERPVCDEV_ID	Primary Key
I761149	PVCSESSION_ID+USERS_ID	Unique Index
I0000824	USERS_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_890	PVCSESSION_ID	PVCSESSION	PVCSESSION_ID	Cascade
F_891	USERS_ID	USERS	USERS_ID	Cascade
F_892	DEVICEFMT_ID	DEVICEFMT	DEVICEFMT_ID	Cascade
F_893	TRANSPORT_ID	TRANSPORT	TRANSPORT_ID	Cascade