Database Relationships

When the Structure view is selected in the toolbar, and a database is selected in the primary sidebar, the Database Structure view is displayed, and by default displays the "Relationships" view.

The Database Relationships view displays all of the tables in the database in a graph representation where each table is a node, connected by edges representing foreign keys.

MySQL currently only supports foreign keys in InnoDB tables, so the foreign key edges will only be displayed for InnoDB tables that have explicity-created foreign keys.

Relationships #

Primary Keys and Foreign Keys are shown with the (P) and (F) icon indicators.
A relationship between tables is shown with an arrow pointing from the table with a foreign key to the table with the primary key.