Example
less than a minute
As a simple example, this section explains how to create an additional table for entering SLAs (Service Level Agreements).
Creating the Table
The first step is to create the table. To do so, click the New button. Then, select Table as the table type and enter the table name, i.e. SLA. In this example, the namespace SlaCust has been assigned. It is not mandatory to enter a namespace. Save the table by clicking the Save button. The xSLAID column is created automatically and defined as the primary key.
Creating Fields
Clicking the Edit Fields button opens the dialog for customizing the fields. In this dialog, additional fields can be created via the New button. The newly created fields are saved via the Save button.
For this example, you need to create the following fields:
| Field Name | Datatype | |
|---|---|---|
| AccountID | Int | |
| Hours | Decimal | |
| Name | String | Field Length: 255 |
| Priority | Int | Reference: {RePriority} |
| Responsible | String | Field Length: 255 |
When you are done creating these fields, select the xAccountID field as the foreign key and the xName field as the display field. When you have selected the foreign key and the display field, click the Save button to save your changes.
