groups

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

Table 1. groups table
Column Description
GroupID

varchar(70) default NULL

Specifies the internal ID of a group.

GroupName

varchar(50) NOT NULL default '0'

The GroupName column specifies the name of a group. Example values: Code Blue Group, Facilities

Site

varchar(50) NOT NULL default ''

The Site column specifies the Vocera site with which a group is associated. In a single-site installation, this value is the literal string s-global.

CostCenter

varchar(100) default NULL

The CostCenter column stores a value that identifies the group's cost center (typically used for accounting purposes).

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.

UserMembers

mediumtext default NULL

Stores the user members of the group. The values are separated by a vertical bar ( | ).

Department

varchar(50) default NULL

Stores the group's department. A group can have only one department or none.