Show/Hide Toolbars

Navigation: Database Structures

Example: Service Level Agreements

Scroll Prev Top Next More

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. Save the table by clicking the Save button. The xSLAID column is created automatically and defined as the primary key.

Docusnap-Tools-Manage-Tables-Creating-table

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

Docusnap-Tools-Manage-Tables-Create-fields

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.

Docusnap-Tools-Manage-Tables-ForeignKey