|Database Details / Vocera Usage Data|
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.
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.