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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I761149 | PVCSESSION_ID, USERS_ID | Unique Index |
SQL030416035141540 | USERPVCDEV_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_455 | USERPVCDEV_ID | MBRVIEWPRF | PREFERENCE | Cascade |