PVCBINDING

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

Column Descriptions:

Name	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=superseded
CREATED	TIMESTAMP NOT NULL	The date and time this record was created.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PVCBINDING_ID	Primary Key
I758147	PVCSESSION_ID+USERS_ID+CREATED	Unique Index
I0000706	USERS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_633	USERS_ID	USERS	USERS_ID	Cascade
F_634	PVCSESSION_ID	PVCSESSION	PVCSESSION_ID	Cascade

Related reference
Mobile device data model