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 select Table Definition.

  2. Open your database table.

  3. Go to the Properties tab.

  4. Select + 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 an SQL data type for the column.

    The data types Smalltext and Mediumtext are not SQL data types, but are data types adapted to SQL notation. Smalltext is a data type that enables text entry with a 256-character limit. Mediumtext is a data type that enables text entry with a 1024-character limit.
  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.