USERPVCDEV

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

Column Descriptions:

NameTypeDescription
USERPVCDEV_IDBIGINT NOT NULLPrimary key, internally generated.
DEVICEIDENTIFIERVARCHAR (254)The terminal identifier of the pervasive computing device. This column is deprecated and is provided for backward compatibility only.
PVCSESSION_IDBIGINT NOT NULLReference to the pervasive computing device which the user uses to log in. Foreign key to PVCSESSION_ID in PVCSESSION table.
USERS_IDBIGINT NOT NULLForeign key to the USERS table for the registered user who owns this PVC device.
ADDRESS1VARCHAR (254)The primary address of the user of the pervasive computing device.
ADDRESS1TYPECHAR (3)The type of address for ADDRESS1. Valid values are E (e-mail) or P (phone).
ADDRESS2VARCHAR (254)A secondary address for the user of the pervasive computing device.
ADDRESS2TYPECHAR (3)The type of address for ADDRESS2. Valid values are E (e-mail) or P (phone).
TRANSPORT_IDINTEGERForeign key to the TRANSPORT table.
DEVICEFMT_IDINTEGERForeign key to the DEVICEFMT table.
PREFERREDTIMEOUTINTEGERTime that the session should expire.
PROTECTINTEGERProtect commands which are listed in URLREG table. Valid values are 1 (yes) or 0 (no). If not provided, 1 is used as the default.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USERPVCDEV_IDPrimary Key
I761149PVCSESSION_ID+USERS_IDUnique Index
I0000824USERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_890PVCSESSION_IDPVCSESSIONPVCSESSION_IDCascade
F_891USERS_IDUSERSUSERS_IDCascade
F_892DEVICEFMT_IDDEVICEFMTDEVICEFMT_IDCascade
F_893TRANSPORT_IDTRANSPORTTRANSPORT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_455USERPVCDEV_IDMBRVIEWPRFPREFERENCECascade