WebSphere Commerce database table: PVCBINDING

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


Column Description(s):
Column NameColumn TypeDescription
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 as follows:
  • A=active record
  • S=superceded
CREATED TIMESTAMP NOT NULL The date and time this record was created.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I758147 PVCSESSION_ID+USERS_ID+CREATED Unique Index
SQL050212031259790 PVCBINDING_ID Primary Key
I0000706 USERS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_634 PVCSESSION_ID PVCSESSION PVCSESSION_ID Cascade
F_633 USERS_ID USERS USERS_ID Cascade

Feedback