Chapter 7 Data Modeling

Table of Contents

7.1 Model Editor
7.1.1 Modeling Menus
7.1.2 The Toolbar
7.1.3 EER Diagrams
7.1.4 The Physical Schemata Panel
7.1.5 The Schema Privileges Panel
7.1.6 The SQL Scripts Panel
7.1.7 The Model Notes Panel
7.1.8 The History Palette
7.1.9 The Model Navigator Panel
7.1.10 The Catalog Tree Palette
7.1.11 The Layers Palette
7.1.12 The Properties Palette
7.2 EER Diagram Editor
7.2.1 The Vertical Toolbar
7.3 Working with Models
7.3.1 Creating Tables
7.3.2 Creating Foreign Key Relationships
7.3.3 Creating Views
7.3.4 Creating Routines and Routine Groups
7.3.5 Creating Layers
7.3.6 Creating Notes
7.3.7 Creating Text Objects
7.3.8 Creating Images
7.3.9 Reverse Engineering
7.3.10 Forward Engineering
7.4 Modeling Tutorials
7.4.1 Importing a Data Definition SQL Script
7.4.2 Using the Default Schema
7.4.3 Basic Modeling
7.4.4 Documenting the sakila Database
7.5 Printing
7.5.1 Printing Options
7.6 MySQL Workbench Schema Validation Plugins (Commercial Version)
7.6.1 General Validation
7.6.2 MySQL-Specific Validation
7.7 The DBDoc Model Reporting Dialog Window (Commercial Version)
7.8 Customizing DBDoc Model Reporting Templates
7.8.1 Supported Template Markers
7.8.2 Creating a Custom Template

MySQL Workbench provides extensive capabilities for creating and manipulating database models, including these:

This is not an exhaustive list. The following sections discuss these and additional data-modeling capabilities.

The Home window is the typical starting point for work with data modeling. In the Data Modeling section of the Workspace, you can use the action items there to create and manage your models.

To read more about modeling, see Section 7.1, “Model Editor”.