Foreign keys

Foreign keys are created using the "image Create a Foreign Key" command on a table.

3
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 "image Create a foreign primary key" command on a table.