addressbookentries

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.

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