MySQL Workbench doesn't show relationships between tables when using Reverse Engineering(Mac OS) After running this and successfully creating the database, tables and both the primary and foreign keys, when I reverse engineer my database it won't show the relationships between tables. I'm using a MacBook Air(2017) Mojave 10.14.6, no dark mode and I've tried changing relationships notation from craw's foot to the others but still no luck.

create database test_asdf;
use test_asdf;

create table Department
(id int not null unique auto_increment primary key,
name varchar(30));

create table Professor
(id int not null unique auto_increment primary key,
name varchar(30),
adress varchar(50),
department_id int,
section_id int,
foreign key (department_id) references Department(id));


Now the thing is when I run the following the connections show:

create database test_asdf8;
use test_asdf8;

create table table1
(id int not null unique auto_increment primary key,
name varchar(30),
table2_id int);

create table table2
(id int not null unique auto_increment primary key,
name varchar(30),
new_id int,
foreign key (new_id) references table1(id));




Could someone please point out what I'm doing wrong here?
After further research it seems this is actually a bug.
Instead of directly reverse-engineering your database:

create a new model

save all your code in an .sql file

while in the model tab go to file-import-reverse engineer create script

check &quot;place imported objects on diagram&quot; and execute and there you go


Still unsure why the first above example won't work(with the straightforward approach) and the second one will but well... hope this helps.