Creating a foreign key¶
Foreign keys¶
Foreign keys are created using the “
Create a Foreign Key” command on a table.

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