Reference > Database > WebSphere Commerce database tables > P

WebSphere Commerce database table: PVCBINDING

This table represents a relationship between a customer and a terminal for pervasive computing.

Column Name	Column Type	Description
PVCSESSION_ID	BIGINT NOT NULL	The identifier of the terminal used for pervasive computing.
PVCBINDING_ID	BIGINT NOT NULL	The reference number of a record.
USERS_ID	BIGINT NOT NULL	The reference number of a customer who is allowed to log in using a terminal corresponding to the PVCSESSION_ID.
STATUS	CHAR(1) NOT NULL	The status of the binding. Valid values are... A=active record S=superceded
CREATED	TIMESTAMP NOT NULL	The date and time this record was created.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I758147	PVCSESSION_ID+USERS_ID+CREATED	Unique Index
SQL100520030415320	PVCBINDING_ID	Primary Key
I0000706	USERS_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_634	PVCSESSION_ID	PVCSESSION	PVCSESSION_ID	Cascade
F_633	USERS_ID	USERS	USERS_ID	Cascade

Related reference

• Mobile device data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search