Fields are created using the " Create a field" command on a table.
The following properties can be defined for a field in the SQL tab:
-
Name: Name of the field.
-
Key: Indicates the type of the attribut (Field).
-
Type: The SQL type of the field.
-
Default value: A default value for the field (editable field).
-
Not null: The SQL NOT NULL property
-
Autogenerated: The SQL AUTO_INCREMENT property
-
Unique: The SQL UNIQUE property
-
Null: The SQL NULL property
-
Check:The SQL CHECK property