Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 serverfault.com Aug 3 '11 at 10:05

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

1 Answer 1

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

 
discard

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