|Database Details / Vocera Usage Data|
The lostconnectiondetail table stores detailed information about each time a Vocera badge loses its connection with the Vocera server, connects to an access point, or searches for a DHCP server. This table has a primary key based on the id column.
int(11) NOT NULL auto_increment
An incremental ID assigned to the lost connection instance.
varchar(15) default NULL
The TxParentMillis column is the unique identifier for the parent record in the lost connection log.
bigint(15) unsigned default NULL
The TxMillis column gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date and time of the event. See TxDateTime.
datetime NOT NULL
The TxDateTime column stores the date and time of an event, accurate to the second.
varchar(12) default NULL
The APMacAddress column specifies the MAC address of the wireless access point with which the badge was most recently associated. Example value: 000f24e9dce0
varchar(20) default NULL
Source IP address that the badge received while in a call.
varchar(10) default NULL
Type of lost connection. Possible values are: