The schema editor is used to create and edit the definitions of the database tables. The view of the schema editor is divided into two parts.

On the left side, the definitions of the various database tables are listed in a table:

The column DB-Name contains the technical name of the database table as a value. In edit mode, new table definitions can be created or existing ones modified. The icon in front of the database table definition name indicates the type. The following types exist:

• If a table definition is abstract, it is indicated by  . This means that no corresponding table exists for it in the database. It is only used for modularity.
• "Normal" table definitions are flagged with . Corresponding tables exist for these definitions in the database.
• Associations are indicated by . An association is a special definition of a database table. It contains two additional columns for the source and the target.
• Definitions that restrict their possible extensions to a finite number of database table definitionsare indicated by  .
  
  
  
  The definition needsRoleAware can only be extended by the definitions FastListElt, MetaAttribute, or PersBoundComp.
   

The rest of the view is divided into 4 sections:

Properties

The Properties tab serves as a detailed view for the definition of a database table. In edit mode, the various attributes can be edited here.

Columns

The columns view is divided into two parts. On the left-hand side, the various columns of the selected database table definition are listed. Next to this is the detail view for the selected column. In edit mode, you can also edit the various attributes, create new columns, or delete columns that you no longer need.

Usages

The Usages tab lists all objects that use this type.

For example, Person is the target type of the reference user of the database table LogEntry.

Mapping

The Mapping tab lists which model elements are stored in the database table.