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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I758147 | PVCSESSION_ID, USERS_ID, CREATED | Unique Index |
SQL030416035042230 | PVCBINDING_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|