Database Table: PVCBINDING

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

Column Name Column Type Column Description
CREATED TIMESTAMP
NOT NULL
The date and time this record was created.
PVCBINDING_ID BIGINT
NOT NULL
Reference number of a record.
PVCSESSION_ID BIGINT
NOT NULL
Identifier of the terminal.
STATUS CHARACTER (1)
NOT NULL
The status of the binding. Valid values:
A = active record and S = superceded.
USERS_ID BIGINT
NOT NULL
Reference number of a customer who is allowed to log in using a terminal corresponding to PVCSESSION_ID.
Indexes:
Index Name Indexed Column Names Index Type
I758147 PVCSESSION_ID, USERS_ID, CREATED Unique Index
SQL030416035042230 PVCBINDING_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_633 USERS_ID USERS USERS_ID Cascade
F_634 PVCSESSION_ID PVCSESSION PVCSESSION_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable