connects
The connects table stores data on connectivity between devices. This table belongs to the category collections.
Each row in the connects table defines a relationship between two entities.
The connects table stores each connection as a single record. However, because two entities are involved in a connection, the order of the connected entities within the connects table is random. One of the devices involved in the connection is considered to be at a notional start (or aEnd) of the connection, while the second device is considered to be at a notional end (or zEnd) of the connection.
The following table describes the connects table.
| Column name | Type | Constraints | Description |
|---|---|---|---|
| connectionId | 32-bit integer | Primary key Not null Automatically incremented Unique |
This is an automatically-incremented field that must be unique for each connection across all domains. |
| aEndEntityId | 32-bit integer | Foreign key Not null |
The entityId of an interface from the entityData table giving the notional start of the connection. |
| zEndEntityId | 32-bit integer | Foreign key Not null |
The entityId of an interface from the entityData table giving the notional end of the connection. |
| unidirectional | Boolean | Not null Takes one of the following values: 0: is not unidirectional
1: is unidirectional |
Indicates whether the connection is unidirectional or bidirectional. Currently all connections are bidirectional. |