Chat now with support
Chat with Support

Toad Data Modeler 6.3 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Legal Information

Inheritance

Create Inheritances

Models and Model Objects > Logical Data Model > Inheritance > Create Inheritances
  1. Click on the toolbar (also CTRL+I)
  1. Move your mouse cursor over the work area and click the parent entity and then the target entity (child).

TIP:

  • While creating an inheritance, you can add handle points at the same time. Click the parent entity and then click the work area as many times as many handle points you want to create. Finally click the child entity.
  • Create several Children of the existing inheritance:
  1. Click the Inheritance icon on the toolbar.
  2. Click the inheritance in the model.
  3. Click another entity in the model.

Edit Inheritances

Models and Model Objects > Logical Data Model > Inheritance > Edit Inheritances
  • Double-click the inheritance on the Workspace.

or

  • Edit the inheritance in Model Explorer | Inheritances folder | double-click the selected inheritance (or right-click | Edit).

Option Description

Object Navigator Dropdown Menu

All inheritances in your model are listed here. Use it to switch between multiple objects and edit them easily.

General Tab

Description

Caption

Logical name of inheritance

Name

Physical name of inheritance

Parent

Name of the parent entity

Logical Only

Select this checkbox to not convert the inheritance during LER to PER conversion.

Exclusive

Definition of exclusive inheritance.

For exclusive inheritances, Toad Data Modeler generates triggers that will perform a check whether a correct record in siblings exists or not, and decide whether a record can be added to table or not etc.  

Exclusive inheritances are displayed with cross in the middle of the graphics:

Standard inheritances don't have the cross inside the graphics:

Complete

Logical information only. The information says that all records must be complete.

Generation Tab

On this tab, select how do you want to resolve the inheritance during conversion from LER to PER. Inheritance

Descendents Tab

Description

Name

Name of descendent

Discriminator Valid Value

Valid values of Discriminator

Edit Discriminator

Opens the Valid Values dialog for the selected Discriminator.

To Do Tab

You can enter To Do tasks related to the object here.

Note: To display all To Do tasks, select To Do from Model menu.

Description Tab You can enter the object description here.

Conversion to Physical Model

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating