WebSphere Commerce database table: PVCBINDING

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

Column Descriptions
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 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.

Indexes
Index Name Indexed Column Names Index Type
I758147 PVCSESSION_ID+USERS_ID+CREATED Unique Index
SQL060903235237450 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