Explore table relations window
Explore table relations is invoked from the Object context menu.
The basic idea is simple: the selected table is opened and shown with all inbound and outbound table relations. The selected table is then "fully explored" in the 1st degree connections. However the related tables may themselves have further, yet unexplored table relations:
| # | Name | Description |
|---|---|---|
| 1 | Node (table) | Here the initial table on which the explore table relations was initiated. |
| 2 | Edge (relations) | Each edge in the graph represents that there is at least one table relation from the source table to the target table. Right-click to invoke context menu. |
| 3 | Unexplored incoming table relations | The Item Ledger Entry table still has 22 inbound table relations to be explored. See the node context menu below. |
| 4 | Unexplored outgoing table relations | The Item Ledger Entry table still has 21 outbound table relations to be explored. See the node context menu below. |
| 5 | Redraw | Force redraw of diagram. |
| 6 | Layout algorithm | Select a layout algorithm after your liking. |
| 7 | Routing | Select the edge shapes. |
| 8 | Direction | Select the direction of the layout. |
| 9 | Save | Save the image as a PNG file. |
| 10 | Detailed | Check for detailed view (default) where counts of unexplored ingoing and outgoing relations is displayed. |
| 11 | Included objects | List of included objects. See below for how object can be included and excluded again. |
| 12 | Excluded objects | List of objects that have been excluded after having been included. |
| 10 | Selecting tables | Select a single table by clicking on it in the diagram or in the Included objects list. You can select multiple tables by holding down the Ctrl key. To action selected objects, right-click to invoke the context menu (described below). |
Notice that nodes are draggable with the mouse. However, wait with fine-tuning layout positioning, as whenever a new table is added or removed from the diagram, it it is redrawn with the selected layout algorithm.
Edge context menu
| Menu item | Description |
|---|---|
| Show Details | Runs the find usages process to find all table relations from the source table to the target table. |
Node context menu
Node context menu:
| Menu item | Description |
|---|---|
| Explore All Inbound | Adds all tables that have table relations targeting are the table on which the context menu was invoked. |
| Explore Selected (Inbound) | Like Explore all inbound, but allows you to select which tables to include. |
| Explore All Outbound | Adds all tables that have table relations to the table on which the context menu was invoked. |
| Explore Selected (Outbound) | Like Explore all outbound, but allows you to select which tables to include. |
| Explore All In/Outbound | Add all inbound and outbound tables to the diagram. |
| Navigate to Object | Navigates to the object. |
Selected node context menu
| Menu item | Description |
|---|---|
| Exclude X Selected | Here X is the number of currently selected objects. Excludes the selected objects from the diagram and adds them to the Excluded objects list. |
| Exclude X Unselected | Here X is the number of included objects that are currently not selected. Excludes the unselected objects from the diagram and adds them to the Excluded objects list. |