Database Details / Vocera Usage Data |
The devicestatuschange table stores data for device statuses that have been changed by users. 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 an event, accurate to the second. |
TxDate |
date default NULL The TxDate column stores the date of an event, accurate to the day. |
DeviceID |
varchar(20) NOT NULL Specifies the device ID from the Vocera Server. Example value: D-0009ef050686 |
DeviceSite |
varchar(50) NOT NULL Specifies the site of the device when the status changed. |
Status |
varchar(30) NOT NULL Specifies the device status. |
Notes |
text Notes describing the device status. |