connectActions

The connectActions table records all manual connection additions and all connection removals, including removal of connections that were discovered rather than manually added.

The following table describes the connectActions table.

Table 1. connectActions table
Column name	Type	Constraints	Description
connectActionsId	32-bit integer	Primary key Automatically incremented Not null	Unique auto generated primary key column.
aEndEntityId	32-bit integer	Foreign key Not null	Foreign key to the entityData table. EntityId of the A-end of the connection.
zEndEntityId	32-bit integer	Foreign key Not null	Foreign key to the entityData table. EntityId of the Z-end of the connection.
topologyEntityId	32-bit integer	Foreign key Not null	Foreign key to the entityData table. EntityId of the topology for this connection.
unidirectional	Boolean	Not null Not null	Boolean indicating if the connection ID is directed or not.
action	6-character string	Enumeration of values “add” and “delete” Not null	Indicates an action that added or deleted an entity.
changeTime	Timestamp	Not null	Indicates when this entityAction was last updated.
username	64-character string	Not null	Indicates the user that performed the entity action.
location	512-character string		Indicates location from which user is logged in.
description	512-character string		Textual description of reason for the connect action.
userSpeed	64-bit integer		User specified speedValue from connectSpeeds table.
manual	Boolean	Not null	Indicates if the entity was manually added.