Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have to manage an existing DB, created "manually" without mysql-wb.

I want to draw the printable ER diagram.

When I create a relationship, workbench creates its own external key fields.

How can I create the relationship binding to my own fields?

share|improve this question

migrated from Aug 3 '11 at 10:05

This question came from our site for system and network administrators.

Are you using the Place a relationship using existing columns option? Using one of the other options will create a new column in the referencing table, which is mostly useful when you're creating new structure.

You can create relationships by editing the table, going to Foreign Keys, and adding it there manually, as well.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.