Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 14.9Mb
PDF (A4) - 14.9Mb
HTML Download (TGZ) - 13.0Mb
HTML Download (Zip) - 13.0Mb

MySQL Workbench Manual  /  ...  /  DBDoc Model Reporting

9.2.2 DBDoc Model Reporting

This dialog window is found by navigating to the Model menu and choosing the DBDoc - Model Reporting... item.


This functionality is only available in the MySQL Workbench Commercial Editions.

Use this dialog window to set the options for creating documentation of your database models.

Figure 9.14 The DBDoc Model Reporting Main Wizard

The DBDoc Model Reporting main wizard

You can choose from four available templates:

  • HTML Basic Frames: Model documentation in HTML format that makes use of frames

  • HTML Basic Single Page: Single Page HTML documentation, not using frames

  • HTML Detailed Frames: Detailed HTML documentation, using frames

  • Text Basic: Text file documentation

When you click a template, a preview image displays on the right side of the page. For the HTML Basic Frames template, you can select either the Colorful or the Restrained Colors option from the Style list. The HTML Basic Single Page template offers only the Colorful style. The HTML Detailed Frames template offers the Vibrant style, and also the more subdued Coated style. The Text Basic template offers only the Fixed Size Font style.

From the Base Options frame choose the report title and the output directory for the report files.

The following variables may be used to configure the output path:

  • ~: The user's home directory. Available on Linux and OS X versions only.

  • %desktopfolder%: The user's desktop.

  • %documentsfolder%: The user's Documents folders. The following table shows typical values for common platforms:

    Platform Typical Default Documents Folder
    Windows C:\Documents and Settings\user_name\My Documents
    Linux ~/Documents
    OS X Users/user_name/Documents
  • %date%: The date in the format YYYY-MM-DD.

  • %time%: The time in the format HHMM.

  • %year%: The year in the format YYYY.

  • %month%: The month in the format MM. January is 01 and December is 12.

  • %monthname%: The name of the month, rather than the number.

  • %day%: The day number in the format DD. For example, the 12th would be 12.

Content options can also be set:

  • Render Table Columns: Display all the columns.

  • Render Table Indices: Display all the indexes.

  • Render Foreign Keys: Display all the foreign keys.

  • List Foreign Keys that refer to that table: Display the tables that foreign keys reference.

  • Include DDL code for objects: Generates DDL code.

Clicking the Generate button creates the directory defined in the Output directory text box. If you chose to create HTML Basic Frames, you will find the following files in this directory:

  • basic.css: The style sheet for the overview.html page.

  • index.html: The main page.

  • overview.html: The model overview, the navigation links shown in the sidebar.

  • restrained.css: The CSS file used if the Restrained Colors style option was chosen.

  • table_details.html: The main frame of the model report.

Choosing the HTML Basic Single Page option creates a style sheet and an index.html file.

Choosing the HTML Detailed Frames option creates the following files:

  • basic.css: The style sheet for the overview.html page. This is used if the vibrant style is chosen.

  • coated.css: The CSS file used if the Coated style option was chosen.

  • index.html: The main page.

  • overview.html: Overview information for the report such as report title, project name and author.

  • overview_list.html: A summary of schema in the model along with a list of tables contained in each schema.

  • routine_details.html: List of all routines for the schema.

  • table_details.html: The main report details.

  • table_details_list.html: A Schema overview along with details of columns, indexes and foreign keys for each schema.

  • table_element_details.html: The details for every element of the table.

  • top.html: The top frame of the report.

  • view_details.html: List of all columns and indexes for the schema.

Choosing the Text Basic option creates a directory containing one text file.

You can click index.html to view a report. The following screenshot shows the HTML Detailed Frames report being displayed:

Figure 9.15 The DBDoc Model Report

The DBDoc Model Report

If you wish to create custom templates please refer to Section 9.7, “Customizing DBDoc Model Reporting Templates”.

User Comments
Sign Up Login You must be logged in to post a comment.