Difference between revisions of "Entity Explorer"
Jump to navigation
Jump to search
(Created page with "<div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;"> __NOTOC__Home > Administration > Hornbill Application...") |
|||
| (7 intermediate revisions by 3 users not shown) | |||
| Line 2: | Line 2: | ||
__NOTOC__[[Main Page|Home]] > [[Administration]] > Hornbill Application > Application Entity Viewer | __NOTOC__[[Main Page|Home]] > [[Administration]] > Hornbill Application > Application Entity Viewer | ||
</div> | </div> | ||
| + | {|style="width: 100%" | ||
| + | |- valign="top" | ||
| + | |style="width:73%"| | ||
== Introduction == | == 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. | 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 | + | Accessing the Entity Viewer in the Administration Tool is only open to user's who are assigned the role '''Super User Role'''. |
| + | |style="width:5%"| | ||
| + | | | ||
| + | |style="width:22%; border-style: solid; border-width: 1px; border-color:#e6e6e6; background-color:#f2f2f2;"| | ||
| + | |||
| + | == Related Articles == | ||
| + | :* [[Database Direct]] | ||
| + | :* [[View_Table_Structure|Hornbill How To: Viewing Table Structures]] | ||
| + | |} | ||
== Features == | == Features == | ||
| − | * '''Entity Information''' - Provides a visual interface to explore the application tables and how they relate to each other | + | * '''Entity Information''' - Provides a visual interface to explore the application tables and how they relate to each other. A quick way to identify extended tables and the columns that create table links. 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''' - | + | * '''Database Schema Information''' - a simple description of each application table. Understand more about the columns contained in the tables including a supporting description, type, and information on which columns are indexed. |
Revision as of 10:03, 4 June 2021
Home > Administration > Hornbill Application > Application Entity Viewer
IntroductionEach 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 in the Administration Tool is only open to user's who are assigned the role Super User Role. |
Related Articles |
Features
- Entity Information - Provides a visual interface to explore the application tables and how they relate to each other. A quick way to identify extended tables and the columns that create table links. 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 - a simple description of each application table. Understand more about the columns contained in the tables including a supporting description, type, and information on which columns are indexed.