Database Details / Vocera Usage Data |
The radiolog table stores summary information regarding the audio quality experienced by Vocera badges during a call. This table has a primary key based on the TxMillis column. For details about each record, go to the radiodetail table with radiodetail.txParentMillis = radiolog.TxMillis.
Column | Description |
---|---|
TxMillis |
bigint(15) unsigned NOT 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. |
TxDateTime |
datetime NOT NULL default '0000-00-00 00:00:00' The TxDateTime column stores the date and time of an event, accurate to the second. |
TxDate |
date NOT NULL default '0000-00-00' The TxDate column stores the date of an event, accurate to the day. |
UserID |
varchar(70) default NULL The UserID column specifies the user ID of the last person logged into the badge. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera server, unless the user logged in with the built-in login ID Administrator, in which case this value is __NONE__. See LoginId. |
UserSite |
varchar(50) NOT NULL default '' In a multi-site installation, the UserSite column specifies the Vocera site with which the user is associated. In a single-site installation, this value is null. |
BadgeMacAddress |
varchar(12) default NULL The BadgeMACAddr specifies the badge MAC address. Example value: 0009ef006e9a |
BadgeBinary |
text Raw binary log sent by the badge. |
PacketsReceived |
smallint(6) default NULL Total packets received before a new log event occurred. PacketsReceived and PacketsMissed are used to compute the Packet Error Rate. |
PacketsMissed |
smallint(6) default NULL Total packets missed before a new log event occurred. |
AvgCQ |
smallint(6) NOT NULL default '0' Average Communication Quality (CQ) value. A CQ value is an even number value on a logarithmic scale ranging from 0 to 92, where 0 represents no signal and 92 is the strongest possible signal with essentially no background noise. |
JBhit |
mediumint(9) default NULL Number of Jitter Buffer hits. |
JBMissed |
mediumint(9) default NULL Number of Jitter Buffer misses. |
Type |
smallint(1) default '1' 1 = Without Jitter Buffer data; 2 = New format with Jitter Buffer data. |
Reserved1 |
mediumint(9) default NULL Reserved for future use. |
Reserved2 |
mediumint(9) default NULL Reserved for future use. |
Reserved3 |
mediumint(9) default NULL Reserved for future use. |