|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.
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.
date default NULL
The TxDate column stores the date of an event, accurate to the day.
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.
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__.
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.
varchar(12) default NULL
The BadgeMACAddr column specifies the badge's MAC address. Example value: 0009ef0078a3
varchar(50) NOT NULL default ''
The Failuretext column stores text describing the failure. Example value: Failure in pre.c at line 166. Code: 0009