Add properties to a table definition

In this topic, you learn how to add properties to your database table and make custom settings.

Prerequisites

Procedure

  1. In the Cockpit, go to Tools and click Table Definition.

  2. Open your database table.

  3. Navigate to the Properties tab.

  4. Click + Add to add a new column to the table.

  5. Enter a column name to each column, for example, name, number, rank, and squad.

  6. In Type, select a data type for the column.

  7. You can enter a Description and Default value.

  8. For columns that can only have unique values, activate Unique.

  9. For columns that can have no value, activate Nullable.

If you used the example data in this topic, your properties look like this:

tabledefinition properties

Results

  • You have added properties to your database table.