Anyone have any particular recommendations for a good tool for building diagrams of MySQL entity relations? I’m looking for something that will easily let me denote field X in table Y relates to field A in table B. MySQL Workbench looked promising, but it only seems to be good for definining relationships between primary keys and when my database definitions didn’t always have indexes on the columns I was trying to relate (small, glue tables where an index actually reduces efficiency) it got buggy as heck.
I’ve tried Dezign, but I want something that’ll label the relationships with column names.
There are quite a few QT/GTK/ KDE ones, but frankly they look really, really awful. Am I going to have to use Access? :)