Foreign key properties

The list at the bottom of the form shows the foreign keys of the current selected table.

A foreign key is defined by a name, the columns in the current table, the type of relation, and the referenced table and columns:

A foreign key relation between tables can be of type Property or Master. See Relations between SQL tables for more details.

To switch the type of table relation, select the three dots at the end of the row and click Switch Type:

This change is shown in the Type column.