Database foreignKey MyISAM

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?


1 comment
Comment actions Permalink

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.


Please sign in to leave a comment.