Skip to content

Creating the Sales Persons Table

You will now create the Sales Persons Table for the Order Entry sample application.

  1. Click the Create New Table button on the Table Explorer toolbar.
    In the Create New Table dialog, type SalesPerson as the Table Name and click OK.
    The new table will open in the Table Editor.

  2. Click on the Add Column toolbar button in the Table Editor to add a new column.
    Type Id as the Name of the first column to add and press the Tab key to move to the Type column. Choose ASCII as the column type from the combo box (you can just type A to do so) and press Tab; make the length 4.0 and press Tab twice to move to the next row.

  3. Type Name as the Name of the next column to add and press the Tab key to move to the Type column. Choose ASCII as the column type from the combo box (you can just type A to do so) and press Tab; make the length 25.0.

  4. Type Avatar as the Name of the next column to add and press the Tab key to move to the Type column. Choose ASCII as the column type from the combo box (you can just type A to do so) and press Tab; make the length 20.0.

When complete, your column definitions will look like those in the image below.

Next, you will add indexes for this table.

  1. Click on the Add Index toolbar button on the Index tab to add a new index.
    Enter the Segments grid and select Id as the column to add as the first index segment from the combo box. This is the only segment for the first index, meaning that we will never be allowed to have two sales persons with the same ID. This is what we want.

The completed index should look like this:

  1. Click on the Add Index toolbar button to add index 2. The segments of this index will be Name and Id.

The completed index should look like this:

  1. Click the Save File toolbar button (or press Ctrl + S) to save the table schema.
    The Output window will display the results of the save operation.
    Note that a Data Dictionary is automatically created when you create a new table (when you save the table the first time).

Next Step

Creating the Vendor Table