Database Details / Vocera Usage Data |
The vmievent table stores data about events logged by Vocera Messaging Interface clients. This table has a unique key based on the TxMillis column.
For information about how to log information about external events—such as those from a middleware system—to Vocera Report Server logs, see the LogEvent() method in the Vocera Messaging Interface Guide.
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. |
EventID |
bigint(20) unsigned NOT NULL default '0' VMI event ID. |
EventType |
varchar(30) default NULL Specifies VMI Event type, supported even type are, MessageEvent, CancelEvent, SystemEvent |
Item1 |
varchar(64) default NULL Stores the first item in the event info specified by the logged VMI event. |
Item2 |
varchar(64) default NULL Stores the second item in the event info specified by the logged VMI event. |
Item3 |
varchar(64) default NULL Stores the third item in the event info specified by the logged VMI event. |
Item4 |
varchar(64) default NULL Stores the fourth item in the event info specified by the logged VMI event. |
Item5 |
varchar(64) default NULL Stores the fifth item in the event info specified by the logged VMI event. |
Item6 |
varchar(64) default NULL Stores the sixth item in the event info specified by the logged VMI event. |
Item7 |
varchar(64) default NULL Stores the seventh item in the event info specified by the logged VMI event. |
Item8 |
varchar(64) default NULL Stores the eighth item in the event info specified by the logged VMI event. |
Item9 |
varchar(64) default NULL Stores the ninth item in the event info specified by the logged VMI event. |
Item10 |
varchar(64) default NULL Stores the tenth item in the event info specified by the logged VMI event. |