dnd

The dnd table stores data about when users turn Do Not Disturb (DND) mode on or off. This table has a primary key based on the TxMillis column.

Table 1. dnd table
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.

UserID

varchar(70) default NULL

Specifies the user ID of the person who turned DND mode on or off. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Server.

UserSite

varchar(50) default NULL

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.

DND

int(1) default null

Whether the user turned DND mode off or on; 0 means off and 1 means on.