Add properties to a table definition
In this topic, you learn how to add properties to your database table and make custom settings.
Prerequisites
-
You have configured a table definition.
Procedure
-
In the Cockpit, go to Tools and click Table Definition.
-
Open your database table.
-
Navigate to the Properties tab.
-
Click + Add to add a new column to the table.
-
Enter a column name to each column, for example,
name
,number
,rank
, andsquad
. -
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. -
You can enter a Description and Default value.
-
For columns that can only have unique values, activate Unique.
-
For columns that can have no value, activate Nullable.
If you used the example data in this topic, your properties look like this:
