To add a new field, click Add button. A new string is added to the fields list.
Determine field attributes:
Name. Enter field name that describes its purpose.
Identifier. Enter unique table field identifier. An identifier is a sequence of Latin letters, numbers and underscore characters and is used execute SQL queries and set links between tables.
Type/Data Type. In the drop-down list select the type of data to be stored in a table: string, number, real, date, custom.
Total Length. Determine the maximum length of table field: this value represents the number of characters for the string type or the number of digits for the numeric type.
Decimal Places. Determine the number of decimal places for numeric fields.
Empty Values. Determine whether empty values can be stored in the field.
Default Value. If required, determine the value that is automatically entered into every new created table field. For example, one can enter the most frequently occurring value.
Value. Select the field option: Calculated or Non-Calculated. When setting a calculated field, in the Expression box enter the expression to calculate field value. To create an expression, use the expression editor , which opens on clicking the Set Expression button.
To change displayed properties, select or deselect the required properties in the drop-down menu of the Settings button.
Add a field
Add button. A new string is added to the fields list.
Set Expression button.
Settings button.
Delete button. A confirmation dialog box opens.