Database Details / Vocera Usage Data |
The vmimessages table stores data about messages sent by Vocera Messaging Interface clients.
This table has a unique 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. |
ClientID |
varchar(50) NOT NULL default '' The unique ID of the Vocera Messaging Interface client. |
DestinationType |
varchar(20) NOT NULL default '' Specifies which type of Vocera entity (for example, user or group) was sent the message. |
DestinationSite |
varchar(50) default NULL In a multi-site installation, the DestinationSite column specifies the Vocera site with which the destination is associated. In a single-site installation, this value is null. |
DestinationID |
varchar(70) NOT NULL default '' Specifies the ID of the message destination. |
DestinationName |
varchar(100) default NULL Specifies the name of the message recipient. |
MessageID |
bigint(20) unsigned NOT NULL default '0' The Vocera Messaging Interface message ID, which must be unique for the client. |
Priority |
varchar(20) default NULL Specifies the Vocera Messaging Interface priority (Normal, High, or Urgent). |
MessageText |
text NOT NULL Specifies the content of the message. The length of the message is limited to 256 characters. |