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 |