Database manager: Adding additional UNIQUE constraints breaks foreign key detection

[Apple]

Wappler 7.3.9
MacOS
NodeJS
MariaDB

Database manager: Adding additional UNIQUE constraints breaks foreign key detection (or some similar issue)

Original:

Adding UNIQUE constrains in a migration:

table.unique(['organization_id', 'user_id']);
table.unique(['organization_id', 'email']);

After schema refresh:

The following tutorial could be used as basis for reproduction:

Using Multi References in the Database Manager

Intro Thanks to multi references in the Database Manager you can define many-to-many relationship between items in two database tables. With many-to-many relations an item from one collections can be referenced to more than one item in another collection. Simple examples: Authors and books - a book may have one or many authors and each author may have written multiple books. Actors and movies - a movie has many actors and each actor may be playing in different movies. Students and classes -…