Database foreignKey MyISAM

Hi,
i love the database diagramm tool to visualize the structure. Is there any way to tell PhpStorm about my foreignKeys even if the database itself dosnt support realy foreign keys?

Greetings,
  Psi

1 comment

One dirty-quick workaround that comes to my mind:

1. copy DDL to a separate SQL file
2. make a DDL datasource from it
3. add foreign keys (you can switch dialect if needed, not the case with MySQL)
4. create a diagram for this new datasource.

Another way which is not currently supported but you may add a youtrack issue:
1. create a DDL datasource that inherits the original one.
2. add an SQL script with "alter table add foreign key" statements
3. create a diagram for this new datasource
This workflow may be supported if alter statements will be searched for keys.

0

Please sign in to leave a comment.