Online Documentation for SQL Manager for PostgreSQL

Database Designer


CheckBox Automatically open last diagram file

With this option enabled the designer is opened with the last diagram edited.

 

Visual settings

Model notation

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).

Environment Options - Tools - VDBD

CheckBox Draw PRIMARY KEY fields separately

Separates Primary key fields from other fields with a horizontal line.

 

Environment Options - Tools - VDBD - Draw PRIMARY KEY fields separately

 

CheckBox Draw entities icons

Displays icons at the left of each entity header according to its type.

 

Environment Options - Tools - VDBD - Draw entities icons

 

CheckBox Draw attributes icons

Displays icons at the left of each attribute according to its type (Primary key, Foreign key, ordinary field).

 

Environment Options - Tools - VDBD - Draw attributes icons

 

CheckBox Draw only names of entities

Displays only entity headers, fields are hidden.

 

Environment Options - Tools - VDBD - Draw only names of entities

 

CheckBox Draw FOREIGN KEY name

Displays foreign key names for the corresponding relations.

 

Environment Options - Tools - VDBD - Draw FOREIGN KEY name

 

CheckBox Draw attribute information

Display attribute properties (optionality, keys, etc.) in parentheses after the attribute name and type.

 

Environment Options - Tools - VDBD - Draw attributes information

 

CheckBox Draw page borders

Displays borders on the diagram page which are the borders used when printing pages with the diagram.

 

 

Grid options

CheckBox Show grid

Displays dots in the diagram area to make the grid visible.

 

CheckBox Snap to grid

Automatically aligns entities on the form with the nearest grid line. You cannot place an entity in between grid lines.

 

Grid size

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.

 

Attributes font

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:

 

Workspace

Selected item

Table

Relation

Field

Primary key

Unique field

Foreign key

Autoincrement field

Not null field

Comment

 

 

 

Work area

 

Environment Options - Tools - VDBD - Color Palette - Work area

 

 

Entity

 

Environment Options - Tools - VDBD - Color Palette - Entity

 

Entity caption text

 

Environment Options - Tools - VDBD - Color Palette - Entity caption text

 

Attribute text

 

Environment Options - Tools - VDBD - Color Palette - Attribute text

 

Selection

 

Environment Options - Tools - VDBD - Color Palette - Selection

 

Selected entity caption text

 

Environment Options - Tools - VDBD - Color Palette - Selected entity caption text

 

Selected attribute text

 

Environment Options - Tools - VDBD - Color Palette - 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.

 


See also:

Database Designer