view is a graphical representation of the tables in the entity and the relationships between the tables. You can disable and enable relationships, and edit filter criteria for each table in the
If you drag the entity map panel to the left, a
panel appears that includes information about a selected table or constraint. If you click the link between two tables, the
You can change which tables you view in the entity map. You can view all the tables or you can view the tables by their relationships with a selected table. By default the entity map shows enabled relationships.
You can choose the
Show excluded tables
option with any of the views to show disabled relationships.
Select one of the following views:
Shows all tables in the entity.
Shows all the parent tables of a selected table.
All immediate relationships
Shows the tables that have constraint relationships with a selected table. You can view one level of parent and child tables from the selected table.
Shows all the child tables of a selected table.
All cyclic relationships
Shows all constraint relationships that create cyclic relationships. The maximum number of cyclic relationships that TDM displays is 1000. You can choose to hide nodes and paths that are not a part of the cycles.
You can select any table in the map to edit the filter criteria. You can click a link to edit the constraint between the tables. You can disable relationships between tables from the map. When you select links in the
view, the corresponding rows are selected in the
You might define the driving table as Employee. Employee has a primary key, EmpID. Employee has three child tables that have the EmpID foreign key. The EmployeeBankDetails child table has an AccountNum constraint that relates EmployeeBankDetails to a BankAccounts table. When you create an entity with Employee as the driving table, Test Data Manager might create an entity map similar to the following map:
The driving table icon contains a star in the entity map.
To add a filter criteria for Employee, click the Employee table in the entity map. Edit the filter criteria from the Table Properties panel.
When you click the links between the Employee, EmployeeBankDetails, and BankAccounts table, the corresponding rows are selected in the