Skip to content

Create schemas

Next add a schema group (dhtSchemaGroup), a trade table (dhtTrades) and a quote table (dhtQuotes) to the system. Groups are used to organize entities, so a schema group is added first, followed by the schema table definitions to the schema group.

Right-click on dhtPackage and select New > Schema Group from the context menu.

A dialog will appear. Enter the name dhtSchemaGroup and press the Add button.

Screenshot

The schema group editor will open with the schema group.

Screenshot

For now, save the schema group by clicking on the Save button on the right side of the editor.

The schema group will appear in the tree.

Screenshot

Add tables to the schema group.

Right-click on the dhtSchemaGroup and select New > Schema from the context menu.

Screenshot

A dialog will appear. Enter dhtTrades and click the Add button.

Screenshot

A schema editor will open with the Details subtab displayed. Enter a description into the text field.

Screenshot

Make the dhtTrades part of the dhtSchemaGroup. If you used the context menu on the schema group to create the schema then this should already be done. If not, add the group.

Screenshot

Now, provide the column definitions for the dhtTrades table. Column names and ordering are important. Enter the following column names, types, descriptions, and attributes into the schema definition:

Screenshot

Timestamps

To apply a timestamp to the data, add an initial field of type timestamp as the first column in the table.

Once the schema definition is complete, click Save.

Next, add the quote table.

Right-click on dhtSchemaGroup and select New > Schema from the context menu.

A dialog will appear. Enter dhtQuotes as the name of the schema.

Screenshot

The dhtQuotes schema editor appears at the bottom of the screen.

Enter a description into the Description field.

Screenshot

Click on the Group Membership subtab and add the schema to the dhtSchemaGroup using the arrows.

Screenshot

Click on the Schema Table Columns subtab and enter the following information into the table using the Add button.

Screenshot

Once you have entered the schema definition, click on on the Save button on the right side of the editor.

The updated tree will look like:

Screenshot

Now that schemas have been defined, start adding process instances.