In the database model you use the table editor for editing, e.g. the columns of a database table.
In the table editor you edit the contents of an element, e.g. the columns of a database table.
For each type of content element there is a tab in which the elements of this type are shown as rows in a table.
The columns of the table correspond to the properties of the element. 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 database model:
Special features in the table editor for elements of the database model:
In order to exist, a 'Feature in the unique key' requires a column in the table which is not yet in the key.
During creation, a dialog is opened in which one or more columns can be selected to be added to the key.
A 'Feature in the relationship key' can only be created if there are fewer columns 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 column. At the same time, a new column is then created in the database table for the foreign key.
If you want to use an existing column in the foreign key, you can only assign this in the diagram editor by adding it to the foreign key using drag-and-drop.
In order to exist, an 'Indexed table column' requires a column of the table that is not yet in the index.
During creation, a dialog is opened in which one or more columns can be selected to be added to the index.
In order to exist, an 'option' requires there to be an option configured for the element type in the type system. During creation, a dialog is opened in which one or more options can be selected to be added to the element.
© 1986-2014 MID GmbH Nuremberg Germany. DIN EN 9001 certified. All rights reserved.