This tab helps you to set the parameters, that will be applied as defaults for the newly created tables and generated SQL scripts.
To open this dialog window, please select Diagram | Diagram Properties and switch to the Default Database Options tab. You can also select Diagram | Default Database Options directly.
There are the following options:
Default Data type
Use this drop-down list to select the data type. This option will be applied as a default data type for the newly created columns.
Default schema
Use this drop-down list to select the existing schema. This option will be applied as a default schema for the newly created database objects: tables, stored routines, views, types etc.
Foreign Key columns prefix
Sets the prefix, which will be added to the names of new foreign key columns. You can use substitution %TABLENAME%, which will be replaced by the name of the master table.
Enclose Names
This option forces quoting of the diagram objects names by a quote character, i.e. it makes
"Column" and "Table" instead of Column and Table in SQL script.
Quoted Character
This option sets the character that will be used on SQL script generation to quote table column names and values. Default PostgreSQL quoted symbol is '"'. We strongly recommend do not change this property.
Type names
Determines what type names will be used in the generated SQL, PostgreSQL (int2, int4, int8,
varchar, char, bool, float8, float4) or standard ones (smallint, integer, bigint, character varying, character, boolean, double precision, real).
See also:
Diagram: General Diagram Properties | Diagram SQL Preview | Diagram Notes | Diagram Statistics Diagram Objects: Creating a Reference
6.10.2. Diagram Naming
This tab helps you to set the patterns for newly created objects.
Table
Set the naming pattern for newly created tables. Default is "Table_". Number will be automatically added to the end, e.g. "Table_04".
View
Set the naming pattern for newly created views. Default is "View_". Number will be automatically added to the end, e.g. "View_12".
Stored Routine
Set the naming pattern for newly created stored routines. Default is "Procedure_". Number will be automatically added to the end, e.g. "Procedure_01".
Reference
%TOTABLE% - the argument is the referenced table name.
Reference Column
Set the naming pattern for newly created referenced columns. Such format specifiers may be applied:
%TOTABLE% - the argument is the referenced table name;
%TOCOLUMN% - the argument is the referenced column name in the referenced table.
6.10.3. Diagram Pages
This tab helps you to set the size of the diagram. You can change the number of pages in the diagram.
Horizontal Page Count
Horizontal size of the diagram, in pages.
Vertical Page Count
Vertical size of the diagram, in pages.
6.10.4. Diagram SQL Preview
This tab shows you SQL representation of your diagram. To access this dialog window, please select Diagram | Diagram Properties and switch to the Preview tab. SQL syntax elements are colored.
It is possible to copy these definitions to clipboard.
See also:
Diagram: General Diagram Properties | Database Options | Diagram Notes | Diagram Statistics
6.10.5. Diagram Notes
This tab helps you to write descriptions and annotations for the diagram.
To access this dialog window, please select Diagram | Diagram Properties and switch to the Notes tab.
Use the bottom tabs to select between the description and annotation of the diagram.
See also:
Diagram: General Diagram Properties | Database Options | Diagram SQL Preview | Diagram Statistics
6.10.6. Diagram Statistics
This tab shows you the numerical statistics on the diagram objects.
You can see how many domains, tables, columns and other objects your diagram contains.
See also:
Diagram: General Diagram Properties | Database Options | Diagram SQL Preview | Diagram Notes
6.11. Zooming a Diagram
When a diagram is opened for the first time its zoom level is set to the normal size. You can change the zoom level of your database diagram.
There are several ways to zoom a diagram in the window:
The most convenient variant is to use the mouse wheel holding Ctrl button. Turn up the mouse wheel to zoom in the digram, to zoom out turn down the mouse wheel.
In the View menu you can find the Scale drop-down list with predefined scale factors. The same drop-down list is also placed in the View toolbar.
Press F6 to zoom in the diagram, and F7 to zoom out. Press F5 to return to actual size (100%) of the diagram.
The Zoom-in ( ) and Zoom-out ( ) buttons are placed in the Palette toolbar . Select the View | Zoom In or View | Zoom Out menu items to zoom in and to zoom out respectively.
Please pay attention to the Fit To Screen function. It helps to display your diagram fully. You can call this function from the View menu by clicking on the Fit To Screen label.
6.12. Auto Layout Diagram
The Auto-Layout function automatically rearranges symbols in the active diagram. The symbols are arranged in rows from left to right horizontally. This function is useful when you want to line up multiple tables in the diagram automatically.
To call this function select View | Auto-Layout. Please note, that auto-layout operation is undoable in most cases.
See also:
Diagram: Using Snapping Grid | Zooming a Diagram
The Find objects feature lets you search objects within the entire Database Designer for PostgreSQL diagram so that you could locate the necessary objects in the diagram easily, find all the attributes related to a given object.
To call Find Objects dialog window, select the Edit | Find Objects menu item or press Ctrl-F.