Database Schema Tables

Database Schema Tables is a complete list of the tables included in the database schema.

The Vocera Analytics database schema uses a fact/dimension model, defining fact tables, dimension tables, and aggregated data tables:

• Fact tables contain raw data and links to the dimension tables that refer to it.
• Dimension tables contain descriptive attributes or fields that are typically text fields or discrete numbers that behave like text.

The following prefixes are used in the database schema:

• anl_—Tables containing Engage data.
• dim— Dimension tables for Vocera Voice Server data.
• dimvmp—Dimension tables for VMP.
• fct— Fact tables for Vocera Voice Server data.

  Facts tables sometimes contain dimension data which is used by reports and the dashboard to improve performance.

• summary—Summary tables containing Vocera Voice Server and VMP report data used in reports (the aggregated data for each day) and dashboards.

  Report summary tables in Engage data have the prefix anl_rpt_.

• v_— Database views that are useful for report writers.