Data Dictionary Overview

This overview describes each table in the Fusion Central and Remote databases. These include data tables as well as tables used to store configuration details and meta-data.

Note that tables prefixed with REF_ are custom reference tables added to the Fusion database (different for all clients). Tables prefixed with UDEF_ are custom data tables that have been added to the database using the Fusion Administrator application. Database views can also be added to the database to facilitate data exports, querying, and reporting.

If you would like to generate a database diagram (with relationships), we recommend using SQL tools to do this. The following article can be used as a guide for creating the data model using SQL Server Management Studio:

SQL Server Database Diagram Tool in Management Studio (mssqltips.com)

The following is an example ER diagram with a focus on those tables used to control access/security and data tables: