Primary keys are created using the “ Create a Primary Key” command on a table.
The following properties can be defined for a primary key in the SQL tab:
Name: Name of the primary key
Key: Indicates the type of the attribut (PrimaryKey)
Type: The SQL type of the primary key
Default value: A default value for the primary key (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