Working in ER Table Editors

In the conceptual model you use the table editor to edit e.g. the attributes of an entity.

What is Edited

In the table editor, contents of an element are edited, e.g. attributes of an entity.

For each type of Content Elements there is a tab in which the elements of this type are shown as rows in a table.

The table columns correspond to the Content Elements properties. The order corresponds to that in the Properties area in the Properties tool window and cannot be modified.

Right-clicking on the column head opens a drop-down list where you can select the displayed properties.

A table editor can be opened for the following elements of the entity relationship model:

Entity with tables for attribute, unique key, foreign key
Unique key with table for Feature in the unique key
Foreign key with table for Feature in the relationship key
View with tables for view attribute and From clause

Special Features

Special features in the table editor for elements of the entity relationship model:

In order to exist, a 'Feature in the unique key' requires an attribute in the entity which is not yet in the key.

During creation, a dialog is opened in which one or more attributes can be selected to be added to the key.
A 'Feature in the relationship key' can only be created if there are fewer attributes in the foreign key than in the unique key referenced.

In this instance, a dialog opens on creation in which you can select the referenced attribute. At the same time, a new attribute is then created in the entity for the foreign key.

If you want to use an existing attribute in the foreign key, you can only assign this in the diagram editor by adding it to the foreign key using drag-and-drop.

Maintaining Views

The views table editor in the entity relationship model contains the Complete View... context menu command for easily maintaining views. The command is also available in the diagrams.

With this command, all attributes that are not yet used in the view although there is an appropriate "From" clause are offered for selection. When you confirm your selection, a linked view attribute is inserted into the database view for each selected attribute.

Searching in the Table

Prerequisites

The table editor contains entries.

Context

You want to find certain entries in the table.

How to proceed

Select Design>Find>Find in Table (Ctrl+Shift+F).

An input field for searching for the string, an arrow icon () for navigating through the search results and an icon for closing the search area appear above the columns. The and icons show you that there are no further search results above or below, respectively.
Enter the string you are looking for in the <Search> input field.

All table cells which contain the string are highlighted and can be navigated through using the and icons.