SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation MySQL Workbench: Drawing Relationship Lines to Fields

    Couldn't find my original post, but here is a tip for anyone who uses MySQL Workbench and wants it to draw Relationship lines from Field-to-Field...

    (By default, Workbench draws Relationships from the center of one Table to the center of the related Table which I think defeats the purpose of trying to visually show the relationships between Columns?!)


    Original Workbench Relationships:
    Workbench_OrigRelationshipLines.png


    New Workbench Relationships
    Workbench_NewRelationshipLines.png

    How to make the change:
    Once you create an ERD diagram in Workbench, go to "Model", "Relationship Notation", "Connect To Columns" as shown below...
    Workbench_ConnectToColumns.png


    **In fact, if you go under "Model" and play around with "Object Notation" and "Relationship Notation" you can really customize the look and feel of your ERD and get something that works best for you.

    I was just about ready to ditch Workbench because I hated how it drew my ERD's, but now that I figured this out this today, I have an entirely new perspective on things!!

    Hopefully this helps someone else out! (Hey, anytime you can get open-source to do what pay-for-play software purports to offer, I say go the open-source way!!)

    Sincerely,



    TomTees

  2. #2
    SitePoint Addict NetNerd85's Avatar
    Join Date
    Aug 2005
    Location
    Australia
    Posts
    298
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you for this information, Workbench is an awesome program and I have been using it for years. It's like a hidden gem still, how many people use this program? it doesn't seem to be many. I'm still using 5.1, not sure I want everything in the one app. Are you on 5.2 TomTees?
    a new day, a new beginning
    never follow the crowd, the crowd is poor!

  3. #3
    Barefoot on the Moon! silver trophy Force Flow's Avatar
    Join Date
    Jul 2003
    Location
    Northeastern USA
    Posts
    4,603
    Mentioned
    56 Post(s)
    Tagged
    1 Thread(s)
    Good tip...I had been wondering if that very thing could be changed or not, though I hadn't taken the time to look into it. Saves me the trouble
    Visit The Blog | Follow On Twitter
    301tool 1.1.5 - URL redirector & shortener (PHP/MySQL)
    Can be hosted on and utilize your own domain

  4. #4
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by NetNerd85 View Post
    Thank you for this information, Workbench is an awesome program and I have been using it for years. It's like a hidden gem still, how many people use this program? it doesn't seem to be many. I'm still using 5.1, not sure I want everything in the one app. Are you on 5.2 TomTees?
    I am using v5.1.18

  5. #5
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Force Flow View Post
    Good tip...I had been wondering if that very thing could be changed or not, though I hadn't taken the time to look into it. Saves me the trouble
    Yeah, little things like that drive me CRAZY!!! (Glad I rolled up my sleeves and figured it out, because otherwise I was looking to dump MySQL WorkBench!)

    Glad I could help others out!


    TomTees

  6. #6
    Barefoot on the Moon! silver trophy Force Flow's Avatar
    Join Date
    Jul 2003
    Location
    Northeastern USA
    Posts
    4,603
    Mentioned
    56 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by TomTees View Post
    I am using v5.1.18
    I recently upgraded from 5.1.18 to 5.2.29. The UI is a bit better and there have been quite a few bug fixes. I highly recommend the upgrade

    However, the navigation/side panel is on the left by default instead of the right, so to switch it, go to "edit" > "preferences" > "general" tab > check "place sidebar on right side"
    Visit The Blog | Follow On Twitter
    301tool 1.1.5 - URL redirector & shortener (PHP/MySQL)
    Can be hosted on and utilize your own domain


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •