Schema Checker

<< Click to Display Table of Contents >>

EQuIS 7  >>  Live > Widgets >

Schema Checker

The EQuIS Live - Schema Checker widget compares table schemas in the client’s database to their predefined schemas, displaying the results in a tree view. Passing tables will show in green with the suffix “ -  PASSED”, while tables that fail will be in red with the suffix “ - FAILED”. Expanding the tree will display each field of that table along with the row and column count, and whether they passed or failed.

 

Live-Schema_Checker-Widget2

 

Widget Editor

 

To open the Widget Editor, select the More Options Live-More_Options-Icon icon in the upper right corner of the Schema Checker widget to open the drop-down menu and then select the Edit menu option. The widget properties are divided into two tabs: Tables and Options. The height of the widget may be set from the options tab.

Widget Title – By default, the widget title is EQuIS Live - Schema Checker. The title can be modified.

Widget Color – The color of the widget can be changed using the Change Widget ThemeLive-Widget-Color-Iconicon to the left of the widget title.

Cancel – Select the Close without Saving Live-Widget-Close-Icon button to exit the Widget Editor without saving changes.

Save – Changes will be applied to the widget by clicking on the Save Live-Widget-Save-Icon button. The Widget Editor screen will close after the save operation is complete.

 

Live-Schema_Checker_Widget-Editor

 

Five tables can be checked using the Live Schema Checker widget.

DT_LOGGER

DT_LOGGER_SERIES

DT_LOGGER_DATUM

DT_LOGGER_REMARK

RT_LOGGER_QUALIFIER