The sites table stores data about Vocera sites. This data can be entered and edited via the Sites screen in the Vocera server Administration Console. The table has a primary key based on the SiteId column.

Table 1. sites table
Column Description

varchar(50) NOT NULL default ''

The SiteId column uniquely identifies a site. Example value: s-global


varchar(50) NOT NULL default '0'

The SiteName column specifies the name of a site. Example value: Global


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.