Online Documentation for SQL Manager for PostgreSQL
Automatically open last diagram file
With this option enabled the designer is opened with the last diagram edited.
When you work in Database Designer, you can choose one of the following modeling notations:
- Integration DEFinition for Information Modeling (IDEF1X);
- Information Engineering (IE).
The IDEF1X and IE notations use different symbols to represent relationships between entities (and tables).
Draw PRIMARY KEY fields separately
Separates Primary key fields from other fields with a horizontal line.
Draw entities icons
Displays icons at the left of each entity header according to its type.
Draw attributes icons
Displays icons at the left of each attribute according to its type (Primary key, Foreign key, ordinary field).
Draw only names of entities
Displays only entity headers, fields are hidden.
Draw FOREIGN KEY name
Displays foreign key names for the corresponding relations.
Draw attribute information
Display attribute properties (optionality, keys, etc.) in parentheses after the attribute name and type.
Draw page borders
Displays borders on the diagram page which are the borders used when printing pages with the diagram.
Displays dots in the diagram area to make the grid visible.
Snap to grid
Automatically aligns entities on the form with the nearest grid line. You cannot place an entity in between grid lines.
Sets grid spacing in pixels along the x- and y-axes. Specify a higher number to increase grid spacing.
Entity header font
Select a font type and size to display entity headers.
Select a font type and size to display attributes.
Additionally, you can set color for all VDBD diagram objects using the Style and Color section.
This section allows you to customize the default appearance of the diagram.
Select a diagram element from the list:
Not null field
Entity caption text
Selected entity caption text
Selected attribute text
Click an item to select a color for the corresponding element using the Color dialog where you can specify the required color from the palette.