Database Details / Vocera Usage Data |
The failures table stores data about badge software failures. This table has a primary key based on the TxMillis column.
Column | Description |
---|---|
TxMillis |
bigint(15) unsigned NOT NULL default '0' 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. |
TxDate |
date default NULL The TxDate column stores the date of an event, accurate to the day. |
TxDateTime |
datetime NOT NULL default '0000-00-00 00:00:00' The TxDateTime column stores the date and time of the event, accurate to the second. |
UserID |
varchar(70) default NULL The UserID column specifies the user ID of the badge user, if a user was logged in to the badge. If no user was logged in to the badge at the time of the failure, this value is the literal string __NLI__. |
UserSite |
varchar(50) default NULL In a multi-site installation, the UserSite column specifies the Vocera site with which the badge is associated. In a single-site installation, this value is null. |
BadgeMACAddr |
varchar(12) default NULL The BadgeMACAddr column specifies the badge's MAC address. Example value: 0009ef0078a3 |
Failuretext |
varchar(50) NOT NULL default '' The Failuretext column stores text describing the failure. Example value: Failure in pre.c at line 166. Code: 0009 |