Database Details / Vocera Usage Data |
The inventory table stores data about the status of badges, useful for asset tracking reports. 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. |
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. |
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 person logged in to the badge. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera server. If no user is logged in, 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 user is associated. In a single-site installation, or if no user is logged in to the badge, this value is null. |
BadgeMACAddr |
varchar(12) default NULL The BadgeMACAddr specifies the badge MAC address. Example value: 0009ef006e9a |
APMACAddr |
varchar(12) default NULL The APMACAddr column specifies the MAC address of the wireless access point with which the badge was most recently associated. Example value: 000f24e9dce0 |
Voltage |
decimal(7,2) default '0.00' The Voltage column specifies the badge battery voltage. Example value: 3.90 |
UIState |
varchar(15) default NULL The UIState column specifies whether a badge is in use (for example, on a call). Example values: Active, Standby |
SerialNo |
varchar(30) NOT NULL The SerialNo column stores the badge's serial number. |