## The User Interface

### Main Elements

#### The Main Menu

Through the main menu you gain access to general functions of the program. There are seven main menu items, File, Edit, Display, Database, Options, Windows and Help.

#### File Menu

The File Menu

##### File - New

File - New creates a new empty model. If you have opened another model before you can switch between the new and the other model using the Windows menu.

##### File - Open ...

File-Open ... opens an existing model from your harddisk or mapped network device. DBDesigner creates a new empty model every time it is started so you can start modelling immediately. If you open a model and no changes have been applied to the empty model it is closed automatically and replaced with the opened model.

##### File - Open from Database ...

File - Open from Database ... makes it possible to open a model saved in a database. When selected this menu item the DB-Connection Dialog pops up and you have to select the database containing the desired model. There can be stored more than one model in the database so you have to select the appropriate model then.

##### File - Open recent

File - Open recent displays a list of the last opened models to improve speed opening the most used models. If a new model is opened it is added to the list. If there are more than 10 entries in the list the last entry is deleted automatically.

##### File - Add Model ...

File - Add Model ... lets you add an existing model to the currently opened model. After the model has been imported all new objects are selected so the can be moved to an appropriate position.

##### File - Save

Use File-File-Save ... to save your model to the harddisk or a mapped network device. When you save a model for the first time, you are promt to locate the destination folder and enter the name of the model. The model is added to the File-Open Recent list automatically.

##### File - Save As ...

File - Save As ... can be used to save your current model with a new name. You are promt to locate the destination folder and enter the new name of the model.

##### File - Save in Database ...

It is possible to store the model directly in the database you work on. A new database table is used to store all models in this database. This new table does not interfere with the database synconisation and reverse engineering functions.

When selected the File-Save in Database ... menu item the DB-Connection Dialog pops up and you have to select the database which will containing the model. You have to enter the desired name of the model and the model will be stored.

##### File - Close

File - Close closes the current active model.

##### File - Export-SQL Create Script ...

Use this menu item to export the current active model as a SQL Create script which can be executed against the datbase manually to create the nessesary tables. You can use the database synchronise function instead which will create and update your database automatically.

##### File - Export-SQL Drop Script ...

Use this menu item to export the current active model as a SQL Drop script which can be executed against the datbase manually to drop the desired tables. You can use the database synchronise function instead which will create and update your database automatically.

##### File - Export-Export Model as Image ...

Select this function to export the whole model as an image file. The image can be saved in the PNG or BMP file format. The PNG Format is recommended. Please note that using the BMP file format will result in very large images, approximatly 20 MB at default size.

##### File - Page & Printer Setup ...

Before printing the model you have to select the appropriate printer and set the page size and orientation as well as the scale factor of the model which enables you to print the model distributed on several pages.

##### File - Print ...

File - Print ... lets you select the pages of the model an the number of copies you want to print.

##### File - Exit

File - Exit closes the program.

#### Edit Menu

The Edit Menu

##### Edit - Undo

Use Edit - Undo to take back the last change applied to the model. You can use this command several times to take back all changes you made.

##### Edit - Redo

Edit - Redo applies the last undone action again. This command can also be repeated several times when you have undone several actions.

##### Edit - Copy selected

When you have selected on or more objects you can use this command to copy the objects to the clipboard. The objects are stored as text in XML format. You can use any other application to paste the objects.

##### Edit - Cut selected

This command is similar to Edit-Copy selected but the objects will also be deleted from the model.

##### Edit - Paste

Edit - Paste is used to insert previous copied objects from the clipboard. Relation are only inserted if both tables have been copied because when the objects are inserted, new object-identifiers are assigned.

##### Edit - Delete selected

Edit - Delete selected removes all selected objects from the model. When this happens unintended you can use the undo command.

##### Edit - Select All

Use Edit - Select All to select all objects from the model.

#### Display Menu

The Display Menu

##### Display - Design Mode

Select this menu item to change to Design Mode. A checkmark will be drawn left to the menu item when Design Mode is selected.

##### Display - Query Mode

Select this menu item to change to Query Mode. A checkmark will be drawn left to the menu item when Query Mode is selected.

##### Display - Notation

Display - Notation specifies the notation used to display the model. When a notation is selected a checkmark will be drawn left to the menu item.

##### Display - Notation - EER

Display - Notation - EER will set the notation to the common EER notation.

##### Display - Notation - EER [1,n]

Display - Notation - EER [1,n] will set the notation to another EER notation, displaying intervals.

##### Display - Notation - Traditional

Display - Notation - Traditional will change to a notation which will be familia to Erwin© users.

##### Display - Table Columns-Entity Level

Display - Table Columns will specify how tables are displayed on the model. Use Display - Table Columns-Entity Level to hide all column information.

##### Display - Table Columns-Primary Key Level

When Display - Table Columns-Primary Key Level is selected, only primary key columns are displayed.

##### Display - Table Columns-Attribute Level

Use Display - Table Columns-Attribute Level to display all columns of the tables.

##### Display - Table Columns-Physical Schema Level

Select Display - Table Columns-Physical Schema Level to display the datatypes of the columns.

##### Display - Table Columns-Show Foreign Keys

If Display-Table Columns-Show Foreign Keys is select foreign keys are shown as columns in the appropriate tables.

##### Display - Table Indices

This menu item is used to display each table's indices on the model.

##### Display - List Table Indices

A checkmark will be drawn left to the menu item when table indices are displayed.

##### Display - Display Relation Names

Display - Display Relation Names can be selected to display the names of relations.

##### Display - Display Page Grid

Select Display - Display Page Grid to show the partitioning of printable pages. You can use the Page & Printer Setup Dialog to change the initial page size.

#### Database Menu

The Database Menu

##### Database - Database Synchronisation

Use this function to synchronise your model with a database. This function can also be used with a clear database to create all the tables.

##### Database - Reverse Engineering

Use this function to create a model based on an existing database.

#### Plugins Menu

The Plugins Menu

The Plugins Menu lists a number of DBDesigner 4 plugins available in the program's directory.

#### Options Menu

The Options Menu

##### Options - Model Options

Options - Model Options will call the Model Options Dialog where several options can be set for the model like the default datatype or the display font.

##### Options - DBDesigner Options

Options - Model Options will call the Model DBDesigner Options Dialog where several general options can be set.

#### Windows Menu

The Windows Menu

##### Windows - Cascade

Use this command if you have opened several models and want to arrange the windows in a overlapping style.

##### Windows - Tile

Use this command if you have opened several models and want to arrange the windows beside each other.

##### Windows - Style - Standard

The Windows-Style menu items can be used to change the overall appearance of the program.

Select Windows - Style - Standard to set the style to Windows default.

##### Windows - Style - Motif

Select Windows - Style - Motif to set the style to the Motif style.

##### Windows - Style - SGI

Select Windows - Style - Motif to set the style to the SGI style.

##### Windows - Style - Platinum

Select Windows - Style - Platinum to set the style to the Platinum style. This is the default window style.

##### Windows - Toolbar

Checked this menu item to display the Toolbar which is docked to the left of the main window.

##### Windows - Tools (MS Windows only)

If this menu item is checked the Tool-Palette becomes visible. It can be used instead of the Toolbar.

##### Windows - Navigator & Info Palette

If this menu item is checked the Navigator & Info-Palette becomes visible. If it is unchecked the Navigator & Info-Palette is hidden.

##### Windows - Datatypes Palette

If this menu item is checked the Datatypes-Palette becomes visible. If it is unchecked the Datatypes - Palette is hidden.

##### Windows - DB-Model Palette

If this menu item is checked the DB-Model-Palette becomes visible. If it is unchecked the DB-Model-Palette is hidden.

##### Windows - Reset Palette Positions

Call this command to reset the palette positions to their initial locations.

##### Windows - Dock Palettes

Use this menu item to dock or undock the palettes to the right of the main window.

Below this menu item a list of all opened models is displayed. Select a menu item to bring the appropriate menu to the front.

#### Help Menu

The Help Menu

##### Help - About

Displays the splash screen.

##### Help - Online Documentation

Lauches an explorer with this documents.

##### Help - Visit fabFORCE.net

Lauches an explorer and navigates to http://www.fabFORCE.net.

##### Help - Check for New Versions

Lauches an explorer, navigates to http://www.fabFORCE.net/downloads.

### Palettes

Palettes are floating windows which always stay on top and provide fast access to important functions.

#### The Toolbar / Tools Palette

The Toolbar (and the Tools Palette) provides quick access to the most important work tools. (On a Linux system the Tools Palette is disable because of a limitation in the window system.)

The Toolbar

To view the Tools Palette select select [Windows]->[Tools] from the main menu. Deselect [Windows]->[Tools docked] to hide the docked palette. By default the Tools Palette can be found on the upper left corner of the screen.

The Tools Palette

Click on the icon to activate the appropriate tool. The mouse cursor will change. Take a look at the Modelling Section to see how to use the single tools.

Clicking on the buttons will call the assigned functions. Use the mode button to switch between the Design- and Query-Mode. In Design-Mode tables can be moved with the selection tool, too. In Query-Mode you have to use the Move-Tool.

#### The Navigator Palette

The Navigator Palette (top right) shows the current visible region of the model and can be used to navigate on the model.

The Navigator Palette

##### Navigator Page

The current visible region is marked by a blue rectangle. When the model is scrolled or moved with the panning tool the marker is moved to the new position automatically. Click on the white area to move the marker and scroll the model to the appropriate position. Depending on the speed of your machine and the size of the model you can also drag the marker.

To change to Zoom-Factor you can use the trackbar or click on the small and large table symbol left and right to the trackbar. To enter the zoom factor manually click on the zoom edit, type in the desired value (without percent charater) and press enter.

Click on the upper right icon to display the palette's popup menu. Select a menu item to set the zoom factor to the displayed value.

##### Info Page

Click on the Info-Tab to switch to the info page. On this page you can change the name and position of the selected object. When two or more objects are selected it is not possible to a value. When an image is selected the size can also be changed.

#### The Datatypes Palette

The Datatypes-Palette (middle right) shows the existing datatypes which can be used to build the database-tables.

The Datatypes Palette

##### Common Datatypes Page

On the Common-Tab the most used Datatypes are visible and are ready to be dragged onto table columns. To add a new User Defined Datatype click the upper right icon to display the palette's popup menu. Select Create New Datatype and the Datatype-Dialog will be displayed showing the new created datatype. To remove a Datatype from the Common-Tab select Del from Common Datatypes from the palette's popup menu.

##### All Datatypes-Page

Click on the All types-Tab to display all available datatypes. The datatypes are split into five categries. Numeric Types, Date and Time Types, String Types, Blob and Text Types and User defined Types. Doubleclick on a category to show all assigned datatypes. New created datatypes will always be assigned to the User defined Types. Doubleclick on a datatype to call the Datatype Editor. Select and right click on a datatype and select Add to Common Datatypes to add a Datatype to the Common-Tab.

##### Replace Datatypes in Tables

If you want to replace a datatype or change a parameter in several tables then you can use the Replace Datatypes in Tables function from the palette's popup menu. It works just like the Search and Replace function in Word©.

The Replace Datatype Dialog

Select the datatype you want to replace. Then select the datatype which should be inserted. To change only the parametes of a datatype select the same datatype in both dropdowns and check the Mach Params flag and enter the parameter you want to replace and the parameter which should be inserted.

Select the Region of the function and press Execute to replace the datatype.

##### Reinitialise Datatypes

To reset the datatypes to their initial state select Reinitialise Datatypes from the palette's popup menu. The inital settings will be loaded from the ini-files. Manually created datatypes will be replaced by the standard datatype of the model.

#### The DB-Model-Palette

The DB-Model-Palette displays all existing tables in the model and their columns and relations.

The Model Palette

Click on the plus symbols to display the columns and relations of a table. Doubleclick on a table to call the Table Editor or select Edit Object from the table's popup menu.

#### The Staturbar

The Statusbar displays information about the currently selected Tool an can be used to read and set the zoom factor to a predefined value, fast.

The Statusbar

Click on the Zoom Factor Edit left on the Statusbar. A list of zoom factors pops up. Select the desired zoom factor or press ESC to close the list.

If the database model is modified the indicator left to the Zoom Factor Edit is painted red. Click on the Disc Icon to save to model to disk. Click on the Database Icon to save the model in a Database.

Copyright 2003 fabFORCE.net. All rights reserved. |