DbSchema Layouts

We call layout a diagram plus the editors which can be open in the same tab. Tables, columns and foreign keys can be edited directly in the layout, by double-clicking them.

For a better understanding of the schema you can create multiple layouts. One table may show in any layout. Add table to layout by drag and drop from the tree pane.
The layouts are saved together with the schema to the project file. You may close a layout, it still will be saved, and later reopen it.
Diagram symbols.

Select multiple tables with the mouse and Control down. Right-click to get options, like create table groups.

Drag the layout with the right-mouse button. Zoom with the ALT key and the mouse.

Columns can hide in the diagram. Double-click the table header to get to the table dialog.

Besides Relational Data Browse, can fast view table data from database by clicking the table header with CTRL + SHIFT down.

About Foreign Keys

Create foreign keys by drag and drop of one column over the primary key column. If the data column data type does not match, the database may return an error. If you want to create the foreign key only for documentation or relational data browse, you can create virtual foreign keys. They won't be created in the database, but will be saved in the project file, so they will be available each time you open the project.

Foreign keys are drawn in the layout automatically. You cannot influence the drawing of foreign keys. They require a minimum space between tables to be drawn. If this fails a marker is painted on the foreign key icon.

Foreign keys can be drawn in layout in two modes : pointing to table ( default ) and pointing to column. Pointing to column may merge two lines in a single line.

Foreign keys can be drawn using different notations. Change this from the menu:

Printing and Documentation

DbSchema can generate :
  • Printings of the diagram
  • HTML5 image of the diagram. This is a very compact HTML file containing the SVG vector image of the diagram. The vector image uses the XML format. You can move the mouse over the generated image to read the table or column comments or highlight the foreign keys and their columns.
  • PDF documentation. This can be generated from the print preview dialog.
Generating documentation can be done also using automation scripts. Read this chapter to understand how you can generate documentation from scripts. Further details regarding the Groovy capabilities can be found in the SQL Editor documentation