Database Tables

enaio® editor 10.10 »

For every cabinet, folder, and document type of the current object definition, you will need to create a table in the database.

The tables contain editable dialog elements for text fields and checkboxes, one column for each. For text fields you enter the database type and the field length via the properties window. For checkboxes and radio buttons the properties are managed automatically.

For radio buttons which are combined by group fields, a column is created.

The database entry for the option which is selected in the client depends on the order of the tab positions. This order may not be edited after data has been entered. Otherwise, you risk data loss or data may be used incorrectly.

All tables contain additional columns which are created and managed automatically, for example for basic parameters.

In addition to these object tables the database contains system tables which are created when enaio® server is installed and are then managed automatically (for example, tables for the user settings). These system tables can be displayed but not modified in enaio® editor.

Before you update the database you should validate the object definition.

Edited or newly created objects are flagged in the workspace with an '!' if they require table adaptation. When saving the object definition you will be notified about necessary changes to tables and can instantly execute them. If extensive changes to tables are necessary, the object definition should be validated first.

Changes will need to be made to tables in the following cases:

  • a new object type was added,
  • a new dialog element of the following type was added:

any text field

a checkbox

a radio button of a new group

a table

  • a new column was added to the 'table' dialog element,
  • the database type of a column of the 'table' dialog element was changed,
  • the database type of a dialog element was changed,
  • the database length of a dialog element was changed

If you update the database tables to match the object definitions they will not be automatically deleted but filed as unused tables.

Unused tables must be deleted before you create new tables.

Additionally, you can create and delete index tables.

The results from the check of and changes to tables will be displayed in the output window. Additionally, you can enter a file in the 'Settings', to which the results should be written.