Database Details / Vocera Usage Data |
The addressbookentries table stores data about Address Book Entries that can be entered and edited via the Address Book screen in the Vocera server Administration Console. This table has a primary key consisting of the following columns: FirstName, LastName, Site and Type.
Column | Description |
---|---|
LastName |
varchar(50) NOT NULL default '0' The LastName column specifies the last name for the entry, if the entry type is Person. If the entry type is Place, the value is an empty string. |
FirstName |
varchar(50) NOT NULL default '0' The FirstName column specifies the first name for the entry, if the entry type is Person. If the entry type is Place, the value is the name of the Place. |
Type |
varchar(50) NOT NULL default '' The Type column specifies the entry type: Person or Place. |
Site |
varchar(50) NOT NULL default '' The Site column specifies the Vocera site for which the entry is defined. |
Phone |
varchar(50) NOT NULL default '' Specifies the phone number. |
Pager |
varchar(50) NOT NULL default '' Specifies the pager number. |
DeletedFlag |
int(1) unsigned zerofill default '0' The DeletedFlag column indicates whether an entry has been deleted (0 = false). Although the entity may be flagged as deleted, it is not purged from the database because historical data (that is, older report logs) may continue to reference it. |