Entity Explorer

Home > Administration > Hornbill Application > Application Entity Viewer

Introduction

Each Hornbill application is delivered with access to its database schema and entity relationships. This is useful when trying to understand where to identify tables, table columns, primary keys, and suitable fields for making your table joins. This functionality is intended to make your quest for information that little bit easier when constructing those all important analytics and management reports.

Accessing the Entity Viewer for any application requires the role Advanced Reporting Admin.

Features

• Entity Information - Provides a visual interface to explore the application tables and how they relate to each other providing a quick way to identify extended tables and the columns that create the link. Click on a table and use the "Description" and "Information" buttons to the top right of the graphical user interface to explore each table in more detail.

• Database Schema Information - quite simply a textual description of each application table. Understand the columns contained in each table including a supporting description, type, and information on which columns are indexed.