Database Table: USERPVCDEV

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

Column Name Column Type Column Description
ADDRESS1 VARCHAR (254)
NULL
The primary address of the user of the pervasive computing device.
ADDRESS1TYPE CHARACTER (3)
NULL
The type of address for ADDRESS1. Valid values are E (e-mail) or P (phone).
ADDRESS2 VARCHAR (254)
NULL
A secondary address for the user of the pervasive computing device.
ADDRESS2TYPE CHARACTER (3)
NULL
The type of address for ADDRESS2. Valid values are E (e-mail) or P (phone).
DEVICEFMT_ID INTEGER
NULL
Foreign key to the DEVICEFMT table.
DEVICEIDENTIFIER VARCHAR (254)
NULL
The terminal identifier of the pervasive computing device. This column is deprecated and is provided for backward compatibility only.
PREFERREDTIMEOUT INTEGER
NULL
Time that the session should expire.
PROTECT INTEGER
NULL
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.
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.
TRANSPORT_ID INTEGER
NULL
Foreign key to the TRANSPORT table.
USERPVCDEV_ID BIGINT
NOT NULL
Primary key, internally generated.
USERS_ID BIGINT
NOT NULL
Foreign key to the USERS table for the registered user who owns this PVC device.
Indexes:
Index Name Indexed Column Names Index Type
I761149 PVCSESSION_ID, USERS_ID Unique Index
SQL030416035141540 USERPVCDEV_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_455 USERPVCDEV_ID MBRVIEWPRF PREFERENCE Cascade