Chat now with support
Chat with Support

Toad Data Modeler 7.0 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 MySQL 8.0 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Specifics - Oracle 12c Release 2 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 SQLite 3.7 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
Copyright Legal Notices

Entity Right-Click Options

Right-click the selected entity on the Workspace to see the following options:

Option Description

Format

Opens the Object Format dialog for the selected entity.

Add into Workspace

Opens the Workspaces dialog where you can select a Workspace to add the entity to.

Add into New Workspace

Creates a new Workspace and adds the entity to it.

Remove from Workspace

Removes the selected shortcut from particular Workspace.

Delete Object

Deletes selected entity from model.

Arrange

Arranges the entity in another layer.

Arrange Objects in Layers

Copy Object Layout to Copies the layout of the selected object to another Workspace
Add Object to Gallery Adds objects to selected Gallery.

Recalculate Size

Adjusts the entity size to the length of its columns.

Align Self Relationship

Aligns self relationship.

Edit

Opens the Entity Properties form.

Add Creates a new object (Attribute, Key or Index) in the selected entity.
Change Script Contains one option that allows you to compare selected entity with any other entity in another model or database and generate Change Script.
Edit Attribute... Opens Attribute Properties form (the item is active if attribute is selected)
Select  
Select Parent Objects Selects parent objects of the selected entity on Workspace.
Select Child Objects Selects child objects of the selected entity on Workspace.
Select Parent and Child Objects

Selects parent and child objects of the selected entity on Workspace.

TIP: Use these options for next multiple copy, move, format change etc.

Fill  

Fill Parent Objects

Displays shortcuts of parent objects of the selected entity on Workspace.

Fill Child Objects

Displays shortcuts of child objects of the selected entity on Workspace.

Fill Parent and Child Objects

Displays shortcuts of parent and child objects of the selected entity on Workspace.

Add to Category Adds object to selected category.
Macros Shows available macros for the selected entity.
 

Attributes

Toad Data Modeler allows you to design Entity Relationship Diagrams of specific database platforms, convert physical model from one database platform to another, create an ER Diagram directly from your database (Reverse Engineering feature), update physical models, generate DDL/SQL scripts and Change Scripts, create Dictionary Types, Views, Triggers, Functions, generate detailed documentation to your model (in HTML, RTF, PDF, XSLT formats) and much more.

This chapter describes features and functions related to Physical Data Modeling. Look around each section to get the information you need.

Note: See the sample physical model Videorental (Oracle 10g db) that is included in the installation package of Toad Data Modeler. Default location is: C:\Program Files (x86)\Quest Software\Toad Data Modeler7.0\Samples.

Benefits of Physical Data Model

  • Detailed definition of database structure, including database specific items, for example:
    • Stored procedures
    • Functions
    • Triggers
    • Views
    • Materialized views
    • Sequences (auto increments) etc.
  • Possibility to synchronize local model with existing database.
  • Possibility to specify logical names for objects (captions for tables, attributes and other objects).
  • Detailed database specific information can be exported to HTML/RTF/PDF or XML/XHTML/CSV reports.
  • Automatic generation of SQL code for selected objects (SQL code generation is not available in Logical and Universal Model)
  • Automatic migration of PK attributes to child entities (Attributes don't migrate to child entities in Logical Model)

Create Attributes

You can create attributes in:

  • Entity right-click menu on Workspace
  • Entity Properties dialog
  • Attribute Properties dialog
  • Model Explorer

To create an attribute on the Workspace

Right-click an entity on the Workspace and select Add | Attribute. The Attribute Properties dialog opens.

Note: Select the Primary Key (Unique) checkbox to set the attribute as PK or unique attribute.

To create an attribute in the Entity Properties form

  1. Double-click an entity on Workspace.
  2. In the Entity Properties form, switch to the Attributes tab and click Add.

Entity Properties attribute columns

Column/Option Description

Key

Graphical representation of keys of a particular attribute

Caption

Logical attribute name

Name

Physical attribute name

Data Type

Data Type of an attribute

TIP: You can set a default data type for newly created attributes. See Settings Menu | Options | Physical Model | *database platform and version* | Default Data Type combo-box. (The selected data type will be also applied to Dictionary Types and Domains.)

p1

Parameter 1. Only some of the available data types have this parameter. Defines properties of the selected data type, e.g. length in case of the Char data type.

p2

Parameter 2. Only some of the available data types have two parameters. E.g. the Decimal data type has two parameters, which define precision and scale.

Not Null

When checked, the attribute cannot be empty.

Comments

Comments or descriptions related to the attribute

Status

Shows status of attributes in grid. Status of Items in Grids

Buttons:

- opens the Application Variables form

Smaller Add button- adds new attributes quickly, just enter attribute name and then click Add.

Bigger Add button - adds an attribute

Edit - opens Attribute Properties of the selected entity

Delete - deletes the selected attribute

- moves the selected attribute up or down in the list

To create another attribute in the Attribute Properties form

Click OK+Add.

To create an attribute in Model Explorer

Unfold the Entities folder | Unfold the specific entity folder | Right-click the Attributes folder | Add Attribute.

Edit Attributes

  • In the Entity Properties dialog | Attributes tab, double-click the selected attribute.

or

  • Find the attribute in Model Explorer | EntityName folder | Attributes | Double-click the selected attribute.

Example: The Attribute Properties dialog (Oracle 10g db):

Tab/Option Description

Object Navigator Dropdown Menu

Object Navigator Dropdown Menu can be expanded or collapsed by clicking the right black arrow in top right corner.

All attributes in your entity are listed here. This allows you to edit them quickly and comfortably from one place.

Tip: After you finish editing an entity, click Apply to confirm changes and select another entity from the Object Navigator box.

General Tab

General properties of attribute

Caption

Logical column name

Name

Physical attribute name

See About Naming Conventions for more information.

Primary Key Select this checkbox to set the attribute to be a part of primary key.
Not Null

Select this checkbox to set the attribute Not Null.

See NotNull Property for PK and AK Attributes for more information.

Unique

Select this checkbox to set the attribute as unique.

See Unique Attributes for more information.

Data Type

Data Type selection box

TIP:

  • Before you create new attributes, set a default data type, including parameters, for particular database. See the Settings menu | Options | Physical Model | particular database version | Default Data Type combo-box. (The selected data type will be applied also for Dictionary Types and Domains.)
  • Set maximal length for display of data types in the physical ERD. Select Settings | Options | Graphics | Maximal Number of Characters for Displayed Data Type.

Domains

Domains selection box

Note: It's not possible to assign an attribute a data type and a domain at the same time. If you select a domain, data type will be set automatically from the domain.

Default

Default value definition

Default Rule

Default rule selection

Note: Other options on the General tab vary according to a database type. Options specific for your database can be found in the Databases chapter.

Check Constraints Tab

On this tab, you can add, edit and delete check constraints.

Foreign Keys Tab

Details of a foreign key attribute are listed here.

Entity

Name of parent entity

Relationship

Name of relationship connecting the parent entity and child entity

Attribute

Name of attribute

Permissions Tab

On this tab, you can assign a User or User Group permissions for the selected attribute.

Notes Tab

A tab for notes on the attribute. The text will display in a pop-up box when you point your mouse cursor at the attribute name in ER diagram (the Attributes item has to be selected in Display Level).

Not Null Constraint Tab

Options related to Not Null Constraint definition.

Click this button to open the parent form (Entity Properties form).

Note: Above the Object Navigator Dropdown Menu, you can see name of the entity that the attribute belongs to. The Properties dialog of this entity will open.

Related Documents