PVCBINDING

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

Column Descriptions:

NameTypeDescription
PVCSESSION_IDBIGINT NOT NULLThe identifier of the terminal used for pervasive computing.
PVCBINDING_IDBIGINT NOT NULLThe reference number of a record.
USERS_IDBIGINT NOT NULLThe reference number of a customer who is allowed to log in using a terminal corresponding to the PVCSESSION_ID.
STATUSCHAR (1) NOT NULLThe status of the binding. Valid values are as follows:
  • A=active record
  • S=superseded
CREATEDTIMESTAMP NOT NULLThe date and time this record was created.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>PVCBINDING_IDPrimary Key
I758147PVCSESSION_ID+USERS_ID+CREATEDUnique Index
I0000706USERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_633USERS_IDUSERSUSERS_IDCascade
F_634PVCSESSION_IDPVCSESSIONPVCSESSION_IDCascade